Rajiv Parekh writes "Since last few weeks on Startup of System few Databases moves to SUSPECT MODE. This probelm is not daily but atleast 0nce in week.The day is is not fixed. Have Unistalled SQL & again Reinstalled, but the problem continues. Please inform my Why this problem & what is the Solution."
Please post the errorlog messages... what version of SQL Server are you running?
You say that this happens on startup - are you continually restarting SQL Server? If so, why? If not, do you mean that the databases are getting throw into suspect mode during normal operations?
Thanks
Paul Randal Lead Program Manager, Microsoft SQL Server Core Storage Engine (Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
>> This probelm is not daily but atleast 0nce in week. And you weren't worried about it?
Have a look at the windows event log and see if you are getting errors. Do long running updates occasionally fail with odd errors?
========================================== Cursors are useful if you don't know sql. DTS can be used in a similar way. Beer is not cold and it isn't fizzy.
SQL 2000Server Database Moves to SUSPECT Mode
Posted - 10/18/2006 : 08:06:41
