3414

Product

Name

Event ID

3414

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

REC_GIVEUP

Message

Text

An error occurred during recovery, preventing the database ’%.*ls’ (database ID %d) from

restarting. Diagnose the recovery errors and fix them, or restore from a known good

backup. If errors are not corrected or expected, contact Technical Support.

The specified database was recovered, but failed to start, because errors occurred during

recovery. This error has put the database in the SUSPECT state. The primary filegroup, and

possibly other filegroups, are suspect and may be damaged. The database cannot be recovered

during startup of SQL Server and is therefore unavailable. User action is required to resolve the

problem. You will see the SUSPECT status in both SQL Server Management Studio (next to the

database icon) and when you look at the sys.databases.state_desc column. Any attempt to use

a database in this state will result in the following error:

Note that when this error occurs in

, the SQL Server instance shuts down.

ﾉ

Expand table

Msg 926, Level 14, State 1, Line 1
Database 'mydb' cannot be opened. It has been marked SUSPECT by recovery. See the errorlog for more information