Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ksewduth
Starting Member
13 Posts |
 Posted - 2009-09-14 : 03:31:40
|
| Hi allI am having a problem with a DB, firstly I can not restore because the last backup I have is from the beginning of the year.I am getting 4 ALLOCATION ERRORS in this DB. When I do a DBCC CHECKDB I get the following error -:DBCC results for 'DAY_CONTROL'.Server: Msg 8906, Level 16, State 1, Line 1Page (1:12296) in database ID 7 is allocated in the SGAM (1:3) and PFS (1:8088), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.Server: Msg 8906, Level 16, State 1, Line 1Page (1:12519) in database ID 7 is allocated in the SGAM (1:3) and PFS (1:8088), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.Server: Msg 8906, Level 16, State 1, Line 1Page (1:11391) in database ID 7 is allocated in the SGAM (1:3) and PFS (1:8088), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.Server: Msg 8906, Level 16, State 1, Line 1Page (1:54316) in database ID 7 is allocated in the SGAM (1:3) and PFS (1:48528), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.There are 369 rows in 25 pages for object 'DAY_CONTROL'.CHECKDB found 1 allocation errors and 0 consistency errors in table 'DAY_CONTROL' (object ID 98151445).When I do a "DBCC CHECKDB (MyDatabase) WITH NO_INFOMSGS, ALL_ERRORMSGS" I get the follwing -:Server: Msg 8906, Level 16, State 1, Line 1Page (1:12296) in database ID 7 is allocated in the SGAM (1:3) and PFS (1:8088), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.Server: Msg 8906, Level 16, State 1, Line 1Page (1:12519) in database ID 7 is allocated in the SGAM (1:3) and PFS (1:8088), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.Server: Msg 8906, Level 16, State 1, Line 1Page (1:11391) in database ID 7 is allocated in the SGAM (1:3) and PFS (1:8088), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.Server: Msg 8906, Level 16, State 1, Line 1Page (1:54316) in database ID 7 is allocated in the SGAM (1:3) and PFS (1:48528), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.CHECKDB found 1 allocation errors and 0 consistency errors in table 'DAY_CONTROL' (object ID 98151445).CHECKDB found 1 allocation errors and 0 consistency errors in table 'DAY_DEP_TAX' (object ID 171251765).CHECKDB found 2 allocation errors and 0 consistency errors in table 'SHIFT_EMP_DATA' (object ID 450100644).CHECKDB found 4 allocation errors and 0 consistency errors in database 'MyDatabase'.repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (MyDatabase ).I have tried running the "dbcc checkdb ('MyDatabase',repair_allow_data_loss) and the "REPAIR_REBUILD" but still I have theses errors.Is there any way I can fix these errors OR a way I cal locate exactly which row or column in the table is causing this??Please help me if you can, I would really appreciate all your help |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-09-15 : 01:45:11
|
| Since you have no good backup (why not?), you'll have to repair.Take the DB into single user mode and run checkDB with the repair_allow_data_loss option. Post the results of that here.--Gail ShawSQL Server MVP |
 |
|
|
ksewduth
Starting Member
13 Posts |
Posted - 2009-09-15 : 08:45:00
|
| Hi GilaThanks for the reply, I have run the repair_allow_data_loss, this is the result I have -:DBCC results for 'FrontOff'.DBCC results for 'sysobjects'.There are 5392 rows in 91 pages for object 'sysobjects'.DBCC results for 'sysindexes'.There are 1534 rows in 80 pages for object 'sysindexes'.DBCC results for 'syscolumns'.There are 12342 rows in 1030 pages for object 'syscolumns'.DBCC results for 'systypes'.There are 37 rows in 1 pages for object 'systypes'.DBCC results for 'syscomments'.There are 4953 rows in 1024 pages for object 'syscomments'.DBCC results for 'sysfiles1'.There are 2 rows in 1 pages for object 'sysfiles1'.DBCC results for 'syspermissions'.There are 49 rows in 1 pages for object 'syspermissions'.DBCC results for 'sysusers'.There are 13 rows in 1 pages for object 'sysusers'.DBCC results for 'sysproperties'.There are 0 rows in 0 pages for object 'sysproperties'.DBCC results for 'sysdepends'.There are 8317 rows in 42 pages for object 'sysdepends'.DBCC results for 'sysreferences'.There are 2 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'.DBCC results for 'STK_RECEIVE_HDR'.There are 0 rows in 0 pages for object 'STK_RECEIVE_HDR'.DBCC results for 'PLU_CTG_FLD'.There are 76 rows in 2 pages for object 'PLU_CTG_FLD'.DBCC results for 'DAY_BASKET'.There are 485749 rows in 2169 pages for object 'DAY_BASKET'.DBCC results for 'PLU_FLTR'.There are 18 rows in 1 pages for object 'PLU_FLTR'.DBCC results for 'STK_RECEIVE_DTL'.There are 0 rows in 0 pages for object 'STK_RECEIVE_DTL'.DBCC results for 'PLU_FLTR_CTG'.There are 774 rows in 3 pages for object 'PLU_FLTR_CTG'.DBCC results for 'GRADES'.There are 0 rows in 0 pages for object 'GRADES'.DBCC results for 'PLU_FLTR_VAL'.There are 740 rows in 10 pages for object 'PLU_FLTR_VAL'.DBCC results for 'GEN_BTCH_MMBR_PROM'.There are 0 rows in 0 pages for object 'GEN_BTCH_MMBR_PROM'.Server: Msg 8906, Level 16, State 1, Line 1Page (1:12296) in database ID 7 is allocated in the SGAM (1:3) and PFS (1:8088), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.Server: Msg 8979, Level 16, State 1, Line 1Table error: Object ID 98151445, index ID 1. Page (1:12296) is missing references from parent (unknown) and previous (page (1:133)) nodes. Possible bad root entry in sysindexes.Server: Msg 8981, Level 16, State 1, Line 1Table error: Object ID 98151445, index ID 1. The next pointer of (1:12296) refers to page (1:13664). Neither (1:13664) nor its parent were encountered. Possible bad chain linkage.DBCC results for 'GEN_BTCH_OVERALL_DISC'.There are 0 rows in 0 pages for object 'GEN_BTCH_OVERALL_DISC'.DBCC results for 'STK_ADJ_HDR'.There are 0 rows in 0 pages for object 'STK_ADJ_HDR'.DBCC results for 'PLU_GROUP'.There are 2 rows in 1 pages for object 'PLU_GROUP'.DBCC results for 'GEN_BTCH_WET_TAX'.There are 0 rows in 0 pages for object 'GEN_BTCH_WET_TAX'.DBCC results for 'PLU_MASTER_ERROR'.There are 0 rows in 1 pages for object 'PLU_MASTER_ERROR'.DBCC results for 'STK_ADJ_DTL'.There are 0 rows in 0 pages for object 'STK_ADJ_DTL'.DBCC results for 'PLU_NOT_FOUND'.There are 494 rows in 3 pages for object 'PLU_NOT_FOUND'.DBCC results for 'DAY_CONTROL'. The error has been repaired. The error has been repaired. The error has been repaired.Clustered index successfully restored for object 'dbo.DAY_CONTROL' in database 'FrontOff'.Repair: Page (1:12296) has been allocated to object ID 98151445, index ID 1.There are 369 rows in 27 pages for object 'DAY_CONTROL'.Server: Msg 8906, Level 16, State 1, Line 1Page (1:12519) in database ID 7 is allocated in the SGAM (1:3) and PFS (1:8088), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.Server: Msg 8979, Level 16, State 1, Line 1Table error: Object ID 171251765, index ID 1. Page (1:12519) is missing references from parent (unknown) and previous (page (1:3672)) nodes. Possible bad root entry in sysindexes.Server: Msg 8981, Level 16, State 1, Line 1Table error: Object ID 171251765, index ID 1. The next pointer of (1:12519) refers to page (1:21425). Neither (1:21425) nor its parent were encountered. Possible bad chain linkage.Server: Msg 8906, Level 16, State 1, Line 1Page (1:11391) in database ID 7 is allocated in the SGAM (1:3) and PFS (1:8088), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.Server: Msg 8906, Level 16, State 1, Line 1Page (1:54316) in database ID 7 is allocated in the SGAM (1:3) and PFS (1:48528), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.Server: Msg 8979, Level 16, State 1, Line 1Table error: Object ID 450100644, index ID 1. Page (1:11391) is missing references from parent (unknown) and previous (page (1:203892)) nodes. Possible bad root entry in sysindexes.Server: Msg 8979, Level 16, State 1, Line 1Table error: Object ID 450100644, index ID 1. Page (1:54316) is missing references from parent (unknown) and previous (page (1:63850)) nodes. Possible bad root entry in sysindexes.Server: Msg 8981, Level 16, State 1, Line 1Table error: Object ID 450100644, index ID 1. The next pointer of (1:11391) refers to page (1:183225). Neither (1:183225) nor its parent were encountered. Possible bad chain linkage.Server: Msg 8981, Level 16, State 1, Line 1Table error: Object ID 450100644, index ID 1. The next pointer of (1:54316) refers to page (1:201190). Neither (1:201190) nor its parent were encountered. Possible bad chain linkage.CHECKDB found 1 allocation errors and 2 consistency errors in table 'DAY_CONTROL' (object ID 98151445).CHECKDB fixed 1 allocation errors and 2 consistency errors in table 'DAY_CONTROL' (object ID 98151445).DBCC results for 'CPN_PRN_MAINT'.There are 0 rows in 1 pages for object 'CPN_PRN_MAINT'.DBCC results for 'CUR_REFUNDS'.There are 0 rows in 0 pages for object 'CUR_REFUNDS'.DBCC results for 'PLU_PRC_RSN'.There are 0 rows in 0 pages for object 'PLU_PRC_RSN'.DBCC results for 'GEN_BTCH_LOYAL_CUST'.There are 0 rows in 0 pages for object 'GEN_BTCH_LOYAL_CUST'.DBCC results for 'Controls'.There are 8814 rows in 795 pages for object 'Controls'.DBCC results for 'CPN_VAL_CODE'.There are 100 rows in 1 pages for object 'CPN_VAL_CODE'.DBCC results for 'GenBatchFiles'.There are 22 rows in 1 pages for object 'GenBatchFiles'.DBCC results for 'PLU_RPT_ENV'.There are 21 rows in 1 pages for object 'PLU_RPT_ENV'.DBCC results for 'MULTIPLE_STAMP_SCHEMES'.There are 0 rows in 1 pages for object 'MULTIPLE_STAMP_SCHEMES'.DBCC results for 'ReportJobCommands'.There are 0 rows in 0 pages for object 'ReportJobCommands'.DBCC results for 'CUR_GIFT_BASKET'.There are 0 rows in 0 pages for object 'CUR_GIFT_BASKET'.DBCC results for 'dtproperties'.There are 0 rows in 1 pages for object 'dtproperties'.DBCC results for 'GRADES_LINKS'.There are 0 rows in 0 pages for object 'GRADES_LINKS'.DBCC results for 'QDX_FILE_CHECKSUM'.There are 40 rows in 1 pages for object 'QDX_FILE_CHECKSUM'.DBCC results for 'PCinSystem'.There are 10 rows in 1 pages for object 'PCinSystem'.DBCC results for 'STK_ITEM'.There are 0 rows in 0 pages for object 'STK_ITEM'.DBCC results for 'POST_CHK_BANK'.There are 0 rows in 0 pages for object 'POST_CHK_BANK'.DBCC results for 'ReportArchive'.There are 0 rows in 1 pages for object 'ReportArchive'.DBCC results for 'AMessages'.There are 17 rows in 2 pages for object 'AMessages'.DBCC results for 'RSTRCT_SLS'.There are 0 rows in 1 pages for object 'RSTRCT_SLS'.DBCC results for 'DAY_GIFT_BASKET'.There are 0 rows in 0 pages for object 'DAY_GIFT_BASKET'.DBCC results for 'DAY_DEP_TAX'. The error has been repaired. The error has been repaired. The error has been repaired.Clustered index successfully restored for object 'dbo.DAY_DEP_TAX' in database 'FrontOff'.Repair: Page (1:12519) has been allocated to object ID 171251765, index ID 1.There are 5913 rows in 30 pages for object 'DAY_DEP_TAX'.CHECKDB found 1 allocation errors and 2 consistency errors in table 'DAY_DEP_TAX' (object ID 171251765).CHECKDB fixed 1 allocation errors and 2 consistency errors in table 'DAY_DEP_TAX' (object ID 171251765).DBCC results for 'POST_ITM_MSG'.There are 0 rows in 0 pages for object 'POST_ITM_MSG'.DBCC results for 'ReportSource'.There are 4 rows in 1 pages for object 'ReportSource'.DBCC results for 'AUDIT'.There are 2193 rows in 20 pages for object 'AUDIT'.DBCC results for 'CUR_CHCK'.There are 0 rows in 0 pages for object 'CUR_CHCK'.DBCC results for 'PROM_HDR'.There are 0 rows in 0 pages for object 'PROM_HDR'.DBCC results for 'Abrv'.There are 311 rows in 15 pages for object 'Abrv'.DBCC results for 'DAY_FUEL_VAL_TRANS_PUMP'.There are 32 rows in 1 pages for object 'DAY_FUEL_VAL_TRANS_PUMP'.DBCC results for 'PROM_ITEM'.There are 0 rows in 0 pages for object 'PROM_ITEM'.DBCC results for 'AppUserGroups'.There are 14 rows in 1 pages for object 'AppUserGroups'.DBCC results for 'INSPECTION_TASKS'.There are 1 rows in 1 pages for object 'INSPECTION_TASKS'.DBCC results for 'DAY_REFUNDS'.There are 2096 rows in 16 pages for object 'DAY_REFUNDS'.DBCC results for 'PersonalMenuObject'.There are 14 rows in 1 pages for object 'PersonalMenuObject'.DBCC results for 'AppUsers'.There are 6 rows in 1 pages for object 'AppUsers'.DBCC results for 'PLU_BTCH_ITM'.There are 23134 rows in 1925 pages for object 'PLU_BTCH_ITM'.DBCC results for 'WEEK_PLU_SALES_DELETED'.There are 15173 rows in 524 pages for object 'WEEK_PLU_SALES_DELETED'.DBCC results for 'CUR_SAVED_TRS'.There are 0 rows in 0 pages for object 'CUR_SAVED_TRS'.DBCC results for 'TARE_WGT'.There are 0 rows in 0 pages for object 'TARE_WGT'.DBCC results for 'GRADES_MODE'.There are 3 rows in 1 pages for object 'GRADES_MODE'.DBCC results for 'QdxType'.There are 16 rows in 1 pages for object 'QdxType'.DBCC results for 'BAD_ACCT'.There are 0 rows in 0 pages for object 'BAD_ACCT'.DBCC results for 'DAY_SAVED_TRS'.There are 419 rows in 5 pages for object 'DAY_SAVED_TRS'.DBCC results for 'QueryCollection'.There are 0 rows in 0 pages for object 'QueryCollection'.DBCC results for 'BAD_ACCT_ENH'.There are 0 rows in 0 pages for object 'BAD_ACCT_ENH'.DBCC results for 'CUR_FUEL_VAL_TRANS_PUMP'.There are 0 rows in 1 pages for object 'CUR_FUEL_VAL_TRANS_PUMP'.DBCC results for 'FuelMessages'.There are 0 rows in 0 pages for object 'FuelMessages'.DBCC results for 'RPT_CTGR'.There are 17 rows in 1 pages for object 'RPT_CTGR'.DBCC results for 'SAFE_CSHR_DCLR_02'.There are 0 rows in 0 pages for object 'SAFE_CSHR_DCLR_02'.DBCC results for 'BANK'.There are 0 rows in 0 pages for object 'BANK'.DBCC results for 'ALRT'.There are 56 rows in 1 pages for object 'ALRT'.DBCC results for 'CUR_GRADES_PRICE_CHANGE'.There are 0 rows in 0 pages for object 'CUR_GRADES_PRICE_CHANGE'.DBCC results for 'RPT_DEP_HR'.There are 0 rows in 0 pages for object 'RPT_DEP_HR'.DBCC results for 'MEDIA'.There are 10 rows in 1 pages for object 'MEDIA'.DBCC results for 'FuelReceipt'.There are 0 rows in 0 pages for object 'FuelReceipt'.DBCC results for 'RPT_PLU_HR'.There are 70 rows in 1 pages for object 'RPT_PLU_HR'.DBCC results for 'EJ_TRANS_CRITERIA'.There are 1 rows in 1 pages for object 'EJ_TRANS_CRITERIA'.DBCC results for 'DAY_CHCK'.There are 97 rows in 2 pages for object 'DAY_CHCK'.DBCC results for 'DAY_GRADES_PRICE_CHANGE'.There are 0 rows in 0 pages for object 'DAY_GRADES_PRICE_CHANGE'.DBCC results for 'RPT_TYPES'.There are 124 rows in 1 pages for object 'RPT_TYPES'.DBCC results for 'TENDR_RPT'.There are 0 rows in 1 pages for object 'TENDR_RPT'.DBCC results for 'RTN_TYPE'.There are 3 rows in 1 pages for object 'RTN_TYPE'.DBCC results for 'CLB_CRD_SCHM'.There are 4 rows in 1 pages for object 'CLB_CRD_SCHM'.DBCC results for 'MAIN_SORT_ITEMS'.There are 7 rows in 1 pages for object 'MAIN_SORT_ITEMS'.DBCC results for 'ReportDetail'.There are 33 rows in 1 pages for object 'ReportDetail'.DBCC results for 'CNTRL_CHCK'.There are 8 rows in 1 pages for object 'CNTRL_CHCK'.DBCC results for 'FuelGeneralParam'.There are 0 rows in 0 pages for object 'FuelGeneralParam'.DBCC results for 'EJ_TRANS_RPT'.There are 0 rows in 1 pages for object 'EJ_TRANS_RPT'.DBCC results for 'COMUNTY_PRTNR'.There are 0 rows in 0 pages for object 'COMUNTY_PRTNR'.DBCC results for 'SECOND_SORT_ITEMS'.There are 4 rows in 1 pages for object 'SECOND_SORT_ITEMS'.DBCC results for 'SAVE_EMP_DATA'.There are 62 rows in 13 pages for object 'SAVE_EMP_DATA'.DBCC results for 'SCRIPTS'.There are 0 rows in 0 pages for object 'SCRIPTS'.DBCC results for 'COST_PLUS'.There are 0 rows in 0 pages for object 'COST_PLUS'.DBCC results for 'CUR_TRAIN_TER_DATA'.There are 0 rows in 0 pages for object 'CUR_TRAIN_TER_DATA'.DBCC results for 'SAVE_EMP_MEDIA'.There are 121 rows in 4 pages for object 'SAVE_EMP_MEDIA'.DBCC results for 'COUPON'.There are 0 rows in 0 pages for object 'COUPON'.DBCC results for 'INTEGRITY'.There are 40 rows in 2 pages for object 'INTEGRITY'.DBCC results for 'FuelPumps'.There are 0 rows in 0 pages for object 'FuelPumps'.DBCC results for 'SAVE_TER_DATA'.There are 14 rows in 3 pages for object 'SAVE_TER_DATA'.DBCC results for 'PLU_BTCH_VER'.There are 9 rows in 1 pages for object 'PLU_BTCH_VER'.DBCC results for 'CPN_PRT'.There are 0 rows in 0 pages for object 'CPN_PRT'.DBCC results for 'DAY_TANK_MON'.There are 0 rows in 1 pages for object 'DAY_TANK_MON'.DBCC results for 'TransDesc'.There are 281 rows in 2 pages for object 'TransDesc'.DBCC results for 'ALRT_TRGTS'.There are 0 rows in 0 pages for object 'ALRT_TRGTS'.DBCC results for 'SAVE_TER_MEDIA'.There are 93 rows in 3 pages for object 'SAVE_TER_MEDIA'.DBCC results for 'CRD_VLD'.There are 2 rows in 1 pages for object 'CRD_VLD'.DBCC results for 'TransDescHeader'.There are 27 rows in 1 pages for object 'TransDescHeader'.DBCC results for 'SHIFT_EMP_DATA'. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired. The error has been repaired.Clustered index successfully restored for object 'dbo.SHIFT_EMP_DATA' in database 'FrontOff'.Repair: Page (1:11391) has been allocated to object ID 450100644, index ID 1.Repair: Page (1:54316) has been allocated to object ID 450100644, index ID 1.There are 174 rows in 39 pages for object 'SHIFT_EMP_DATA'.CHECKDB found 2 allocation errors and 4 consistency errors in table 'SHIFT_EMP_DATA' (object ID 450100644).CHECKDB fixed 2 allocation errors and 4 consistency errors in table 'SHIFT_EMP_DATA' (object ID 450100644).DBCC results for 'CUR_TANK_MON'.There are 0 rows in 1 pages for object 'CUR_TANK_MON'.DBCC results for 'SHIFT_EMP_MEDIA'.There are 315 rows in 9 pages for object 'SHIFT_EMP_MEDIA'.DBCC results for 'SHIFT_TER_DATA'.There are 14 rows in 3 pages for object 'SHIFT_TER_DATA'.DBCC results for 'CUR_CONTROL_DISCOUNT'.There are 0 rows in 0 pages for object 'CUR_CONTROL_DISCOUNT'.DBCC results for 'SAFE'.There are 1 rows in 1 pages for object 'SAFE'.DBCC results for 'SHIFT_TER_MEDIA'.There are 93 rows in 3 pages for object 'SHIFT_TER_MEDIA'.DBCC results for 'CUR_CONTROL_RTN_TYPE'.There are 0 rows in 0 pages for object 'CUR_CONTROL_RTN_TYPE'.DBCC results for 'CTRLS'.There are 7877 rows in 71 pages for object 'CTRLS'.DBCC results for 'CUR_POST_DEC_TRS'.There are 0 rows in 0 pages for object 'CUR_POST_DEC_TRS'.DBCC results for 'FuelAlliedConvertLayer'.There are 0 rows in 0 pages for object 'FuelAlliedConvertLayer'.DBCC results for 'SPR_GRP'.There are 0 rows in 0 pages for object 'SPR_GRP'.DBCC results for 'CUR_CONTROL_TAX'.There are 0 rows in 0 pages for object 'CUR_CONTROL_TAX'.DBCC results for 'CUR_DEP_TAX'.There are 0 rows in 0 pages for object 'CUR_DEP_TAX'.DBCC results for 'CTRL_CLASS'.There are 26 rows in 1 pages for object 'CTRL_CLASS'.DBCC results for 'SQLDataTypes'.There are 0 rows in 1 pages for object 'SQLDataTypes'.DBCC results for 'STK_IBTIN_HDR'.There are 0 rows in 0 pages for object 'STK_IBTIN_HDR'.DBCC results for 'CUR_DEP_DTL_SALES'.There are 0 rows in 0 pages for object 'CUR_DEP_DTL_SALES'.DBCC results for 'FORMS'.There are 364 rows in 4 pages for object 'FORMS'.DBCC results for 'ALRT_ASSGN'.There are 0 rows in 0 pages for object 'ALRT_ASSGN'.DBCC results for 'DAY_POST_DEC_TRS'.There are 0 rows in 0 pages for object 'DAY_POST_DEC_TRS'.DBCC results for 'CUR_PLU_SALES'.There are 0 rows in 0 pages for object 'CUR_PLU_SALES'.DBCC results for 'STORES'.There are 1 rows in 1 pages for object 'STORES'.DBCC results for 'GEN_BTCH_BAD_ACCT'.There are 0 rows in 0 pages for object 'GEN_BTCH_BAD_ACCT'.DBCC results for 'CUR_DEP_GRP_SALES'.There are 0 rows in 0 pages for object 'CUR_DEP_GRP_SALES'.DBCC results for 'FuelMaint'.There are 177 rows in 5 pages for object 'FuelMaint'.DBCC results for 'PROJECTS'.There are 32 rows in 2 pages for object 'PROJECTS'.DBCC results for 'SAFE_TRANS'.There are 32308 rows in 257 pages for object 'SAFE_TRANS'.DBCC results for 'STORE_PRM'.There are 0 rows in 0 pages for object 'STORE_PRM'.DBCC results for 'CUR_DEP_SALES'.There are 0 rows in 0 pages for object 'CUR_DEP_SALES'.DBCC results for 'COMPANY_NAME'.There are 0 rows in 0 pages for object 'COMPANY_NAME'.DBCC results for 'GEN_BTCH_CRDT_PROG'.There are 0 rows in 0 pages for object 'GEN_BTCH_CRDT_PROG'.DBCC results for 'CUR_EMP_DATA'.There are 0 rows in 0 pages for object 'CUR_EMP_DATA'.DBCC results for 'PLU_PRICE'.There are 0 rows in 0 pages for object 'PLU_PRICE'.DBCC results for 'CUR_EMP_MEDIA'.There are 0 rows in 0 pages for object 'CUR_EMP_MEDIA'.DBCC results for 'Strings'.There are 2354 rows in 13 pages for object 'Strings'.DBCC results for 'GEN_BTCH_FuelGrades'.There are 0 rows in 0 pages for object 'GEN_BTCH_FuelGrades'.DBCC results for 'COUPON_PLU'.There are 0 rows in 0 pages for object 'COUPON_PLU'.DBCC results for 'CUR_HRLY_PRDCTVTY'.There are 96 rows in 2 pages for object 'CUR_HRLY_PRDCTVTY'.DBCC results for 'FNCL_CLND'.There are 0 rows in 0 pages for object 'FNCL_CLND'.DBCC results for 'GEN_BTCH_PLU_PRICE'.There are 0 rows in 0 pages for object 'GEN_BTCH_PLU_PRICE'.DBCC results for 'CUR_MEDIA_SALES'.There are 0 rows in 0 pages for object 'CUR_MEDIA_SALES'.DBCC results for 'TAX'.There are 2 rows in 1 pages for object 'TAX'.DBCC results for 'FNCL_CLND_WEEKS'.There are 0 rows in 0 pages for object 'FNCL_CLND_WEEKS'.DBCC results for 'SAFE_DEF'.There are 1 rows in 1 pages for object 'SAFE_DEF'.DBCC results for 'CUR_DISC_DATA'.There are 0 rows in 0 pages for object 'CUR_DISC_DATA'.DBCC results for 'TER'.There are 14 rows in 1 pages for object 'TER'.DBCC results for 'TICKET_DEP'.There are 0 rows in 1 pages for object 'TICKET_DEP'.DBCC results for 'GEN_BTCH_MMBR_PROM_LNKD'.There are 0 rows in 0 pages for object 'GEN_BTCH_MMBR_PROM_LNKD'.DBCC results for 'GEN_BTCH_COUPON_PLU'.There are 0 rows in 0 pages for object 'GEN_BTCH_COUPON_PLU'.DBCC results for 'CUR_POS_SALES'.There are 0 rows in 0 pages for object 'CUR_POS_SALES'.DBCC results for 'TR_PR'.There are 1 rows in 1 pages for object 'TR_PR'.DBCC results for 'FuelMaintHeader'.There are 12 rows in 1 pages for object 'FuelMaintHeader'.DBCC results for 'DAY_DISC_DATA'.There are 5487 rows in 48 pages for object 'DAY_DISC_DATA'.DBCC results for 'GEN_BTCH_SUB_DEP'.There are 0 rows in 0 pages for object 'GEN_BTCH_SUB_DEP'.DBCC results for 'CUR_TER_DATA'.There are 0 rows in 0 pages for object 'CUR_TER_DATA'.DBCC results for 'MMBR_PROM_LNKD'.There are 47 rows in 1 pages for object 'MMBR_PROM_LNKD'.DBCC results for 'GEN_BTCH_COUPON'.There are 0 rows in 0 pages for object 'GEN_BTCH_COUPON'.DBCC results for 'STK_IBTOUT_HDR'.There are 0 rows in 0 pages for object 'STK_IBTOUT_HDR'.DBCC results for 'CUR_TER_MEDIA'.There are 0 rows in 0 pages for object 'CUR_TER_MEDIA'.DBCC results for 'FuelTanks'.There are 0 rows in 0 pages for object 'FuelTanks'.DBCC results for 'CUR_TER_PRDCTVTY_MEDIA'.There are 0 rows in 0 pages for object 'CUR_TER_PRDCTVTY_MEDIA'.DBCC results for 'FuelModes'.There are 0 rows in 0 pages for object 'FuelModes'.DBCC results for 'CUR_TER_PRDCTVTY_SALES'.There are 0 rows in 0 pages for object 'CUR_TER_PRDCTVTY_SALES'.DBCC results for 'CUR_TRAIN_EMP_DATA'.There are 0 rows in 0 pages for object 'CUR_TRAIN_EMP_DATA'.DBCC results for 'CUR_TTL'.There are 0 rows in 0 pages for object 'CUR_TTL'.DBCC results for 'SYS_PRM'.There are 1625 rows in 25 pages for object 'SYS_PRM'.DBCC results for 'SAVE_SAFE'.There are 1 rows in 1 pages for object 'SAVE_SAFE'.DBCC results for 'STK_IBTOUT_DTL'.There are 0 rows in 0 pages for object 'STK_IBTOUT_DTL'.DBCC results for 'CUST_SURV_QST'.There are 0 rows in 0 pages for object 'CUST_SURV_QST'.DBCC results for 'PLU_MIXMATCH'.There are 0 rows in 0 pages for object 'PLU_MIXMATCH'.DBCC results for 'SYS_PRM_DEFAULT'.There are 1625 rows in 24 pages for object 'SYS_PRM_DEFAULT'.DBCC results for 'GEN_BTCH_DEP'.There are 0 rows in 0 pages for object 'GEN_BTCH_DEP'.DBCC results for 'SAFE_TRANSFER'.There are 0 rows in 0 pages for object 'SAFE_TRANSFER'.DBCC results for 'CLASS_TABLE'.There are 0 rows in 0 pages for object 'CLASS_TABLE'.DBCC results for 'CDM_FILTER'.There are 53 rows in 2 pages for object 'CDM_FILTER'.DBCC results for 'MODIFIED_TRACK'.There are 0 rows in 0 pages for object 'MODIFIED_TRACK'.DBCC results for 'KBD_HDR'.There are 5 rows in 1 pages for object 'KBD_HDR'.DBCC results for 'CUST_PRE_NUMBERS'.There are 0 rows in 0 pages for object 'CUST_PRE_NUMBERS'.DBCC results for 'rdoTypes'.There are 19 rows in 1 pages for object 'rdoTypes'.DBCC results for 'LBL_BTCH_DTL'.There are 0 rows in 0 pages for object 'LBL_BTCH_DTL'.DBCC results for 'ReportType'.There are 12 rows in 1 pages for object 'ReportType'.DBCC results for 'CUR_ECCA_SALES'.There are 0 rows in 0 pages for object 'CUR_ECCA_SALES'.DBCC results for 'SAFE_TRANSFER_LINK'.There are 0 rows in 0 pages for object 'SAFE_TRANSFER_LINK'.DBCC results for 'AUDIT_DETAIL'.There are 8714 rows in 58 pages for object 'AUDIT_DETAIL'.DBCC results for 'SAVE_SAFE_TRANS'.There are 32308 rows in 257 pages for object 'SAVE_SAFE_TRANS'.DBCC results for 'FuelBrands'.There are 11 rows in 1 pages for object 'FuelBrands'.DBCC results for 'STK_OUT_HDR'.There are 0 rows in 0 pages for object 'STK_OUT_HDR'.DBCC results for 'DAY_CONTROL_DISCOUNT'.There are 287 rows in 3 pages for object 'DAY_CONTROL_DISCOUNT'.DBCC results for 'KBD_KEY'.There are 237 rows in 2 pages for object 'KBD_KEY'.DBCC results for 'GEN_BTCH_CUST_PRE_NUMBERS'.There are 0 rows in 0 pages for object 'GEN_BTCH_CUST_PRE_NUMBERS'.DBCC results for 'REBATE_CPN_PRM'.There are 9 rows in 1 pages for object 'REBATE_CPN_PRM'.DBCC results for 'DAY_CONTROL_RTN_TYPE'.There are 526 rows in 3 pages for object 'DAY_CONTROL_RTN_TYPE'.DBCC results for 'ReportAttributes'.There are 131 rows in 2 pages for object 'ReportAttributes'.DBCC results for 'PAID_ROA'.There are 4034 rows in 19 pages for object 'PAID_ROA'.DBCC results for 'CUSTGP_VLD'.There are 0 rows in 0 pages for object 'CUSTGP_VLD'.DBCC results for 'CHKOUT_BNK_OPEN_LOAN'.There are 0 rows in 0 pages for object 'CHKOUT_BNK_OPEN_LOAN'.DBCC results for 'DAY_CONTROL_TAX'.There are 738 rows in 14 pages for object 'DAY_CONTROL_TAX'.DBCC results for 'KBD_PRESET'.There are 295 rows in 2 pages for object 'KBD_PRESET'.DBCC results for 'CPN_PRT_LINE'.There are 0 rows in 0 pages for object 'CPN_PRT_LINE'.DBCC results for 'DAY_DEP_DTL_SALES'.There are 183897 rows in 2555 pages for object 'DAY_DEP_DTL_SALES'.DBCC results for 'CRD_RNG'.There are 4 rows in 1 pages for object 'CRD_RNG'.DBCC results for 'POS_EOD_LIST'.There are 13 rows in 1 pages for object 'POS_EOD_LIST'.DBCC results for 'STK_OUT_DTL'.There are 0 rows in 0 pages for object 'STK_OUT_DTL'.DBCC results for 'DAY_DEP_GRP_SALES'.There are 369 rows in 2 pages for object 'DAY_DEP_GRP_SALES'.DBCC results for 'DAY_ECCA_SALES'.There are 0 rows in 0 pages for object 'DAY_ECCA_SALES'.DBCC results for 'CUR_EMP_DEP'.There are 0 rows in 0 pages for object 'CUR_EMP_DEP'.DBCC results for 'DAY_DEP_SALES'.There are 8498 rows in 500 pages for object 'DAY_DEP_SALES'.DBCC results for 'CUR_TER_DEP'.There are 0 rows in 0 pages for object 'CUR_TER_DEP'.DBCC results for 'SAVE_DEPOSIT'.There are 0 rows in 0 pages for object 'SAVE_DEPOSIT'.DBCC results for 'DAY_EMP_DATA'.There are 2659 rows in 532 pages for object 'DAY_EMP_DATA'.DBCC results for 'FuelModeScheme'.There are 0 rows in 0 pages for object 'FuelModeScheme'.DBCC results for 'RecoveryHeader'.There are 1 rows in 1 pages for object 'RecoveryHeader'.DBCC results for 'SAFE_DATA'.There are 11 rows in 1 pages for object 'SAFE_DATA'.DBCC results for 'CUR_FUEL_TOT_SALES'.There are 0 rows in 1 pages for object 'CUR_FUEL_TOT_SALES'.DBCC results for 'CDM_FILTER_USER'.There are 0 rows in 1 pages for object 'CDM_FILTER_USER'.DBCC results for 'CUST_SURV_LNKD'.There are 0 rows in 0 pages for object 'CUST_SURV_LNKD'.DBCC results for 'DAY_EMP_MEDIA'.There are 10872 rows in 302 pages for object 'DAY_EMP_MEDIA'.DBCC results for 'DAY_EMP_DEP'.There are 0 rows in 0 pages for object 'DAY_EMP_DEP'.DBCC results for 'DAY_HRLY_PRDCTVTY'.There are 35424 rows in 695 pages for object 'DAY_HRLY_PRDCTVTY'.DBCC results for 'GEN_BTCH_PLU_PRICE_RULE'.There are 0 rows in 0 pages for object 'GEN_BTCH_PLU_PRICE_RULE'.DBCC results for 'DAY_PLU_SALES'.There are 1202889 rows in 40097 pages for object 'DAY_PLU_SALES'.DBCC results for 'CDM_FILTER_LINES'.There are 0 rows in 1 pages for object 'CDM_FILTER_LINES'.DBCC results for 'DAY_TER_DEP'.There are 0 rows in 0 pages for object 'DAY_TER_DEP'.DBCC results for 'SAVE_PAID_ROA'.There are 4034 rows in 19 pages for object 'SAVE_PAID_ROA'.DBCC results for 'DAY_MEDIA_SALES'.There are 1892 rows in 15 pages for object 'DAY_MEDIA_SALES'.DBCC results for 'RecoveryProgress'.There are 0 rows in 1 pages for object 'RecoveryProgress'.DBCC results for 'CDM_LOG'.There are 0 rows in 1 pages for object 'CDM_LOG'.DBCC results for 'VERSION'.There are 7 rows in 1 pages for object 'VERSION'.DBCC results for 'CUR_COUPON_SALES'.There are 0 rows in 0 pages for object 'CUR_COUPON_SALES'.DBCC results for 'GEN_BTCH_COMPANY_NAME'.There are 0 rows in 0 pages for object 'GEN_BTCH_COMPANY_NAME'.DBCC results for 'HEADER_FOOTER_LINES'.There are 40 rows in 1 pages for object 'HEADER_FOOTER_LINES'.DBCC results for 'POST_EMAIL'.There are 0 rows in 0 pages for object 'POST_EMAIL'.DBCC results for 'FuelPosition'.There are 0 rows in 0 pages for object 'FuelPosition'.DBCC results for 'SCRIPT_RUN_LOG'.There are 391 rows in 3 pages for object 'SCRIPT_RUN_LOG'.DBCC results for 'PLUEXTRA'.There are 0 rows in 1 pages for object 'PLUEXTRA'.DBCC results for 'CUSTACCT'.There are 15 rows in 1 pages for object 'CUSTACCT'.DBCC results for 'DAY_FUEL_TOT_SALES'.There are 0 rows in 1 pages for object 'DAY_FUEL_TOT_SALES'.DBCC results for 'DAY_COUPON_SALES'.There are 0 rows in 0 pages for object 'DAY_COUPON_SALES'.DBCC results for 'DAY_POS_SALES'.There are 4439 rows in 77 pages for object 'DAY_POS_SALES'.DBCC results for 'MsgAttrb'.There are 1577 rows in 8 pages for object 'MsgAttrb'.DBCC results for 'SAVE_SAFE_TRANSFER'.There are 0 rows in 0 pages for object 'SAVE_SAFE_TRANSFER'.DBCC results for 'DAY_TER_DATA'.There are 3855 rows in 771 pages for object 'DAY_TER_DATA'.DBCC results for 'ReportParameter'.There are 430 rows in 2 pages for object 'ReportParameter'.DBCC results for 'STK_CNT_DTL'.There are 0 rows in 0 pages for object 'STK_CNT_DTL'.DBCC results for 'ObjectStrings'.There are 1321 rows in 9 pages for object 'ObjectStrings'.DBCC results for 'DAY_TER_MEDIA'.There are 14000 rows in 379 pages for object 'DAY_TER_MEDIA'.DBCC results for 'PRC_GRP'.There are 0 rows in 0 pages for object 'PRC_GRP'.DBCC results for 'STK_CNT_HDR'.There are 0 rows in 0 pages for object 'STK_CNT_HDR'.DBCC results for 'DAY_TER_PRDCTVTY_MEDIA'.There are 304698 rows in 2848 pages for object 'DAY_TER_PRDCTVTY_MEDIA'.DBCC results for 'ReportSchedule'.There are 5 rows in 1 pages for object 'ReportSchedule'.DBCC results for 'CUR_SIGN_ON'.There are 0 rows in 0 pages for object 'CUR_SIGN_ON'.DBCC results for 'GEN_BTCH_VENDOR'.There are 0 rows in 0 pages for object 'GEN_BTCH_VENDOR'.DBCC results for 'PLU_GROUP_ITEMS'.There are 35 rows in 1 pages for object 'PLU_GROUP_ITEMS'.DBCC results for 'SAVE_SAFE_DATA'.There are 11 rows in 1 pages for object 'SAVE_SAFE_DATA'.DBCC results for 'DAY_TER_PRDCTVTY_SALES'.There are 119043 rows in 2247 pages for object 'DAY_TER_PRDCTVTY_SALES'.DBCC results for 'CUR_SPECIAL'.There are 0 rows in 0 pages for object 'CUR_SPECIAL'.DBCC results for 'DDExclude'.There are 20 rows in 1 pages for object 'DDExclude'.DBCC results for 'POS_MENU'.There are 0 rows in 0 pages for object 'POS_MENU'.DBCC results for 'CUR_PROMOTION_SALES'.There are 0 rows in 0 pages for object 'CUR_PROMOTION_SALES'.DBCC results for 'DDFields'.There are 826 rows in 49 pages for object 'DDFields'.DBCC results for 'POS_MENU_LINES'.There are 0 rows in 0 pages for object 'POS_MENU_LINES'.DBCC results for 'DDObjLog'.There are 129 rows in 2 pages for object 'DDObjLog'.DBCC results for 'EJ_TRANS_RPT_TENDER'.There are 0 rows in 1 pages for object 'EJ_TRANS_RPT_TENDER'.DBCC results for 'RPT_CTGR_OPT'.There are 214 rows in 1 pages for object 'RPT_CTGR_OPT'.DBCC results for 'EOD_ERR_TITLE'.There are 2 rows in 1 pages for object 'EOD_ERR_TITLE'.DBCC results for 'DAY_PROMOTION_SALES'.There are 2360 rows in 20 pages for object 'DAY_PROMOTION_SALES'.DBCC results for 'DDObjects'.There are 3186 rows in 31 pages for object 'DDObjects'.DBCC results for 'DAY_SIGN_ON'.There are 17705 rows in 137 pages for object 'DAY_SIGN_ON'.DBCC results for 'RPT_HSTR'.There are 34179 rows in 289 pages for object 'RPT_HSTR'.DBCC results for 'MMBR_PROM'.There are 6 rows in 1 pages for object 'MMBR_PROM'.DBCC results for 'DDTables'.There are 191 rows in 2 pages for object 'DDTables'.DBCC results for 'WEEK_PLU_SALES'.There are 452371 rows in 15080 pages for object 'WEEK_PLU_SALES'.DBCC results for 'CUST_ORD_HDR'.There are 0 rows in 0 pages for object 'CUST_ORD_HDR'.DBCC results for 'ReportStrings'.There are 5529 rows in 49 pages for object 'ReportStrings'.DBCC results for 'EOD_EXP_DATE'.There are 0 rows in 0 pages for object 'EOD_EXP_DATE'.DBCC results for 'DEA_GRP'.There are 0 rows in 0 pages for object 'DEA_GRP'.DBCC results for 'DAY_SPECIAL'.There are 0 rows in 0 pages for object 'DAY_SPECIAL'.DBCC results for 'BROKEN_PACK'.There are 0 rows in 0 pages for object 'BROKEN_PACK'.DBCC results for 'DENOM'.There are 20 rows in 1 pages for object 'DENOM'.DBCC results for 'WET_TAX'.There are 0 rows in 0 pages for object 'WET_TAX'.DBCC results for 'SUB_DEP'.There are 395 rows in 3 pages for object 'SUB_DEP'.DBCC results for 'EOD_AUTO_TIMES'.There are 7 rows in 1 pages for object 'EOD_AUTO_TIMES'.DBCC results for 'DEP'.There are 42 rows in 1 pages for object 'DEP'.DBCC results for 'TRACE_LOG'.There are 0 rows in 0 pages for object 'TRACE_LOG'.DBCC results for 'DEP_GROUP'.There are 0 rows in 0 pages for object 'DEP_GROUP'.DBCC results for 'ReportParamValues'.There are 8 rows in 1 pages for object 'ReportParamValues'.DBCC results for 'PLU'.There are 20849 rows in 1801 pages for object 'PLU'.DBCC results for 'LBL_BTCH_HDR'.There are 0 rows in 0 pages for object 'LBL_BTCH_HDR'.DBCC results for 'DISCOUNT'.There are 1 rows in 1 pages for object 'DISCOUNT'.DBCC results for 'CRDT_PROG'.There are 0 rows in 0 pages for object 'CRDT_PROG'.DBCC results for 'DEP_BUDGET'.There are 0 rows in 1 pages for object 'DEP_BUDGET'.DBCC results for 'ECCA'.There are 0 rows in 0 pages for object 'ECCA'.DBCC results for 'DECLARE_BY_DENOM'.There are 0 rows in 0 pages for object 'DECLARE_BY_DENOM'.DBCC results for 'TASKS'.There are 0 rows in 1 pages for object 'TASKS'.DBCC results for 'CUR_FUEL_TOT_TRANS_PUMP'.There are 0 rows in 0 pages for object 'CUR_FUEL_TOT_TRANS_PUMP'.DBCC results for 'DAY_FUEL_TOT_TRANS_PUMP'.There are 32 rows in 1 pages for object 'DAY_FUEL_TOT_TRANS_PUMP'.DBCC results for 'OVERALL_DISC'.There are 0 rows in 0 pages for object 'OVERALL_DISC'.DBCC results for 'DEPOSIT'.There are 0 rows in 0 pages for object 'DEPOSIT'.DBCC results for 'GEN_BTCH_BROKEN_PACK'.There are 0 rows in 0 pages for object 'GEN_BTCH_BROKEN_PACK'.DBCC results for 'CUR_VOIDS'.There are 0 rows in 0 pages for object 'CUR_VOIDS'.DBCC results for 'FuelPureProducts'.There are 0 rows in 0 pages for object 'FuelPureProducts'.DBCC results for 'CASHR_CHKBANK_ASSGN'.There are 0 rows in 0 pages for object 'CASHR_CHKBANK_ASSGN'.DBCC results for 'SAVE_LOAN_PICKUP'.There are 1276 rows in 10 pages for object 'SAVE_LOAN_PICKUP'.DBCC results for 'BARCOD_DEF'.There are 0 rows in 0 pages for object 'BARCOD_DEF'.DBCC results for 'EMP'.There are 32 rows in 1 pages for object 'EMP'.DBCC results for 'ALRT_TRAN'.There are 0 rows in 1 pages for object 'ALRT_TRAN'.DBCC results for 'EOD_PROGRESS'.There are 164 rows in 1 pages for object 'EOD_PROGRESS'.DBCC results for 'SEGMENTS'.There are 0 rows in 0 pages for object 'SEGMENTS'.DBCC results for 'RTN_VCR'.There are 0 rows in 0 pages for object 'RTN_VCR'.DBCC results for 'MONTH_PLU_SALES'.There are 178696 rows in 5957 pages for object 'MONTH_PLU_SALES'.DBCC results for 'EXCISE_TAX'.There are 0 rows in 0 pages for object 'EXCISE_TAX'.DBCC results for 'POST_CFG'.There are 250 rows in 7 pages for object 'POST_CFG'.DBCC results for 'CUST_ORD_DTL'.There are 0 rows in 0 pages for object 'CUST_ORD_DTL'.DBCC results for 'SEGMENTS_PROM'.There are 0 rows in 0 pages for object 'SEGMENTS_PROM'.DBCC results for 'GEN_BTCH_ERROR'.There are 0 rows in 0 pages for object 'GEN_BTCH_ERROR'.DBCC results for 'GEN_BTCH_HDR'.There are 0 rows in 0 pages for object 'GEN_BTCH_HDR'.DBCC results for 'CARRIER'.There are 0 rows in 0 pages for object 'CARRIER'.DBCC results for 'CUR_CONTROL'.There are 1 rows in 1 pages for object 'CUR_CONTROL'.DBCC results for 'OBJECT_DATA_MAP'.There are 30 rows in 3 pages for object 'OBJECT_DATA_MAP'.DBCC results for 'DAY_VOIDS'.There are 1097 rows in 10 pages for object 'DAY_VOIDS'.DBCC results for 'CUR_EFT_SALES'.There are 0 rows in 0 pages for object 'CUR_EFT_SALES'.DBCC results for 'EMAIL_SEND'.There are 0 rows in 1 pages for object 'EMAIL_SEND'.DBCC results for 'OBJECT_DATA_PRPRTY_MAP'.There are 362 rows in 4 pages for object 'OBJECT_DATA_PRPRTY_MAP'.DBCC results for 'VENDOR'.There are 0 rows in 0 pages for object 'VENDOR'.DBCC results for 'INV_REG'.There are 0 rows in 0 pages for object 'INV_REG'.DBCC results for 'GEN_BTCH_TYPE'.There are 22 rows in 1 pages for object 'GEN_BTCH_TYPE'.DBCC results for 'BASECTL'.There are 0 rows in 0 pages for object 'BASECTL'.DBCC results for 'DAY_EFT_SALES'.There are 110601 rows in 1843 pages for object 'DAY_EFT_SALES'.DBCC results for 'ORDER_TYPE'.There are 0 rows in 0 pages for object 'ORDER_TYPE'.DBCC results for 'USER_ACCESS_LOG'.There are 0 rows in 1 pages for object 'USER_ACCESS_LOG'.DBCC results for 'LIQUOR_SUBSIDY'.There are 0 rows in 0 pages for object 'LIQUOR_SUBSIDY'.DBCC results for 'GEN_BTCH_PLU_GROUP'.There are 0 rows in 0 pages for object 'GEN_BTCH_PLU_GROUP'.DBCC results for 'STK_ORDER_DTL'.There are 0 rows in 0 pages for object 'STK_ORDER_DTL'.DBCC results for 'HEADER_FOOTER'.There are 2 rows in 1 pages for object 'HEADER_FOOTER'.DBCC results for 'STK_ORDER_HDR'.There are 0 rows in 0 pages for object 'STK_ORDER_HDR'.DBCC results for 'STNDG_ORD_HDR'.There are 0 rows in 0 pages for object 'STNDG_ORD_HDR'.DBCC results for 'KBD_FUNC'.There are 213 rows in 2 pages for object 'KBD_FUNC'.DBCC results for 'GEN_BTCH_LIQUOR_SUBSIDY'.There are 0 rows in 0 pages for object 'GEN_BTCH_LIQUOR_SUBSIDY'.DBCC results for 'YEAR_PLU_SALES'.There are 58369 rows in 1946 pages for object 'YEAR_PLU_SALES'.DBCC results for 'STNDG_ORD_DTL'.There are 0 rows in 0 pages for object 'STNDG_ORD_DTL'.DBCC results for 'PRICE_CALC_RPT_DTL'.There are 0 rows in 1 pages for object 'PRICE_CALC_RPT_DTL'.DBCC results for 'CDV'.There are 0 rows in 0 pages for object 'CDV'.DBCC results for 'PRICE_CALC_RPT_HDR'.There are 0 rows in 1 pages for object 'PRICE_CALC_RPT_HDR'.DBCC results for 'CNTRL_BK_HDR'.There are 0 rows in 0 pages for object 'CNTRL_BK_HDR'.DBCC results for 'LOAN_PICKUP'.There are 1276 rows in 10 pages for object 'LOAN_PICKUP'.DBCC results for 'STK_IBTIN_DTL'.There are 0 rows in 0 pages for object 'STK_IBTIN_DTL'.DBCC results for 'CUR_PLU_ONSALE'.There are 0 rows in 0 pages for object 'CUR_PLU_ONSALE'.DBCC results for 'LOGO'.There are 0 rows in 0 pages for object 'LOGO'.DBCC results for 'CNTRL_BK_DTL'.There are 0 rows in 0 pages for object 'CNTRL_BK_DTL'.DBCC results for 'STK_ADJ_TYPE'.There are 0 rows in 0 pages for object 'STK_ADJ_TYPE'.DBCC results for 'LOYAL_CUST'.There are 10 rows in 1 pages for object 'LOYAL_CUST'.DBCC results for 'Languages'.There are 1 rows in 1 pages for object 'Languages'.DBCC results for 'PAID_RCPT_ENH'.There are 0 rows in 0 pages for object 'PAID_RCPT_ENH'.DBCC results for 'MEDIA_GROUP'.There are 20 rows in 1 pages for object 'MEDIA_GROUP'.DBCC results for 'FuelSaleModeLinks'.There are 0 rows in 0 pages for object 'FuelSaleModeLinks'.DBCC results for 'PLU_PRICE_RULE'.There are 0 rows in 0 pages for object 'PLU_PRICE_RULE'.DBCC results for 'MMBR_CRD'.There are 0 rows in 0 pages for object 'MMBR_CRD'.DBCC results for 'LBL_FRMT_DTL'.There are 0 rows in 1 pages for object 'LBL_FRMT_DTL'.DBCC results for 'PAID_ROA_ENH'.There are 0 rows in 0 pages for object 'PAID_ROA_ENH'.DBCC results for 'CUR_HOURLY_SELF_SCAN'.There are 0 rows in 0 pages for object 'CUR_HOURLY_SELF_SCAN'.DBCC results for 'LBL_FRMT_HDR'.There are 0 rows in 0 pages for object 'LBL_FRMT_HDR'.DBCC results for 'MSG_CNTR'.There are 0 rows in 0 pages for object 'MSG_CNTR'.DBCC results for 'SAVE_PAID_ROA_ENH'.There are 0 rows in 0 pages for object 'SAVE_PAID_ROA_ENH'.DBCC results for 'CUR_PLU_SALES_DELETED'.There are 0 rows in 0 pages for object 'CUR_PLU_SALES_DELETED'.DBCC results for 'DAY_PLU_ONSALE'.There are 0 rows in 0 pages for object 'DAY_PLU_ONSALE'.DBCC results for 'DAY_HOURLY_SELF_SCAN'.There are 5217 rows in 42 pages for object 'DAY_HOURLY_SELF_SCAN'.DBCC results for 'MSG_QUE'.There are 0 rows in 0 pages for object 'MSG_QUE'.DBCC results for 'Maint'.There are 1988 rows in 39 pages for object 'Maint'.DBCC results for 'FuelDatabase'.There are 0 rows in 0 pages for object 'FuelDatabase'.DBCC results for 'MNT_RPT_GRP'.There are 0 rows in 0 pages for object 'MNT_RPT_GRP'.DBCC results for 'SELF_SCAN_NOT_FOUND'.There are 0 rows in 0 pages for object 'SELF_SCAN_NOT_FOUND'.DBCC results for 'STORE_BUDGET'.There are 0 rows in 0 pages for object 'STORE_BUDGET'.DBCC results for 'MaintBuff'.There are 0 rows in 0 pages for object 'MaintBuff'.DBCC results for 'FuelGrades'.There are 0 rows in 0 pages for object 'FuelGrades'.DBCC results for 'OFFICE_REASON_CODES'.There are 0 rows in 0 pages for object 'OFFICE_REASON_CODES'.DBCC results for 'MaintHeader'.There are 79 rows in 2 pages for object 'MaintHeader'.DBCC results for 'FuelFldTypeRgs'.There are 0 rows in 0 pages for object 'FuelFldTypeRgs'.DBCC results for 'MenuObject'.There are 720 rows in 26 pages for object 'MenuObject'.DBCC results for 'GEN_BTCH_CUSTACCT'.There are 0 rows in 0 pages for object 'GEN_BTCH_CUSTACCT'.DBCC results for 'CUR_DEPOSIT'.There are 0 rows in 0 pages for object 'CUR_DEPOSIT'.DBCC results for 'MenuObjectChilds'.There are 1228 rows in 4 pages for object 'MenuObjectChilds'.DBCC results for 'CHKOUT_BNK'.There are 0 rows in 0 pages for object 'CHKOUT_BNK'.DBCC results for 'FuelFldTypeSql'.There are 0 rows in 0 pages for object 'FuelFldTypeSql'.DBCC results for 'MenuObjectStrings'.There are 716 rows in 7 pages for object 'MenuObjectStrings'.DBCC results for 'ELECTRONIC_SALES'.There are 0 rows in 0 pages for object 'ELECTRONIC_SALES'.DBCC results for 'MsgStyle'.There are 10 rows in 1 pages for object 'MsgStyle'.DBCC results for 'MsgValue'.There are 1582 rows in 14 pages for object 'MsgValue'.DBCC results for 'VER_DATA'.There are 4 rows in 1 pages for object 'VER_DATA'.DBCC results for 'DAY_DEPOSIT'.There are 0 rows in 0 pages for object 'DAY_DEPOSIT'.DBCC results for 'OFFER'.There are 0 rows in 0 pages for object 'OFFER'.DBCC results for 'SAFE_CSHR_DCLR_01'.There are 0 rows in 0 pages for object 'SAFE_CSHR_DCLR_01'.DBCC results for 'GenBatchInput'.There are 653 rows in 6 pages for object 'GenBatchInput'.DBCC results for 'PAID_RCPT'.There are 2 rows in 1 pages for object 'PAID_RCPT'.DBCC results for 'GenBatchValid'.There are 78 rows in 1 pages for object 'GenBatchValid'.DBCC results for 'VER_FILES'.There are 12 rows in 1 pages for object 'VER_FILES'.DBCC results for 'SUB_DEP_RPT_ENV'.There are 2 rows in 1 pages for object 'SUB_DEP_RPT_ENV'.DBCC results for 'EVENT_LOG_RPT'.There are 0 rows in 1 pages for object 'EVENT_LOG_RPT'.DBCC results for 'PCMOPEN_LIST'.There are 169 rows in 2 pages for object 'PCMOPEN_LIST'.DBCC results for 'VER_STATUS'.There are 7 rows in 1 pages for object 'VER_STATUS'.DBCC results for 'PLU_BTCH'.There are 992 rows in 19 pages for object 'PLU_BTCH'.DBCC results for 'LANG_DETAILS'.There are 4 rows in 1 pages for object 'LANG_DETAILS'.DBCC results for 'BASKET_ANALYSIS'.There are 50 rows in 1 pages for object 'BASKET_ANALYSIS'.DBCC results for 'DAY_PLU_SALES_DELETED'.There are 36546 rows in 1261 pages for object 'DAY_PLU_SALES_DELETED'.DBCC results for 'DAY_SUB_DEP_SALES'.There are 0 rows in 0 pages for object 'DAY_SUB_DEP_SALES'.DBCC results for 'PLU_CTG'.There are 43 rows in 1 pages for object 'PLU_CTG'.DBCC results for 'CUR_BASKET'.There are 0 rows in 0 pages for object 'CUR_BASKET'.CHECKDB found 4 allocation errors and 8 consistency errors in database 'FrontOff'.CHECKDB fixed 4 allocation errors and 8 consistency errors in database 'FrontOff'.DBCC execution completed. If DBCC printed error messages, contact your system administrator.When I run the DBCC CHECKDB after I have done the repair, I still get the 4 ALLOCATION ERRORS. |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2009-09-15 : 13:16:38
|
| You're on 2000, where sometimes you need to run repair a couple of times for it to flush everything out. Can you run the following command and post the results:DBCC CHECKDB ('DAY_CONTROL', REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGSThanksPaul S. Randal,Managing Director, SQLskills.com Blog: www.SQLskills.com/blogs/paul Twitter: twitter.com/PaulRandalSQL MVP, Microsoft RD, Contributing Editor of TechNet MagazineAuthor of SQL 2005 DBCC CHECKDB/repair code |
|
|
|
ksewduth
Starting Member
13 Posts |
Posted - 2009-09-17 : 04:09:28
|
| HiSorry for the late replyI am running SQL 2000, DAY_CONTROL is a table.When I run the command "DBCC CHECKDB ('DAY_CONTROL', REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS" it returns an error ie.Server: Msg 911, Level 16, State 1, Line 1Could not locate entry in sysdatabases for database 'DAY_CONTROL'. No entry found with that name. Make sure that the name is entered correctly. |
|
|
|
ksewduth
Starting Member
13 Posts |
Posted - 2009-09-17 : 04:16:30
|
| If I run the command "DBCC CHECKDB ('FrontOff', REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS" where FrontOff is the name of my DB then I get the following message -:Server: Msg 8906, Level 16, State 1, Line 1Page (1:12296) in database ID 7 is allocated in the SGAM (1:3) and PFS (1:8088), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.Server: Msg 8906, Level 16, State 1, Line 1Page (1:12519) in database ID 7 is allocated in the SGAM (1:3) and PFS (1:8088), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.Server: Msg 8906, Level 16, State 1, Line 1Page (1:11391) in database ID 7 is allocated in the SGAM (1:3) and PFS (1:8088), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'. Repairing this error requires other errors to be corrected first.CHECKDB found 1 allocation errors and 0 consistency errors in table 'DAY_CONTROL' (object ID 98151445). Repairing this error requires other errors to be corrected first.CHECKDB found 1 allocation errors and 0 consistency errors in table 'DAY_DEP_TAX' (object ID 171251765).Server: Msg 8906, Level 16, State 1, Line 1Page (1:54316) in database ID 7 is allocated in the SGAM (1:3) and PFS (1:48528), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'. Could not repair this error. Repairing this error requires other errors to be corrected first.CHECKDB found 2 allocation errors and 0 consistency errors in table 'SHIFT_EMP_DATA' (object ID 450100644).CHECKDB found 4 allocation errors and 0 consistency errors in database 'FrontOff'.repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (FrontOff repair_allow_data_loss). |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-09-17 : 07:32:24
|
| I've seen that before on SQL 2000, all repairs needed other repairs done first, hence nothing could be repaired. Paul may well have a better solution, what I had to do in the case I had was to recreate the DB - script all objects, export all data, create a new database and reload everything.Can you maybe run CheckCatalog? It's not run by CheckDB in SQL 2000.DBCC CHECKCatalog ('FrontOff')If that returns no errors, can you try a CheckTable with repair on each of the tables involved. See if repairing bit by bit will work. Absolutely no guarantees, I'm guessing here.--Gail ShawSQL Server MVP |
|
|
|
ksewduth
Starting Member
13 Posts |
Posted - 2009-09-18 : 08:19:32
|
| HI GailI have run the "DBCC CHECKCATALOG" and it has returned no errors.I have tried repairing table by table, but still no luck.I used the command "DBCC CHECKTABLE (SHIFT_EMP_DATA, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS", and did the same for the other two damaged tables. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-09-18 : 08:41:48
|
| Then, unless Paul has a suggestion, you're going to have to export everything and create a new DB to get rid of this.--Gail ShawSQL Server MVP |
|
|
|
ksewduth
Starting Member
13 Posts |
Posted - 2009-09-21 : 03:12:59
|
| Hi GailI have never exported before, gonna google this and let you know how its going if you don't mind |
|
|
|
|
|
|
|
|
Allocation Error...PLZ HELP !!!