SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2008 R2
Product Documentation
SQL Server 2008 R2 Books Online
Database Engine
Technical Reference
Errors and Events Reference
Database Engine Events and Errors
Cause and Resolution of Database Engine Errors
MSSQLSERVER_-2
MSSQLSERVER_-1
MSSQLSERVER_2
MSSQLSERVER_53
MSSQLSERVER_107
MSSQLSERVER_125
MSSQLSERVER_137
MSSQLSERVER_207
MSSQLSERVER_208
MSSQLSERVER_233
MSSQLSERVER_360
MSSQLSERVER_511
MSSQLSERVER_601
MSSQLSERVER_605
MSSQLSERVER_611
MSSQLSERVER_617
MSSQLSERVER_701
MSSQLSERVER_802
MSSQLSERVER_823
MSSQLSERVER_824
MSSQLSERVER_825
MSSQLSERVER_833
MSSQLSERVER_844
MSSQLSERVER_845
MSSQLSERVER_846
MSSQLSERVER_847
MSSQLSERVER_905
MSSQLSERVER_916
MSSQLSERVER_926
MSSQLSERVER_945
MSSQLSERVER_948
MSSQLSERVER_1101
MSSQLSERVER_1105
MSSQLSERVER_1203
MSSQLSERVER_1204
MSSQLSERVER_1205
MSSQLSERVER_1222
MSSQLSERVER_1401
MSSQLSERVER_1406
MSSQLSERVER_1418
MSSQLSERVER_1457
MSSQLSERVER_1458
MSSQLSERVER_1461
MSSQLSERVER_1462
MSSQLSERVER_1505
MSSQLSERVER_1803
MSSQLSERVER_1807
MSSQLSERVER_1904
MSSQLSERVER_2020
MSSQLSERVER_2501
MSSQLSERVER_2508
MSSQLSERVER_2511
MSSQLSERVER_2512
MSSQLSERVER_2515
MSSQLSERVER_2516
MSSQLSERVER_2518
MSSQLSERVER_2519
MSSQLSERVER_2522
MSSQLSERVER_2527
MSSQLSERVER_2530
MSSQLSERVER_2533
MSSQLSERVER_2534
MSSQLSERVER_2536
MSSQLSERVER_2537
MSSQLSERVER_2538
MSSQLSERVER_2539
MSSQLSERVER_2540
MSSQLSERVER_2546
MSSQLSERVER_2570
MSSQLSERVER_2574
MSSQLSERVER_2575
MSSQLSERVER_2576
MSSQLSERVER_2577
MSSQLSERVER_2579
MSSQLSERVER_2592
MSSQLSERVER_2593
MSSQLSERVER_2596
MSSQLSERVER_2814
MSSQLSERVER_3151
MSSQLSERVER_3156
MSSQLSERVER_3159
MSSQLSERVER_3168
MSSQLSERVER_3169
MSSQLSERVER_3176
MSSQLSERVER_3181
MSSQLSERVER_3260
MSSQLSERVER_3271
MSSQLSERVER_3313
MSSQLSERVER_3314
MSSQLSERVER_3413
MSSQLSERVER_3414
MSSQLSERVER_3417
MSSQLSERVER_3431
MSSQLSERVER_3437
MSSQLSERVER_3452
MSSQLSERVER_3456
MSSQLSERVER_3619
MSSQLSERVER_3937
MSSQLSERVER_3961
MSSQLSERVER_4064
MSSQLSERVER_4104
MSSQLSERVER_4186
MSSQLSERVER_4846
MSSQLSERVER_5228
MSSQLSERVER_5229
MSSQLSERVER_5231
MSSQLSERVER_5233
MSSQLSERVER_5235
MSSQLSERVER_5237
MSSQLSERVER_5242
MSSQLSERVER_5243
MSSQLSERVER_5245
MSSQLSERVER_5250
MSSQLSERVER_5256
MSSQLSERVER_5512
MSSQLSERVER_5515
MSSQLSERVER_5554
MSSQLSERVER_7308
MSSQLSERVER_7711
MSSQLSERVER_7901
MSSQLSERVER_7903
MSSQLSERVER_7904
MSSQLSERVER_7905
MSSQLSERVER_7906
MSSQLSERVER_7907
MSSQLSERVER_7908
MSSQLSERVER_7910
MSSQLSERVER_7911
MSSQLSERVER_7912
MSSQLSERVER_7913
MSSQLSERVER_7914
MSSQLSERVER_7915
MSSQLSERVER_7916
MSSQLSERVER_7920
MSSQLSERVER_7923
MSSQLSERVER_7931
MSSQLSERVER_7932
MSSQLSERVER_7933
MSSQLSERVER_7934
MSSQLSERVER_7935
MSSQLSERVER_7936
MSSQLSERVER_7937
MSSQLSERVER_7984
MSSQLSERVER_7986
MSSQLSERVER_7987
MSSQLSERVER_7988
MSSQLSERVER_7995
MSSQLSERVER_8443
MSSQLSERVER_8525
MSSQLSERVER_8601
MSSQLSERVER_8621
MSSQLSERVER_8630
MSSQLSERVER_8642
MSSQLSERVER_8645
MSSQLSERVER_8649
MSSQLSERVER_8651
MSSQLSERVER_8680
MSSQLSERVER_8689
MSSQLSERVER_8710
MSSQLSERVER_8712
MSSQLSERVER_8966
MSSQLSERVER_8974
MSSQLSERVER_8992
MSSQLSERVER_8993
MSSQLSERVER_8994
MSSQLSERVER_8996
MSSQLSERVER_9001
MSSQLSERVER_9002
MSSQLSERVER_9003
MSSQLSERVER_9004
MSSQLSERVER_9524
MSSQLSERVER_9532
MSSQLSERVER_9692
MSSQLSERVER_9790
MSSQLSERVER_9955
MSSQLSERVER_10001
MSSQLSERVER_10003
MSSQLSERVER_10060
MSSQLSERVER_10061
MSSQLSERVER_10502
MSSQLSERVER_10507
MSSQLSERVER_10509
MSSQLSERVER_10519
MSSQLSERVER_10520
MSSQLSERVER_10521
MSSQLSERVER_10531
MSSQLSERVER_10532
MSSQLSERVER_10533
MSSQLSERVER_10534
MSSQLSERVER_10535
MSSQLSERVER_10536
MSSQLSERVER_10537
MSSQLSERVER_10538
MSSQLSERVER_10539
MSSQLSERVER_10737
MSSQLSERVER_11001
MSSQLSERVER_11409
MSSQLSERVER_14265
MSSQLSERVER_14420
MSSQLSERVER_14421
MSSQLSERVER_15661
MSSQLSERVER_17053
MSSQLSERVER_17065
MSSQLSERVER_17066
MSSQLSERVER_17067
MSSQLSERVER_17128
MSSQLSERVER_17130
MSSQLSERVER_17132
MSSQLSERVER_17142
MSSQLSERVER_17147
MSSQLSERVER_17148
MSSQLSERVER_17179
MSSQLSERVER_17194
MSSQLSERVER_17204
MSSQLSERVER_17300
MSSQLSERVER_17660
MSSQLSERVER_17676
MSSQLSERVER_17803
MSSQLSERVER_17809
MSSQLSERVER_17832
MSSQLSERVER_17883
MSSQLSERVER_17884
MSSQLSERVER_17887
MSSQLSERVER_18264
MSSQLSERVER_18452
MSSQLSERVER_18456
MSSQLSERVER_18752
MSSQLSERVER_20557
MSSQLSERVER_21862
MSSQLSERVER_26013
MSSQLSERVER_26014
MSSQLSERVER_30053
MSSQLSERVER_30089
MSSQLSERVER_32040
MSSQLSERVER_32042
MSSQLSERVER_32043
MSSQLSERVER_32044
MSSQLSERVER_33027
MSSQLSERVER_33028
MSSQLSERVER_33085
Expand Minimize
This topic has not yet been rated - Rate this topic

MSSQLSERVER_926

SQL Server 2008 R2

Product Name

SQL Server

Product Version

10.50

Product Build Number

-

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.

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.

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.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.