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.....
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)
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
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.