|
|
|
#1 |
|
Messages: n/a
Hébergeur: |
Hi all,
All of a suddent yesterday morning one of my DEV SQL Boxes started reporting MSDB as suspect. I tried to follow the instructions outlined in http://winzenz.blogspot.com/2006/09/...databases.html to restore MSDB, however when I try to start sql server using the trace flag I get the following error: Your SQL Server installation is either corrupt or has been tampered with (SQL Registry Version not Same as Server). Please uninstall then re-run setup to correct this problem. Any ideas? TIA! |
|
|
|
#2 |
|
Messages: n/a
Hébergeur: |
<paramr@community.nospam> wrote in message news:%23TWtt43CJHA.4176@TK2MSFTNGP04.phx.gbl... > Hi all, > > All of a suddent yesterday morning one of my DEV SQL Boxes started > reporting MSDB as suspect. I tried to follow the instructions outlined in > http://winzenz.blogspot.com/2006/09/...databases.html to > restore MSDB, however when I try to start sql server using the trace flag > I get the following error: > > Your SQL Server installation is either corrupt or has been tampered with > (SQL Registry Version not Same as Server). Please uninstall then re-run > setup to correct this problem. > > Any ideas? > > TIA! Hi Do you get any information in the SQL Server log? You should still be able to start up SQL Server with start sqlservr.exe -c -T3608 The comments on the article you posted indicate that you may need to do more than what was just in the article and force the creation of a new database, this is also reflected in http://groups.google.com/group/sql-s...ing-msdb?hl=en Alternatively if you have a backup of MSDB it could be restored and detatched on another server and then replace the existing files with it. John |
|
|
|
#3 |
|
Messages: n/a
Hébergeur: |
Thanks. That worked.
"John Bell" <jbellnewsposts@hotmail.com> wrote in message news:%235qZk45CJHA.5060@TK2MSFTNGP03.phx.gbl... > > <paramr@community.nospam> wrote in message > news:%23TWtt43CJHA.4176@TK2MSFTNGP04.phx.gbl... >> Hi all, >> >> All of a suddent yesterday morning one of my DEV SQL Boxes started >> reporting MSDB as suspect. I tried to follow the instructions outlined in >> http://winzenz.blogspot.com/2006/09/...databases.html to >> restore MSDB, however when I try to start sql server using the trace flag >> I get the following error: >> >> Your SQL Server installation is either corrupt or has been tampered with >> (SQL Registry Version not Same as Server). Please uninstall then re-run >> setup to correct this problem. >> >> Any ideas? >> >> TIA! > Hi > > Do you get any information in the SQL Server log? > > You should still be able to start up SQL Server with > > start sqlservr.exe -c -T3608 > > The comments on the article you posted indicate that you may need to do > more than what was just in the article and force the creation of a new > database, this is also reflected in > > http://groups.google.com/group/sql-s...ing-msdb?hl=en > > Alternatively if you have a backup of MSDB it could be restored and > detatched on another server and then replace the existing files with it. > > John |
|
![]() |
| Outils de la discussion | |
|
|