sql 2005 - msdb suspect

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

paramr@community.nospam - 31 Aug 2008 16:28 GMT

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/fixing-suspect-sql-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!

Reply to this Message

John Bell - 31 Aug 2008 19:55 GMT

> Hi all,
>
[quoted text clipped - 11 lines]
>
> 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-server-issues-and-answers/web/rebuilding-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

Reply to this Message

paramr@community.nospam - 31 Aug 2008 23:48 GMT

Thanks. That worked.

>> Hi all,
>>
[quoted text clipped - 29 lines]
>
> John

Reply to this Message