DBCC CHECKDB fails and quits job, ambiguous error message.
Posted
by ddono25
on Server Fault
See other posts from Server Fault
or by ddono25
Published on 2010-04-20T17:05:00Z
Indexed on
2010/04/20
17:13 UTC
Read the original article
Hit count: 215
I received a notice that one of our servers' DBCC CHECKDB for all databases has been failing the past four times it has been run. We don't have any data prior to that, but it doesn't look like it has been succeeding for awhile. There are no errors in the log file only:
DBCC results for 'sys.sysxmlfacet'. [SQLSTATE 01000]
Msg 0, Sev 0, State 1: Unspecified error occurred on SQL Server. Connection may have been terminated by the server. [SQLSTATE HY000]
There are 112 rows in 1 pages for object "sys.sysxmlfacet". [SQLSTATE 01000]
I ran a DBCC CHECKDB using sp_MSForEachDB to get more accurate results and had the same error on the same DB but at a separate point:
DBCC results for 'NameValuePair_Greek_CI_AS'. [SQLSTATE 01000]
Msg 0, Sev 0, State 1: Unspecified error occurred on SQL Server. Connection may have been terminated by the server. [SQLSTATE HY000]
There are 0 rows in 0 pages for object "NameValuePair_Greek_CI_AS". [SQLSTATE 01000]
Also, the error-log states that the DBCC completed without errors for this database.
I can't figure out how to track down this ambiguous issue that only happens on this database out of the dozens on this server. Any help is appreciated!
© Server Fault or respective owner