Friday, 17 January 2014

database msdb cannot be opened it has marked suspect by recovery

Hello Freinds,
 today i am facing a serious error in sql server database
 when i open sql server management studio first it will not logging from my sa user account, then i will logged in from window authentication, then i was expand my database it will shown a error.....

Database 'msdb' cannot be openned. It has been marked SUSPECT by recovery.


First I have tried starting SQL Server exe with the following parameters
which has not allowed me to login to the server.

-c -m
-c -T3806

but sql server not started.

i was just the find the solutions of it 
Simple way to resolve the "msdb cannot be opened. it has been marked suspect by recovery" issue,just run the INSTMSDB.SQL script, which is under SQL server install directory under INSTALL folder.
This script can be re-run WITHOUT causing loss of data, hence we only create the database if it missing (if the database already exists we test that it has enough free space and if not we expand both the device and the database)

No comments:

Post a Comment

Note: only a member of this blog may post a comment.