How to take out a Database from suspect mode?
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
Use the xp_resetstatus T-SQL command to take out the problem database from suspect mode
Syntax:
sp_resetstatus [ @dbname = ] 'database'
Arguments
[@dbname=]'database'
Is the name of the database to reset.databaseissysname, with no default
Return Code Values
0 (success) or 1 (failure)
Permission needed:
Requires membership in thesysadminfixed server role.
Example:
EXEC sp_resetstatus 'AdventureWorks';
Suggested:
The SQL Server error log should be consulted and all problems resolved before running this procedure. Stop and restart the instance of SQL Server after execute.
Please check the books online for xp_resetstatus
Reference:
http://msdn2.microsoft.com/en-us/library/ms188424.aspx
