Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
schuhtl
Posting Yak Master
102 Posts |
 Posted - 2005-01-31 : 16:02:30
|
| What are the best steps to take to get a suspect master database functional? I have never had a suspect master database before, just user databases. I do have a recent backup of the master.... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-01-31 : 17:23:23
|
| You first need to run sp_resetstatus. If that works successfully, then you need to find out why the database went suspect in the first place. Check out Event Viewer for information. Make sure to run disk diagnostics as disk issues are usually the cause of this. If the sp_resetstatus doesn't work, then you'll probably need to restore your databases.Tara |
 |
|
|
schuhtl
Posting Yak Master
102 Posts |
Posted - 2005-02-01 : 08:54:47
|
| Thanks for the quick response, I ended up just restoring the master, msdb & user databases and everything looks fine now. |
|
|
|
|
|
|
Suspect master, msdb & user databases