MSSQLSERVER_926
Applies to:
SQL Server
Details
Attribute | Value |
---|---|
Product Name | SQL Server |
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 errorlog for more information. |
Explanation
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 SQL Server.
Attaching a database.
Using the RESTORE database or RESTORE LOG procedures.
User Action
Inspect the 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.
See Also
Back Up and Restore of SQL Server Databases
RESTORE (Transact-SQL)
sys.sysdatabases (Transact-SQL)
Database Detach and Attach (SQL Server)
Visszajelzés
https://aka.ms/ContentUserFeedback.
Hamarosan elérhető: 2024-ben fokozatosan kivezetjük a GitHub-problémákat a tartalom visszajelzési mechanizmusaként, és lecseréljük egy új visszajelzési rendszerre. További információ:Visszajelzés küldése és megtekintése a következőhöz: