July 11, 2005 at 5:54 pm
Would somebody please help me with a solution as to how I can recover from the above error. One database out of a few is returning the 'SUSPECT' error in the Enterprise Manager. This usually occurs when the server is restarted either deliberately or on power failures. The Ms-SQL version is 7.
Themba
July 11, 2005 at 7:21 pm
FROM BOL 2000
sp_resetstatus turns off the suspect flag on a database. This procedure updates the mode and status columns of the named database in sysdatabases. The SQL Server error log should be consulted and all problems resolved before running this procedure. Stop and restart SQL Server after executing sp_resetstatus.
A database can become suspect for several reasons. Possible causes include denial of access to a database resource by the operating system, and the unavailability or corruption of one or more database files.
This example resets the status of the PUBS database.
EXEC sp_resetstatus 'PUBS'
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply