5 replies
by syafii
There are few reasons why SQL dbs became suspect mode. Have you tried manually start and stop the SQL services beside rebooting. Did you not see any SQL Server return error codes when the dbs became suspect, as to what actually happen to your devices.
Cheers
by awinterrowd
Suspect mode means some Kind of corruption may have taken place. Whatever the corruption level is, when you bring down and up the servers, you may be loosing one or more transactions, probably the suspected one.
Before shuting down SQL, watch the sql error log and the current activity window, dont' forget the event viewer too.
Issue a Dunp transaction with no_log in order to turn suspect off. If the problem persist, you can analize the dumped transaction file with a log analizer in order to see where it may came from.
by awinterrowd
by awinterrowd
This discussion is closed to new replies.
Trending Windows Forum posts
Sort by Trending