June 25, 2013 at 3:49 am
Hi,
I am new to this forum and there is a lot of good information here. I am looking for someone to interpret these results for me and to provide any direction. These are the results from my DBCC CHECKDB('DB_Name') WITH ALL_ERRORMSGS.
This is SQL 2000 and unfortunately I do not have a recent backup. (This is a inherited database, so Im not to blame for the lack of backups ;-))
Msg 8946, Level 16, State 12, Line 2
Table error: Allocation page (1:28502112) has invalid PFS_PAGE page header values. Type is 0. Check type, object ID and page ID on the page.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -25000, index ID 0, page ID (1:28502112). The PageId in the page header = (0:0).
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID -25000, index ID 0, page ID (1:28502112). The PageId in the page header = (0:0).
CHECKDB found 1 allocation errors and 1 consistency errors in table '(Object ID -25000)' (object ID -25000).
DBCC results for 'Bon_Live'.
Msg 8921, Level 16, State 1, Line 1
CHECKTABLE terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
Msg 8998, Level 16, State 1, Line 1
Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify database ID 10 pages from (1:28502112) to (1:28510199). See other errors for cause.
Msg 8998, Level 16, State 1, Line 1
Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify database ID 10 pages from (1:28510200) to (1:28518287). See other errors for cause.
Msg 8998, Level 16, State 1, Line 1
Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify database ID 10 pages from (1:28518288) to (1:28526375). See other errors for cause.
CHECKDB found 3 allocation errors and 0 consistency errors not associated with any single object.
DBCC results for 'sysobjects'.
There are 1083 rows in 24 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 1595 rows in 205 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 6247 rows in 411 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 725 rows in 138 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 3 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 454 rows in 3 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 29 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 110 rows in 5 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 4855 rows in 29 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 3 rows in 1 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 1 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfulltextnotify'.
There are 0 rows in 0 pages for object 'sysfulltextnotify'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 632864, index ID 17051, page ID (1:28510200). The PageId in the page header = (55702:800).
CHECKDB found 1 allocation errors and 0 consistency errors in table '(Object ID 632864)' (object ID 632864).
DBCC results for 'GI_TransactionLog'.
There are 2032 rows in 12 pages for object 'GI_TransactionLog'.
DBCC results for 'SearchPostcodeUpload'.
There are 5616 rows in 17 pages for object 'SearchPostcodeUpload'.
DBCC results for 'segmentation'.
There are 111422 rows in 1089 pages for object 'segmentation'.
DBCC results for 'tmp_BMAmendedAddress'.
There are 69 rows in 2 pages for object 'tmp_BMAmendedAddress'.
DBCC results for 'SearchStreet'.
There are 6096743 rows in 24815 pages for object 'SearchStreet'.
DBCC results for 'imp_venda_userexport_addresses'.
There are 2961 rows in 72 pages for object 'imp_venda_userexport_addresses'.
DBCC results for 'SearchStreetUpload'.
There are 5628 rows in 21 pages for object 'SearchStreetUpload'.
DBCC results for 'EmailRequests'.
There are 75632 rows in 218 pages for object 'EmailRequests'.
DBCC results for 'imp_idealWorld'.
There are 584 rows in 4 pages for object 'imp_idealWorld'.
DBCC results for 'sysmergepublications'.
There are 1 rows in 1 pages for object 'sysmergepublications'.
DBCC results for 'imp_venda_userexport_extended_data'.
There are 13986 rows in 130 pages for object 'imp_venda_userexport_extended_data'.
DBCC results for 'GI_aj_Contacts_Searchkey'.
There are 2826355 rows in 114257 pages for object 'GI_aj_Contacts_Searchkey'.
DBCC results for 'de_MiniCatalogue'.
There are 2191 rows in 21 pages for object 'de_MiniCatalogue'.
DBCC results for 'TestTbl'.
There are 2 rows in 1 pages for object 'TestTbl'.
DBCC results for 'tmp_de_Applications_cleaned'.
There are 296 rows in 6 pages for object 'tmp_de_Applications_cleaned'.
DBCC results for 'GI_MagazineAllocations'.
There are 361 rows in 2 pages for object 'GI_MagazineAllocations'.
DBCC results for 'bm_EmailData'.
There are 101708 rows in 1536 pages for object 'bm_EmailData'.
DBCC results for 'PotentialDupAddr'.
There are 25993 rows in 44 pages for object 'PotentialDupAddr'.
DBCC results for 'bm_user.imp_venda_userexport_extended_data_pivot'.
There are 1987 rows in 47 pages for object 'bm_user.imp_venda_userexport_extended_data_pivot'.
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 134676585, index ID 1, page ID (1:28518288). The PageId in the page header = (26880:131072).
CHECKDB found 1 allocation errors and 0 consistency errors in table '(Object ID 134676585)' (object ID 134676585).
DBCC results for 'imp_venda_userexport_emailonly'.
There are 13 rows in 1 pages for object 'imp_venda_userexport_emailonly'.
DBCC results for 'tmpEventsToDelete'.
There are 52503751 rows in 162551 pages for object 'tmpEventsToDelete'.
DBCC results for 'Upload'.
There are 0 rows in 8 pages for object 'Upload'.
DBCC results for 'imp_BMInternetCusts'.
There are 1834 rows in 64 pages for object 'imp_BMInternetCusts'.
DBCC results for 'GI_Event_backup_20130605'.
There are 105426808 rows in 2273182 pages for object 'GI_Event_backup_20130605'.
DBCC results for 'InternetTransactionHeader_Master'.
There are 1422685 rows in 24169 pages for object 'InternetTransactionHeader_Master'.
DBCC results for 'venda_UserExport_Details'.
There are 1 rows in 1 pages for object 'venda_UserExport_Details'.
DBCC results for 'de_WebApps'.
There are 12078 rows in 515 pages for object 'de_WebApps'.
DBCC results for 'de_NewsletterSignupsT1'.
There are 13 rows in 2 pages for object 'de_NewsletterSignupsT1'.
DBCC results for 'bm_InternetAmends_contactsT1'.
There are 132 rows in 5 pages for object 'bm_InternetAmends_contactsT1'.
DBCC results for 'GI_StoreSignUpTargets'.
There are 20691 rows in 71 pages for object 'GI_StoreSignUpTargets'.
DBCC results for 'Customer Transaction Header'.
There are 48175237 rows in 840050 pages for object 'Customer Transaction Header'.
DBCC results for 'de_BM008'.
There are 12832 rows in 209 pages for object 'de_BM008'.
DBCC results for 'bm_InternetAmends_addressT1'.
There are 132 rows in 3 pages for object 'bm_InternetAmends_addressT1'.
DBCC results for 'GI_EmailContact'.
There are 140595 rows in 3117 pages for object 'GI_EmailContact'.
DBCC results for 'de_ApplicationsT1'.
There are 5629 rows in 263 pages for object 'de_ApplicationsT1'.
DBCC results for 'imp_ImportFaults'.
There are 1410 rows in 18 pages for object 'imp_ImportFaults'.
DBCC results for 'de_BouncedEmails'.
There are 1532 rows in 139 pages for object 'de_BouncedEmails'.
DBCC results for 'Customer Transaction Points'.
There are 74991671 rows in 1116435 pages for object 'Customer Transaction Points'.
DBCC results for 'tmp_emails'.
There are 1 rows in 1 pages for object 'tmp_emails'.
DBCC results for 'Applications_Raw'.
There are 6525192 rows in 412844 pages for object 'Applications_Raw'.
DBCC results for 'tmp_Bounced'.
There are 32 rows in 2 pages for object 'tmp_Bounced'.
DBCC results for 'temp_custBCCards'.
There are 10304 rows in 55 pages for object 'temp_custBCCards'.
DBCC results for 'CustTranHeadHold'.
There are 1916205 rows in 36082 pages for object 'CustTranHeadHold'.
DBCC results for 'tmp_details'.
There are 1000 rows in 12 pages for object 'tmp_details'.
DBCC results for 'Applications_Bad'.
There are 28058 rows in 1730 pages for object 'Applications_Bad'.
DBCC results for 'report_contact'.
There are 6410311 rows in 66997 pages for object 'report_contact'.
DBCC results for 'de_Applications_Pending'.
There are 14 rows in 2 pages for object 'de_Applications_Pending'.
DBCC results for 'imp_AllSuppressed'.
There are 18390 rows in 235 pages for object 'imp_AllSuppressed'.
DBCC results for 'MSmerge_errorlineage'.
There are 0 rows in 0 pages for object 'MSmerge_errorlineage'.
DBCC results for 'tmp_addresses'.
There are 1000 rows in 22 pages for object 'tmp_addresses'.
DBCC results for 'ia_EventsByTypeAndYear'.
There are 42 rows in 1 pages for object 'ia_EventsByTypeAndYear'.
DBCC results for 'venda_UserExport_addresses'.
There are 1 rows in 1 pages for object 'venda_UserExport_addresses'.
DBCC results for 'Applications_Clean'.
There are 5628 rows in 299 pages for object 'Applications_Clean'.
DBCC results for 'RPT_Contact'.
There are 628960 rows in 48286 pages for object 'RPT_Contact'.
DBCC results for 'ws_BouncedEmailQueue'.
There are 1532 rows in 58 pages for object 'ws_BouncedEmailQueue'.
DBCC results for 'MSrepl_identity_range'.
There are 0 rows in 0 pages for object 'MSrepl_identity_range'.
DBCC results for 'CustTranPointsHold'.
There are 9718580 rows in 145354 pages for object 'CustTranPointsHold'.
DBCC results for 'GI_ImageCompression'.
There are 2484424 rows in 17438 pages for object 'GI_ImageCompression'.
DBCC results for 'GI_ChinaStaff'.
There are 4 rows in 1 pages for object 'GI_ChinaStaff'.
DBCC results for 'tmp_extendedData'.
There are 4000 rows in 36 pages for object 'tmp_extendedData'.
DBCC results for 'de_MiniCatalogueT1'.
There are 438 rows in 4 pages for object 'de_MiniCatalogueT1'.
DBCC results for 'Applications_Raw_DupCard'.
There are 18455 rows in 2227 pages for object 'Applications_Raw_DupCard'.
DBCC results for 'tmp_LatestBCCard'.
There are 3297 rows in 18 pages for object 'tmp_LatestBCCard'.
DBCC results for 'sysmergearticles'.
There are 3 rows in 1 pages for object 'sysmergearticles'.
DBCC results for 'imp_bmInternetCustsT1'.
There are 1 rows in 1 pages for object 'imp_bmInternetCustsT1'.
DBCC results for 'de_EmailChecks'.
There are 8130 rows in 221 pages for object 'de_EmailChecks'.
DBCC results for 'ia_GI_Event'.
There are 72390 rows in 225 pages for object 'ia_GI_Event'.
DBCC results for 'tmp_LatestTxnUrn'.
There are 3026 rows in 7 pages for object 'tmp_LatestTxnUrn'.
DBCC results for 'arc_GI_Event'.
There are 52503751 rows in 1128474 pages for object 'arc_GI_Event'.
DBCC results for 'GI_Filter'.
There are 9 rows in 1 pages for object 'GI_Filter'.
DBCC results for 'venda_UserExport_emailonly'.
There are 1 rows in 1 pages for object 'venda_UserExport_emailonly'.
DBCC results for 'de_NewsletterSignups'.
There are 138484 rows in 4004 pages for object 'de_NewsletterSignups'.
DBCC results for 'GI_StoreMagazineTargets'.
There are 14911 rows in 52 pages for object 'GI_StoreMagazineTargets'.
DBCC results for 'imp_EmailCheck_Sample'.
There are 100 rows in 2 pages for object 'imp_EmailCheck_Sample'.
DBCC results for 'venda_UserExport_extended_data'.
There are 1 rows in 1 pages for object 'venda_UserExport_extended_data'.
DBCC results for 'GI_StoreCallInHeader'.
There are 7912 rows in 70 pages for object 'GI_StoreCallInHeader'.
DBCC results for 'GI_OnlineCard'.
There are 293426 rows in 2084 pages for object 'GI_OnlineCard'.
DBCC results for 'GI_FilteredContacts'.
There are 529549 rows in 1235 pages for object 'GI_FilteredContacts'.
DBCC results for 'sysmergeschemaarticles'.
There are 0 rows in 0 pages for object 'sysmergeschemaarticles'.
DBCC results for 'Questionnaires'.
There are 3015 rows in 231 pages for object 'Questionnaires'.
DBCC results for 'GI_TriggeredEmailHistory'.
There are 707 rows in 8 pages for object 'GI_TriggeredEmailHistory'.
DBCC results for 'ws_CardAllocationBatches'.
There are 1893 rows in 15 pages for object 'ws_CardAllocationBatches'.
DBCC results for 'GI_FilterRules'.
There are 14 rows in 1 pages for object 'GI_FilterRules'.
DBCC results for 'Points Claimed'.
There are 0 rows in 1 pages for object 'Points Claimed'.
DBCC results for 'cfg_AllocatedObjects'.
There are 0 rows in 1 pages for object 'cfg_AllocatedObjects'.
DBCC results for 'ws_CardAllocations'.
There are 49621 rows in 394 pages for object 'ws_CardAllocations'.
DBCC results for 'GI_Magazine'.
There are 2 rows in 1 pages for object 'GI_Magazine'.
DBCC results for 'sysmergesubscriptions'.
There are 2 rows in 1 pages for object 'sysmergesubscriptions'.
DBCC results for 'Points Claimed Holding Table'.
There are 0 rows in 1 pages for object 'Points Claimed Holding Table'.
DBCC results for 'cfg_ConfigMessages'.
There are 8 rows in 1 pages for object 'cfg_ConfigMessages'.
DBCC results for 'dotmailer_SupplierCampaignContacts'.
There are 0 rows in 0 pages for object 'dotmailer_SupplierCampaignContacts'.
DBCC results for 'Points Claimed Manually'.
There are 0 rows in 1 pages for object 'Points Claimed Manually'.
DBCC results for 'bm_user.de_MiniCatalogueT1'.
There are 1752 rows in 16 pages for object 'bm_user.de_MiniCatalogueT1'.
DBCC results for 'cfg_DataImportLayouts'.
There are 7 rows in 1 pages for object 'cfg_DataImportLayouts'.
DBCC results for 'Points Claimed Manually Holding Table'.
There are 0 rows in 1 pages for object 'Points Claimed Manually Holding Table'.
DBCC results for 'cfg_DataImports'.
There are 1 rows in 1 pages for object 'cfg_DataImports'.
DBCC results for 'dotmailer_SupplierCampaigns'.
There are 1651 rows in 378 pages for object 'dotmailer_SupplierCampaigns'.
DBCC results for 'cfg_KeyRegister'.
There are 6 rows in 1 pages for object 'cfg_KeyRegister'.
DBCC results for 'email_EventLog'.
There are 21209094 rows in 936375 pages for object 'email_EventLog'.
DBCC results for 'MSmerge_replinfo'.
There are 2 rows in 1 pages for object 'MSmerge_replinfo'.
DBCC results for 'data for stores'.
There are 7685567 rows in 122570 pages for object 'data for stores'.
DBCC results for 'GI_ImageArchive'.
There are 5635408 rows in 287492 pages for object 'GI_ImageArchive'.
DBCC results for 'cfg_SqlPool'.
There are 37 rows in 1 pages for object 'cfg_SqlPool'.
DBCC results for 'MSmerge_tombstone'.
There are 0 rows in 1 pages for object 'MSmerge_tombstone'.
DBCC results for 'cfg_SystemValues'.
There are 13 rows in 1 pages for object 'cfg_SystemValues'.
DBCC results for 'email_EventLog_SCRAP2'.
There are 0 rows in 1 pages for object 'email_EventLog_SCRAP2'.
DBCC results for 'de_BouncedEmailsT1'.
There are 1 rows in 1 pages for object 'de_BouncedEmailsT1'.
DBCC results for 'imp_EmailCheck_Processed'.
There are 1174 rows in 15 pages for object 'imp_EmailCheck_Processed'.
DBCC results for 'MSmerge_contents'.
There are 21567 rows in 2841 pages for object 'MSmerge_contents'.
DBCC results for 'cfg_UserSettings'.
There are 0 rows in 0 pages for object 'cfg_UserSettings'.
DBCC results for 'MSmerge_genhistory'.
There are 26 rows in 2 pages for object 'MSmerge_genhistory'.
DBCC results for 'Calander_New'.
There are 5201 rows in 70 pages for object 'Calander_New'.
DBCC results for 'cfg_ValidationEngines'.
There are 3 rows in 1 pages for object 'cfg_ValidationEngines'.
DBCC results for 'MSmerge_delete_conflicts'.
There are 0 rows in 0 pages for object 'MSmerge_delete_conflicts'.
DBCC results for 'cfg_ValidationSteps'.
There are 10 rows in 1 pages for object 'cfg_ValidationSteps'.
DBCC results for 'Voucher Redemption'.
There are 0 rows in 1 pages for object 'Voucher Redemption'.
DBCC results for 'sysmergeschemachange'.
There are 30 rows in 1 pages for object 'sysmergeschemachange'.
DBCC results for 'Voucher Redemption Holding Table'.
There are 0 rows in 1 pages for object 'Voucher Redemption Holding Table'.
DBCC results for 'fdQuestions'.
There are 413 rows in 9 pages for object 'fdQuestions'.
DBCC results for 'de_Applications_Pending_cleaned'.
There are 14 rows in 1 pages for object 'de_Applications_Pending_cleaned'.
DBCC results for 'sysmergesubsetfilters'.
There are 0 rows in 0 pages for object 'sysmergesubsetfilters'.
DBCC results for 'fdSections'.
There are 17 rows in 1 pages for object 'fdSections'.
DBCC results for 'MSdynamicsnapshotviews'.
There are 0 rows in 0 pages for object 'MSdynamicsnapshotviews'.
DBCC results for 'inputPC'.
There are 0 rows in 0 pages for object 'inputPC'.
DBCC results for 'MSdynamicsnapshotjobs'.
There are 0 rows in 0 pages for object 'MSdynamicsnapshotjobs'.
DBCC results for 'corrupt_RPT_Contact'.
There are 604769 rows in 35230 pages for object 'corrupt_RPT_Contact'.
DBCC results for 'GI_Campaign'.
There are 12 rows in 1 pages for object 'GI_Campaign'.
DBCC results for 'wsBatches'.
There are 30085 rows in 208 pages for object 'wsBatches'.
DBCC results for 'Address Table'.
There are 6088144 rows in 114239 pages for object 'Address Table'.
DBCC results for 'MSmerge_altsyncpartners'.
There are 0 rows in 0 pages for object 'MSmerge_altsyncpartners'.
DBCC results for 'cfg_FtpQueue'.
There are 2114 rows in 40 pages for object 'cfg_FtpQueue'.
DBCC results for 'Calander'.
There are 2366 rows in 25 pages for object 'Calander'.
DBCC results for 'dtproperties'.
There are 0 rows in 1 pages for object 'dtproperties'.
DBCC results for 'email_HistoryCache'.
There are 73485747 rows in 2922809 pages for object 'email_HistoryCache'.
CHECKDB found 6 allocation errors and 1 consistency errors in database 'Bon_Live'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
June 25, 2013 at 4:48 am
Not repairable in any way.
Since you have no backup...
Script all objects (some may fail)
Export all data (some will likely fail)
Recreate the database.
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
June 25, 2013 at 5:16 am
Thanks GilaMonster
I will do as you suggested.
June 27, 2013 at 3:46 am
GilaMonster (6/25/2013)
Not repairable in any way.Since you have no backup...
Script all objects (some may fail)
Export all data (some will likely fail)
Recreate the database.
GilaMonster
Just double checking, even if I was to upgrade the database to e.g SQL2005 I will still have this issue with the corrupt data, yes?
June 27, 2013 at 4:07 am
Don't even try to upgrade that, the upgrade will very likely fail due to the severe corruption and you may well end up with a completely unusable database and complete data loss.
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
June 27, 2013 at 4:13 am
if i were you then i would have taken the backup first then
tried
DBCC CHECKDB (<db>, REPAIR_ALLOW_DATA_LOSS)
Note:note sure this will work on 2000 or not?
Pramod
SQL Server DBA | MCSE SQL Server 2012/2014
in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/
June 27, 2013 at 4:19 am
psingla (6/27/2013)
if i were you then i would have taken the backup first thentried
DBCC CHECKDB (<db>, REPAIR_ALLOW_DATA_LOSS)
Note:note sure this will work on 2000 or not?
Got nothing to do with SQL 2000, those errors are not repairable in any way. CheckDB with a repair option will spend a lot of time trying and will eventually fail with a whole bunch of 'this error can't be repaired' as well as various other messages.
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 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply