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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2007-12-14 : 03:59:44
|
| Dear Experts,in one of our servers, the MSDB database is in suspect mode, and i've used the command sp_resetstatusand i restarted the service also but still it is in suspect mode.how can i change that to normal state?it is asking to check the errorlog.VinodEven you learn 1%, Learn it with 100% confidence. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-15 : 01:19:06
|
| Did you check sql server log? Have to find out root cause first. |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2007-12-16 : 22:44:01
|
| where can i find sql server log?VinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-16 : 23:21:33
|
| Under management -> sql server logs in em (sql2k) or ssms (sql2k5). |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2007-12-16 : 23:41:15
|
| yes i have found the sql server error logs...there are archieve1.......archieve6 are there how can i found the root cause now? i'm using sql2k5it is showing error number 926VinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-17 : 00:46:47
|
| What's error message? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-17 : 00:50:29
|
| Take look at kb article 'Error messages may be logged in the SQL Server error log after you run a DBCC command in SQL Server 2005' to see if it's the case. |
|
|
|
|
|
|
msdb database in suspect