Groups | Blog | Home
all groups > sql server (microsoft) > october 2004 >

sql server (microsoft) : msdb database marked suspect


Trifon Triantafillidis
10/20/2004 12:57:02 PM
In my SQL server installation the msdb database has been marked "suspect"
and also the SQL agent cannot be started. Also I can not define any backups
in database management plans (there was on but now it is not working).

The rest database seems to work fine for more than 2 weeks now.

Any ideas?

Thanks

mmmc_reptail NO[at]SPAM hotmail.com
11/1/2004 7:13:04 AM
[quoted text, click to view]

Hi,

SQL Server sets the database to suspect status for example if some
database files are missing or files are somehow corrupted.
You can reset the status of the database with sp_resetstatus
procedure.
You should look the description for sp_resetstatus from BOL.
Here's a link to the online version.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_servdatabse_494j.asp

You should be careful and follow the examples given in that article
so that you won't do anymore damage when doing that operation.

I've had the same problem once and I got it working with the
instructions in that BOL article.

----
AddThis Social Bookmark Button