Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

MSSQLSERVER_926

New: 12 December 2006

Product Name

SQL Server

Product Version

9.0

Product Build Number

9.00.1399.60

Event ID

926

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

DB_SUSPECT

Message Text

Database '%.*ls' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server error log for more information.

The database is marked as suspect because it failed the recovery process that brings a database to a consistent transactional state. This can occur during the following operations:

  • Starting up an instance of Microsoft® SQL Server™ 2000 or SQL Server 2005.
  • Attaching a database.
  • Using the RESTORE database or RESTORE LOG procedures.

Inspect the Microsoft SQL Server error log and determine the cause of the error. If SQL Server has been restarted since the failed recovery, look at previous SQL Server error logs to see the reason why recovery failed.

If the recovery failed because of a persistent I/O error, a torn page, or other possible hardware problem, resolve the underlying hardware problem and restore the database by using a backup. If no backups are available, consider the repair options of DBCC CHECKDB.

If you are unable to resolve this problem, contact your primary support provider. Have the SQL Server error log available for review.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.