September 19, 2010 at 10:10 am
hi all,
i have 3 sql backup files, march_backup.bak, april_backup.bak and may_backup.bak.
i restored march_backup.bak and running
DBCC CHECKDB 'myWorkflowDB'
i got the following errors, Pls let me know if there is a way to recover besides restoring from previous backups or maybe someone can help me to to describe the error.
Any help is appreciated.
our system is running with SQL Server 2005 SP3 itanium, win server 2003 and we also using SAN storage MSA 1000.
============
Msg 8967, Level 16, State 216, Line 1
An internal error occurred in DBCC that prevented further processing. Contact Customer Support Services.
DBCC results for 'mydb'.
Msg 8921, Level 16, State 1, Line 1
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
DBCC results for 'sys.sysrowsetcolumns'.
There are 2678 rows in 20 pages for object "sys.sysrowsetcolumns".
DBCC results for 'sys.sysrowsets'.
There are 313 rows in 4 pages for object "sys.sysrowsets".
DBCC results for 'sysallocunits'.
There are 358 rows in 8 pages for object "sysallocunits".
DBCC results for 'sys.sysfiles1'.
There are 2 rows in 1 pages for object "sys.sysfiles1".
DBCC results for 'sys.syshobtcolumns'.
There are 2822 rows in 22 pages for object "sys.syshobtcolumns".
DBCC results for 'sys.syshobts'.
There are 313 rows in 4 pages for object "sys.syshobts".
DBCC results for 'sys.sysftinds'.
There are 0 rows in 0 pages for object "sys.sysftinds".
DBCC results for 'sys.sysserefs'.
There are 358 rows in 2 pages for object "sys.sysserefs".
DBCC results for 'sys.sysowners'.
There are 17 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysprivs'.
There are 126 rows in 1 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 1086 rows in 22 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 8363 rows in 143 pages for object "sys.syscolpars".
DBCC results for 'sys.sysnsobjs'.
There are 1 rows in 1 pages for object "sys.sysnsobjs".
DBCC results for 'sys.syscerts'.
There are 0 rows in 0 pages for object "sys.syscerts".
DBCC results for 'sys.sysxprops'.
There are 0 rows in 0 pages for object "sys.sysxprops".
DBCC results for 'sys.sysscalartypes'.
There are 30 rows in 1 pages for object "sys.sysscalartypes".
DBCC results for 'sys.systypedsubobjs'.
There are 0 rows in 0 pages for object "sys.systypedsubobjs".
DBCC results for 'sys.sysidxstats'.
There are 1051 rows in 22 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 1763 rows in 10 pages for object "sys.sysiscols".
DBCC results for 'sys.sysbinobjs'.
There are 23 rows in 1 pages for object "sys.sysbinobjs".
DBCC results for 'sys.sysobjvalues'.
There are 1981 rows in 593 pages for object "sys.sysobjvalues".
DBCC results for 'sys.sysclsobjs'.
There are 15 rows in 1 pages for object "sys.sysclsobjs".
DBCC results for 'sys.sysrowsetrefs'.
There are 0 rows in 0 pages for object "sys.sysrowsetrefs".
DBCC results for 'sys.sysremsvcbinds'.
There are 0 rows in 0 pages for object "sys.sysremsvcbinds".
DBCC results for 'sys.sysxmitqueue'.
There are 0 rows in 0 pages for object "sys.sysxmitqueue".
DBCC results for 'sys.sysrts'.
There are 1 rows in 1 pages for object "sys.sysrts".
DBCC results for 'sys.sysconvgroup'.
There are 0 rows in 0 pages for object "sys.sysconvgroup".
DBCC results for 'sys.sysdesend'.
There are 0 rows in 0 pages for object "sys.sysdesend".
DBCC results for 'sys.sysdercv'.
There are 0 rows in 0 pages for object "sys.sysdercv".
DBCC results for 'sys.syssingleobjrefs'.
There are 134 rows in 1 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 14783 rows in 107 pages for object "sys.sysmultiobjrefs".
DBCC results for 'sys.sysdbfiles'.
There are 2 rows in 1 pages for object "sys.sysdbfiles".
DBCC results for 'sys.sysguidrefs'.
There are 0 rows in 0 pages for object "sys.sysguidrefs".
DBCC results for 'sys.sysqnames'.
There are 91 rows in 1 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 93 rows in 1 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 97 rows in 1 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 17 rows in 1 pages for object "sys.sysxmlplacement".
DBCC results for 'sys.sysobjkeycrypts'.
There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".
DBCC results for 'sys.sysasymkeys'.
There are 0 rows in 0 pages for object "sys.sysasymkeys".
DBCC results for 'sys.syssqlguides'.
There are 0 rows in 0 pages for object "sys.syssqlguides".
DBCC results for 'sys.sysbinsubobjs'.
There are 9 rows in 1 pages for object "Roles".
DBCC results for 'AllDocs'.
Msg 8928, Level 16, State 1, Line 1
Object ID 53575229, index ID 1, partition ID 72057594149142528, alloc unit ID 72057594151043072 (type In-row data): Page (1:3276839) could not be processed. See other errors for details.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 53575229, index ID 1, partition ID 72057594149142528, alloc unit ID 72057594151043072 (type In-row data), page (1:3276839). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 29493257 and -4.
Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 53575229, index ID 1, partition ID 72057594149142528, alloc unit ID 72057594151043072 (type In-row data). Page (1:3276839) was not seen in the scan although its parent (1:3232327) and previous (1:3276838) refer to it. Check any previous errors.
Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 53575229, index ID 1, partition ID 72057594149142528, alloc unit ID 72057594151043072 (type In-row data). Page (1:3276848) is missing a reference from previous page (1:3276839). Possible chain linkage problem.
There are 1627892 rows in 97494 pages for object "AllDocs".
CHECKDB found 0 allocation errors and 4 consistency errors in table 'AllDocs' (object ID 53575229).
DBCC results for 'NameValuePair_Hebrew_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Hebrew_CI_AS".
DBCC results for 'NameValuePair_Hindi_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Hindi_CI_AS".
DBCC results for 'RoleAssignment'.
There are 36099 rows in 427 pages for object "RoleAssignment".
DBCC results for 'NameValuePair_Hungarian_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Hungarian_CI_AS".
DBCC results for 'NameValuePair_Hungarian_Technical_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Hungarian_Technical_CI_AS".
DBCC results for 'NameValuePair_Icelandic_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Icelandic_CI_AS".
DBCC results for 'NameValuePair_Japanese_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Japanese_CI_AS".
DBCC results for 'NameValuePair_Japanese_Unicode_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Japanese_Unicode_CI_AS".
DBCC results for 'AllDocStreams'.
Msg 8928, Level 16, State 1, Line 1
Object ID 277576027, index ID 1, partition ID 72057594151305216, alloc unit ID 72057594043826176 (type LOB data): Page (1:3948896) could not be processed. See other errors for details.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 277576027, index ID 1, partition ID 72057594151305216, alloc unit ID 72057594043826176 (type LOB data), page (1:3948896). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 29493257 and -4.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 277576027, index ID 1, partition ID 72057594151305216, alloc unit ID 72057594043826176 (type LOB data). The off-row data node at page (1:3948896), slot 0, text ID 1638158761984 is referenced by page (1:3948883), slot 0, but was not seen in the scan.
Msg 8929, Level 16, State 1, Line 1
Object ID 277576027, index ID 1, partition ID 72057594151305216, alloc unit ID 72057594153205760 (type In-row data): Errors found in off-row data with ID 1638158761984 owned by data record identified by RID = (1:4086385:34)
There are 178407 rows in 2796 pages for object "AllDocStreams".
CHECKDB found 0 allocation errors and 4 consistency errors in table 'AllDocStreams' (object ID 277576027).
DBCC results for 'NameValuePair_Korean_Wansung_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Korean_Wansung_CI_AS".
DBCC results for 'NameValuePair_Korean_Wansung_Unicode_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Korean_Wansung_Unicode_CI_AS".
DBCC results for 'NameValuePair_Latin1_General_CI_AS'.
There are 108 rows in 2 pages for object "NameValuePair_Latin1_General_CI_AS".
DBCC results for 'NameValuePair_Latvian_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Latvian_CI_AS".
DBCC results for 'AllDocVersions'.
Msg 8928, Level 16, State 1, Line 1
Object ID 405576483, index ID 1, partition ID 72057594152615936, alloc unit ID 72057594044088320 (type LOB data): Page (1:3480652) could not be processed. See other errors for details.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 405576483, index ID 1, partition ID 72057594152615936, alloc unit ID 72057594044088320 (type LOB data), page (1:3480652). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 29493257 and -4.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 405576483, index ID 1, partition ID 72057594152615936, alloc unit ID 72057594044088320 (type LOB data). The off-row data node at page (1:3480652), slot 0, text ID 458727817216 is referenced by page (1:3474995), slot 0, but was not seen in the scan.
Msg 8928, Level 16, State 1, Line 1
Object ID 405576483, index ID 1, partition ID 72057594152615936, alloc unit ID 72057594044088320 (type LOB data): Page (1:3509083) could not be processed. See other errors for details.
Msg 8939, Level 16, State 98, Line 1
Table error: Object ID 405576483, index ID 1, partition ID 72057594152615936, alloc unit ID 72057594044088320 (type LOB data), page (1:3509083). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 29493257 and -4.
Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 405576483, index ID 1, partition ID 72057594152615936, alloc unit ID 72057594044088320 (type LOB data). The off-row data node at page (1:3509083), slot 0, text ID 460158337024 is referenced by page (1:3506582), slot 0, but was not seen in the scan.
Msg 8929, Level 16, State 1, Line 1
Object ID 405576483, index ID 1, partition ID 72057594152615936, alloc unit ID 72057594154516480 (type In-row data): Errors found in off-row data with ID 458727817216 owned by data record identified by RID = (1:4098893:7)
Msg 8929, Level 16, State 1, Line 1
Object ID 405576483, index ID 1, partition ID 72057594152615936, alloc unit ID 72057594154516480 (type In-row data): Errors found in off-row data with ID 460158337024 owned by data record identified by RID = (1:4098893:14)
There are 16184 rows in 331 pages for object "AllDocVersions".
CHECKDB found 0 allocation errors and 8 consistency errors in table 'AllDocVersions' (object ID 405576483).
DBCC results for 'NameValuePair_Lithuanian_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Lithuanian_CI_AS".
DBCC results for 'NameValuePair_Lithuanian_Classic_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Lithuanian_Classic_CI_AS".
DBCC results for 'NameValuePair_Traditional_Spanish_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Traditional_Spanish_CI_AS".
DBCC results for 'AllLinks'.
There are 25433 rows in 1404 pages for object "AllLinks".
DBCC results for 'DatabaseInformation'.
There are 1 rows in 1 pages for object "DatabaseInformation".
DBCC results for 'NameValuePair_Modern_Spanish_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Modern_Spanish_CI_AS".
DBCC results for 'NameValuePair_Polish_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Polish_CI_AS".
DBCC results for 'NavNodes'.
There are 1138 rows in 25 pages for object "NavNodes".
DBCC results for 'NameValuePair_Romanian_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Romanian_CI_AS".
DBCC results for 'RecycleBin'.
There are 3100 rows in 788 pages for object "RecycleBin".
DBCC results for 'NameValuePair_Slovak_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Slovak_CI_AS".
DBCC results for 'Sites'.
There are 1 rows in 1 pages for object "Sites".
DBCC results for 'NameValuePair_Slovenian_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Slovenian_CI_AS".
DBCC results for 'NameValuePair_Thai_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Thai_CI_AS".
DBCC results for 'NameValuePair_Turkish_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Turkish_CI_AS".
DBCC results for 'NameValuePair_Ukrainian_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Ukrainian_CI_AS".
DBCC results for 'NameValuePair_Vietnamese_CI_AS'.
There are 0 rows in 0 pages for object "NameValuePair_Vietnamese_CI_AS".
DBCC results for 'WebParts'.
There are 7136 rows in 202 pages for object "WebParts".
DBCC results for 'SiteVersions'.
There are 1621980 rows in 162950 pages for object "AllUserData".
CHECKDB found 0 allocation errors and 16 consistency errors in database 'myWorkflowDB'.
====================
and when i restored my April_backup and May_backup,
i got the following error :
Msg 7985, Level 16, State 2, Server ‘%%’, Line 1
System table pre-checks: Object ID 4. Could not read and latch page (1:51) with latch type SH. Check statement terminated due to unrepairable error.
thanks
September 19, 2010 at 10:54 am
The database is irreparably corrupt. Basically some critical portion of the system tables can't be read
Do you have an earlier backup? Can you try and restore the March backup to another server, see if you get the same errors there.
Is this a sharepoint database? How critical is it?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply