Click here for SQL Server 2005 & SQL Server 2008 suspect database.

For SQL Server 2000: Prior to resetting examine if all database files are OK. Check SQL Server error log and Event Viewer for related messages. Check for file sharing issues, file backup and anti-virus software. To reset execute the following script in Query Analyzer:

-- SQL Server database suspect - SQL Server database marked suspect

-- How to recover a database marked suspect

sp_configure "Allow updates" , 1

go

update sysdatabases

set status = status & ~ 256

where (name = 'SuspectDatabaseName')

go

sp_configure "Allow updates" , 0

go