Suspect status of a database in SQL Server

SQL Server gives a database 'suspect' status when it is unable to recover the database .

Reasons may be many , may be a torn page detection , may be datafile location no found.

SQL Server pages are 8KB. Windows 2000 disk I/O operations, however, use 512 byte sectors. If an unexpected outage or power failure occurs, a 'torn' page can result, with the 8KB-page write not completely written. Enabling the TORN_PAGE_DETECTION option allows SQL Server to detect incomplete I/O operations. If a torn page occurs when the database is online, an I/O error is raised and the connection is killed;