Sign in
 
SQL Server Developer Center > SQL Server Forums > Getting started with SQL Server > backing up sql database gives me DBCC error. need help!!!
Ask a questionAsk a question
Search Forums:
 

Proposed Answerbacking up sql database gives me DBCC error. need help!!!

  • Monday, November 02, 2009 2:04 PMxchangepatewon Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    i keep getting this error from backup exec when backing up one of my databases. i have no idea what i should do to fix it. i contacted backup exec tech support and they stated the problem is with my database and not their software. can anyone give me some guidance as to how i should troubleshoot and or resolve this issue? 


    Backup- \\sqlserver2.contoso.com\D: New Volume An unknown or unexpected database error occurred while attempting a DBCC.
    An internal error occurred in DBCC that prevented further processing. Contact Customer Support Services.
    An unknown or unexpected database error occurred while attempting a DBCC.
    DBCC results for 'Contoso'.


    i dont typically do much with sql databases so any help would be appreciated.

     

All Replies

  • Monday, November 02, 2009 3:15 PMTiborKMVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Is this SQL Server 2005 or higher? Is there anything special with your servers or storage (some sppecial failover solution, for instance)?

    I would troubleshoot this further by using Profiler to catch the TSQL commands submitted by your backup application and see which command is giving the error.
    Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi
     
  • Monday, November 02, 2009 3:58 PMxchangepatewon Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    It is SQL server 2005. this is my one and only sql server in my office. no failover solution in place.

    originally this sql database was created and was running on our older sql 2000 server. we moved it over to the new server since we were decommissioning the old one and since then we have been getting this messages when backing up.


    how would i go about catching the TSQL commands submitted by backup exec?

    here is the link that backup exec gives me:
    http://seer.entsupport.symantec.com/docs/315464.htm

     
  • Monday, November 02, 2009 4:46 PMTiborKMVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    You should do what that article tell you to. Run DBCC CHECKDB (documented in Books Online) and see if that produces any errors. If it does, contact MS Support and see what next step would be (possibly restore from a clean backup).
    Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi
     
  • Monday, November 02, 2009 5:16 PMxchangepatewon Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Has Code
    Sign In to Vote
    0
    Sign In to Vote
    this DB was working fine and backing up fine when on the old server still using backup exec. so i dont know if something happened when connecting it to the new sql server since the old server was SQL 2000 server and the new one was SQL 2005 server. is there anything special when moving a DB over from 2000 to 2005? we moved this DB over a year ago. 

    what is the command line that i should use to run the dbcc check? do i need to specify the db name or any other switches?
    do i just navigate to the DB in question, right click and choose new query and type dbcc checkdb and thats its? does it produce a log file that i should take a look at once it is completed? if so where would i locate that?


    DBCC CHECKDB 
    
[
    
    [ ( database_name | database_id | 0
    
        [ , NOINDEX 
    
        | , { REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST | REPAIR_REBUILD } ]
    
        ) ]
    
    [ WITH 
    
        {
    
            [ ALL_ERRORMSGS ]
    
            [ , EXTENDED_LOGICAL_CHECKS ] 
    
            [ , NO_INFOMSGS ]
    
            [ , TABLOCK ]
    
            [ , ESTIMATEONLY ]
    
            [ , { PHYSICAL_ONLY | DATA_PURITY } ]
    
        }
    
    ]

     
  • Monday, November 02, 2009 7:40 PMAmit Banerjee - MSFT Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Open a new query window and run the following:

    USE <database name>
    DBCC CHECKDB

    Once the CHECKDB is complete, the Messages tab would have the CHECKDB output. Check if the CHECKDB has reported any consistency or allocation errors.
    This posting is provided "AS IS" with no warranties, and confers no rights. My Blog: Troubleshooting SQL
     
  • Monday, November 02, 2009 8:08 PMxchangepatewon Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    here is the output:

    DBCC results for 'Contoso'.
    Service Broker Msg 9675, State 1: Message Types analyzed: 14.
    Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
    Service Broker Msg 9667, State 1: Services analyzed: 3.
    Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
    Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
    Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
    Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
    DBCC results for 'sys.sysrowsetcolumns'.
    There are 4639 rows in 27 pages for object "sys.sysrowsetcolumns".
    DBCC results for 'sys.sysrowsets'.
    There are 607 rows in 8 pages for object "sys.sysrowsets".
    DBCC results for 'sysallocunits'.
    There are 637 rows in 10 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 4639 rows in 34 pages for object "sys.syshobtcolumns".
    DBCC results for 'sys.syshobts'.
    There are 607 rows in 8 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 637 rows in 3 pages for object "sys.sysserefs".
    DBCC results for 'sys.sysowners'.
    There are 18 rows in 1 pages for object "sys.sysowners".
    DBCC results for 'sys.sysprivs'.
    There are 124 rows in 1 pages for object "sys.sysprivs".
    DBCC results for 'sys.sysschobjs'.
    There are 982 rows in 15 pages for object "sys.sysschobjs".
    DBCC results for 'sys.syscolpars'.
    There are 4152 rows in 46 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 27 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 1961 rows in 32 pages for object "sys.sysidxstats".
    DBCC results for 'sys.sysiscols'.
    There are 2139 rows in 15 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 2160 rows in 311 pages for object "sys.sysobjvalues".
    DBCC results for 'sys.sysclsobjs'.
    There are 17 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 136 rows in 1 pages for object "sys.syssingleobjrefs".
    DBCC results for 'sys.sysmultiobjrefs'.
    There are 1184 rows in 8 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 92 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 0 rows in 0 pages for object "sys.sysbinsubobjs".
    DBCC results for 'Advantage.X_060524_16284882_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060524_16284882_AR".
    DBCC results for 'prControl'.
    There are 0 rows in 1 pages for object "prControl".
    DBCC results for 'EM'.
    There are 25 rows in 2 pages for object "EM".
    DBCC results for 'SEUser'.
    There are 10 rows in 1 pages for object "SEUser".
    DBCC results for 'BTBGSubs'.
    There are 0 rows in 1 pages for object "BTBGSubs".
    DBCC results for 'prDetail'.
    There are 0 rows in 1 pages for object "prDetail".
    DBCC results for 'BTEA'.
    There are 1 rows in 1 pages for object "BTEA".
    DBCC results for 'PRF'.
    Msg 2508, Level 16, State 3, Line 2
    The In-row data RSVD page count for object "PRF", index ID 0, partition ID 6794209984512, alloc unit ID 6794209984512 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
    There are 3876 rows in 29 pages for object "PRF".
    CHECKDB found 0 allocation errors and 1 consistency errors in table 'PRF' (object ID 103671417).
    DBCC results for 'BTEAAccts'.
    There are 0 rows in 1 pages for object "BTEAAccts".
    DBCC results for 'EMInitiation'.
    There are 0 rows in 1 pages for object "EMInitiation".
    DBCC results for 'BTEC'.
    There are 0 rows in 1 pages for object "BTEC".
    DBCC results for 'VE'.
    There are 180 rows in 9 pages for object "VE".
    DBCC results for 'BTECAccts'.
    There are 0 rows in 1 pages for object "BTECAccts".
    DBCC results for 'BTECCats'.
    There are 0 rows in 1 pages for object "BTECCats".
    DBCC results for 'BTEV'.
    There are 0 rows in 1 pages for object "BTEV".
    DBCC results for 'prMaster'.
    There are 0 rows in 1 pages for object "prMaster".
    DBCC results for 'BTEVVends'.
    There are 0 rows in 1 pages for object "BTEVVends".
    DBCC results for 'exControl'.
    There are 0 rows in 0 pages for object "exControl".
    DBCC results for 'CFGOHAccounts'.
    There are 0 rows in 1 pages for object "CFGOHAccounts".
    DBCC results for 'BTF'.
    There are 12 rows in 1 pages for object "BTF".
    DBCC results for 'ProcessPrinters'.
    There are 0 rows in 1 pages for object "ProcessPrinters".
    DBCC results for 'CFGOHMain'.
    There are 1 rows in 1 pages for object "CFGOHMain".
    DBCC results for 'BTRCT'.
    There are 2 rows in 1 pages for object "BTRCT".
    DBCC results for 'ABRAMapping'.
    There are 0 rows in 1 pages for object "ABRAMapping".
    DBCC results for 'ProcessQueue'.
    There are 0 rows in 1 pages for object "ProcessQueue".
    DBCC results for 'CFGPCCodes'.
    There are 4 rows in 1 pages for object "CFGPCCodes".
    DBCC results for 'BTRCTCats'.
    There are 13 rows in 1 pages for object "BTRCTCats".
    DBCC results for 'ADPExport'.
    There are 0 rows in 1 pages for object "ADPExport".
    DBCC results for 'EMP'.
    There are 0 rows in 1 pages for object "EMP".
    DBCC results for 'CFGPCControl'.
    There are 2 rows in 1 pages for object "CFGPCControl".
    DBCC results for 'BTRCTEmpls'.
    There are 42 rows in 1 pages for object "BTRCTEmpls".
    DBCC results for 'AdvPWPMapping'.
    There are 269 rows in 3 pages for object "AdvPWPMapping".
    DBCC results for 'BTRLT'.
    There are 0 rows in 1 pages for object "BTRLT".
    DBCC results for 'AdvPWPMappingDefault'.
    There are 269 rows in 3 pages for object "AdvPWPMappingDefault".
    DBCC results for 'Advantage.X_060921_10162357_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060921_10162357_AR".
    DBCC results for 'PRTemplates'.
    There are 0 rows in 1 pages for object "PRTemplates".
    DBCC results for 'exDetail'.
    There are 0 rows in 0 pages for object "exDetail".
    DBCC results for 'BTRLTCodes'.
    There are 0 rows in 1 pages for object "BTRLTCodes".
    DBCC results for 'apControl'.
    There are 0 rows in 1 pages for object "apControl".
    DBCC results for 'CFGPCMain'.
    There are 1 rows in 1 pages for object "CFGPCMain".
    DBCC results for 'BTROT'.
    There are 3 rows in 1 pages for object "BTROT".
    DBCC results for 'Advantage.X_060928_13540465_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060928_13540465_AR".
    DBCC results for 'BTROTEmpls'.
    There are 5 rows in 1 pages for object "BTROTEmpls".
    DBCC results for 'Advantage.X_060928_13545199_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060928_13545199_AR".
    DBCC results for 'pwpMapping'.
    There are 136 rows in 2 pages for object "pwpMapping".
    DBCC results for 'exMaster'.
    There are 0 rows in 0 pages for object "exMaster".
    DBCC results for 'EMPA'.
    There are 0 rows in 1 pages for object "EMPA".
    DBCC results for 'BTRRT'.
    There are 6 rows in 1 pages for object "BTRRT".
    DBCC results for 'pwpMappingDefault'.
    There are 136 rows in 2 pages for object "pwpMappingDefault".
    DBCC results for 'BTRRTEmpls'.
    There are 96 rows in 2 pages for object "BTRRTEmpls".
    DBCC results for 'apDetail'.
    There are 0 rows in 2 pages for object "apDetail".
    DBCC results for 'Advantage.X_060928_13573448_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060928_13573448_AR".
    DBCC results for 'PYChecks'.
    There are 0 rows in 1 pages for object "PYChecks".
    DBCC results for 'EMPAD'.
    There are 0 rows in 1 pages for object "EMPAD".
    DBCC results for 'CA'.
    There are 199 rows in 3 pages for object "CA".
    DBCC results for 'CAB'.
    There are 0 rows in 1 pages for object "CAB".
    DBCC results for 'apMaster'.
    There are 0 rows in 2 pages for object "apMaster".
    DBCC results for 'EMPD'.
    There are 0 rows in 1 pages for object "EMPD".
    DBCC results for 'CABDetail'.
    There are 0 rows in 1 pages for object "CABDetail".
    DBCC results for 'apppChecks'.
    There are 0 rows in 1 pages for object "apppChecks".
    DBCC results for 'BTBG'.
    There are 0 rows in 0 pages for object "BTBG".
    DBCC results for 'cdControl'.
    There are 0 rows in 1 pages for object "cdControl".
    DBCC results for 'Advantage.X_061214_09043546_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_061214_09043546_AR".
    DBCC results for 'CFGPostControl'.
    There are 3180 rows in 51 pages for object "CFGPostControl".
    DBCC results for 'AR'.
    Msg 2508, Level 16, State 3, Line 2
    The In-row data RSVD page count for object "AR", index ID 0, partition ID 30774179332096, alloc unit ID 30774179332096 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
    There are 1504 rows in 15 pages for object "AR".
    CHECKDB found 0 allocation errors and 1 consistency errors in table 'AR' (object ID 469576711).
    DBCC results for 'Advantage.X_070105_10261495_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070105_10261495_AR".
    DBCC results for 'PYChecksA'.
    There are 0 rows in 1 pages for object "PYChecksA".
    DBCC results for 'EMPE'.
    There are 0 rows in 1 pages for object "EMPE".
    DBCC results for 'ARC'.
    There are 28 rows in 1 pages for object "ARC".
    DBCC results for 'cdDetail'.
    There are 0 rows in 1 pages for object "cdDetail".
    DBCC results for 'Advantage.X_070207_13104112_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070207_13104112_AR".
    DBCC results for 'PYChecksE'.
    There are 0 rows in 1 pages for object "PYChecksE".
    DBCC results for 'EMPED'.
    There are 0 rows in 1 pages for object "EMPED".
    DBCC results for 'CFGProcessQueue'.
    There are 0 rows in 1 pages for object "CFGProcessQueue".
    DBCC results for 'cdMaster'.
    There are 0 rows in 1 pages for object "cdMaster".
    DBCC results for 'PYChecksW'.
    There are 0 rows in 1 pages for object "PYChecksW".
    DBCC results for 'EMPW'.
    There are 0 rows in 1 pages for object "EMPW".
    DBCC results for 'CFGMain'.
    There are 1 rows in 1 pages for object "CFGMain".
    DBCC results for 'CFGADPLaborCodes'.
    There are 0 rows in 1 pages for object "CFGADPLaborCodes".
    DBCC results for 'sys.queue_messages_534292963'.
    There are 0 rows in 0 pages for object "sys.queue_messages_534292963".
    DBCC results for 'CFGProcessQueueStatus'.
    There are 3 rows in 1 pages for object "CFGProcessQueueStatus".
    DBCC results for 'CFGAPDiscount'.
    There are 0 rows in 1 pages for object "CFGAPDiscount".
    DBCC results for 'CFGProcessStatus'.
    There are 6 rows in 1 pages for object "CFGProcessStatus".
    DBCC results for 'sys.queue_messages_566293077'.
    There are 0 rows in 0 pages for object "sys.queue_messages_566293077".
    DBCC results for 'RPTProjectList'.
    There are 419 rows in 12 pages for object "RPTProjectList".
    DBCC results for 'EMPWD'.
    There are 0 rows in 1 pages for object "EMPWD".
    DBCC results for 'CFGProjectStatus'.
    There are 4 rows in 1 pages for object "CFGProjectStatus".
    DBCC results for 'CFGAPForm1099'.
    There are 1 rows in 1 pages for object "CFGAPForm1099".
    DBCC results for 'CFGProjectType'.
    There are 3 rows in 1 pages for object "CFGProjectType".
    DBCC results for 'CFGAPLiability'.
    There are 2 rows in 1 pages for object "CFGAPLiability".
    DBCC results for 'sys.queue_messages_598293191'.
    There are 0 rows in 0 pages for object "sys.queue_messages_598293191".
    DBCC results for 'CFGPRSortSelect'.
    There are 30 rows in 1 pages for object "CFGPRSortSelect".
    DBCC results for 'billAddDetail'.
    There are 9 rows in 1 pages for object "billAddDetail".
    DBCC results for 'X_090108_09553805_AR'.
    There are 0 rows in 0 pages for object "X_090108_09553805_AR".
    DBCC results for 'EMTKGroups'.
    There are 0 rows in 1 pages for object "EMTKGroups".
    DBCC results for 'CFGAPStateID'.
    There are 0 rows in 1 pages for object "CFGAPStateID".
    DBCC results for 'billARDetail'.
    There are 156 rows in 9 pages for object "billARDetail".
    DBCC results for 'X_090119_11141672_AR'.
    There are 0 rows in 0 pages for object "X_090119_11141672_AR".
    DBCC results for 'CFGAPVendorType'.
    There are 3 rows in 1 pages for object "CFGAPVendorType".
    DBCC results for 'billBTDDetail'.
    There are 0 rows in 1 pages for object "billBTDDetail".
    DBCC results for 'X_090119_11231663_AR'.
    There are 0 rows in 0 pages for object "X_090119_11231663_AR".
    DBCC results for 'erControl'.
    There are 0 rows in 1 pages for object "erControl".
    DBCC results for 'CFGARLedgerHeadings'.
    There are 6 rows in 1 pages for object "CFGARLedgerHeadings".
    DBCC results for 'billConDetail'.
    There are 357 rows in 15 pages for object "billConDetail".
    DBCC results for 'CFGARMap'.
    There are 5 rows in 1 pages for object "CFGARMap".
    DBCC results for 'CFGBanks'.
    There are 1 rows in 1 pages for object "CFGBanks".
    DBCC results for 'erDetail'.
    There are 0 rows in 1 pages for object "erDetail".
    DBCC results for 'CFGPWPInterface'.
    There are 1 rows in 1 pages for object "CFGPWPInterface".
    DBCC results for 'billExpDetail'.
    There are 1932 rows in 57 pages for object "billExpDetail".
    DBCC results for 'erMaster'.
    There are 0 rows in 1 pages for object "erMaster".
    DBCC results for 'CFGPYAccruals'.
    There are 2 rows in 1 pages for object "CFGPYAccruals".
    DBCC results for 'SEMenu'.
    There are 175 rows in 4 pages for object "SEMenu".
    DBCC results for 'RPTActivityList'.
    There are 2670 rows in 13 pages for object "RPTActivityList".
    DBCC results for 'ETChargeGroupMP'.
    There are 0 rows in 1 pages for object "ETChargeGroupMP".
    DBCC results for 'SEPrincipal'.
    There are 0 rows in 1 pages for object "SEPrincipal".
    DBCC results for 'ETLeaveMP'.
    There are 0 rows in 1 pages for object "ETLeaveMP".
    DBCC results for 'SEProfCtr'.
    There are 0 rows in 1 pages for object "SEProfCtr".
    DBCC results for 'ETMapping'.
    There are 1 rows in 1 pages for object "ETMapping".
    DBCC results for 'CFGPYFormW2'.
    There are 1 rows in 1 pages for object "CFGPYFormW2".
    DBCC results for 'billINDetail'.
    Msg 2508, Level 16, State 3, Line 2
    The In-row data RSVD page count for object "billINDetail", index ID 0, partition ID 54891513249792, alloc unit ID 54891513249792 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
    There are 1376 rows in 29 pages for object "billINDetail".
    CHECKDB found 0 allocation errors and 1 consistency errors in table 'billINDetail' (object ID 837578022).
    DBCC results for 'SEProjMgr'.
    There are 0 rows in 1 pages for object "SEProjMgr".
    DBCC results for 'EX'.
    There are 0 rows in 1 pages for object "EX".
    DBCC results for 'CFGPYMain'.
    There are 1 rows in 1 pages for object "CFGPYMain".
    DBCC results for 'EXAdvance'.
    There are 0 rows in 1 pages for object "EXAdvance".
    DBCC results for 'BillingTemplates'.
    There are 242 rows in 2 pages for object "BillingTemplates".
    DBCC results for 'exChecks'.
    There are 0 rows in 1 pages for object "exChecks".
    DBCC results for 'billINMaster'.
    There are 7271 rows in 67 pages for object "billINMaster".
    DBCC results for 'billIntDetail'.
    There are 0 rows in 1 pages for object "billIntDetail".
    DBCC results for 'TKComments'.
    There are 31 rows in 1 pages for object "TKComments".
    DBCC results for 'billInvMaster'.
    There are 2551 rows in 81 pages for object "billInvMaster".
    DBCC results for 'tkControl'.
    There are 197 rows in 5 pages for object "tkControl".
    DBCC results for 'exChecksE'.
    There are 0 rows in 1 pages for object "exChecksE".
    DBCC results for 'tkDetail'.
    There are 28490 rows in 411 pages for object "tkDetail".
    DBCC results for 'tkMaster'.
    Msg 2508, Level 16, State 3, Line 2
    The In-row data RSVD page count for object "tkMaster", index ID 0, partition ID 62368935968768, alloc unit ID 62368935968768 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
    There are 2903 rows in 20 pages for object "tkMaster".
    CHECKDB found 0 allocation errors and 1 consistency errors in table 'tkMaster' (object ID 951674438).
    DBCC results for 'CFGPYStateID'.
    There are 0 rows in 1 pages for object "CFGPYStateID".
    DBCC results for 'CFGPYWHCodes'.
    There are 3 rows in 1 pages for object "CFGPYWHCodes".
    DBCC results for 'CFGBillTaxes'.
    There are 0 rows in 1 pages for object "CFGBillTaxes".
    DBCC results for 'TKSecurity'.
    There are 25 rows in 1 pages for object "TKSecurity".
    DBCC results for 'tsControl'.
    There are 0 rows in 1 pages for object "tsControl".
    DBCC results for 'billInvSums'.
    Msg 2508, Level 16, State 3, Line 2
    The In-row data RSVD page count for object "billInvSums", index ID 0, partition ID 69571629547520, alloc unit ID 69571629547520 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
    There are 2301 rows in 29 pages for object "billInvSums".
    CHECKDB found 0 allocation errors and 1 consistency errors in table 'billInvSums' (object ID 1061578820).
    DBCC results for 'tsDetail'.
    There are 0 rows in 1 pages for object "tsDetail".
    DBCC results for 'Form1099Data'.
    There are 0 rows in 1 pages for object "Form1099Data".
    DBCC results for 'billLabDetail'.
    There are 16404 rows in 641 pages for object "billLabDetail".
    DBCC results for 'tsMaster'.
    There are 1 rows in 1 pages for object "tsMaster".
    DBCC results for 'PBLSearchCriteria'.
    There are 38 rows in 1 pages for object "PBLSearchCriteria".
    DBCC results for 'CFGAPMain'.
    There are 1 rows in 1 pages for object "CFGAPMain".
    DBCC results for 'CFGCASortSelect'.
    There are 3 rows in 1 pages for object "CFGCASortSelect".
    DBCC results for 'UN'.
    There are 0 rows in 1 pages for object "UN".
    DBCC results for 'Advantage.X_AR_030808_10454496'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_030808_10454496".
    DBCC results for 'CFGPYWHMethod'.
    There are 4 rows in 1 pages for object "CFGPYWHMethod".
    DBCC results for 'Advantage.X_AR_030818_11215646'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_030818_11215646".
    DBCC results for 'CFGPYWHType'.
    There are 8 rows in 1 pages for object "CFGPYWHType".
    DBCC results for 'Advantage.X_AR_030818_11321235'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_030818_11321235".
    DBCC results for 'CFGReportOptions'.
    There are 31 rows in 2 pages for object "CFGReportOptions".
    DBCC results for 'Advantage.X_AR_030827_09393943'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_030827_09393943".
    DBCC results for 'FormW2Data'.
    There are 0 rows in 1 pages for object "FormW2Data".
    DBCC results for 'CFGBillMain'.
    There are 1 rows in 1 pages for object "CFGBillMain".
    DBCC results for 'CFGRGFormulas'.
    There are 17 rows in 1 pages for object "CFGRGFormulas".
    DBCC results for 'billLimDetail'.
    There are 15 rows in 1 pages for object "billLimDetail".
    DBCC results for 'unControl'.
    There are 0 rows in 1 pages for object "unControl".
    DBCC results for 'CFGRGMethods'.
    There are 6 rows in 1 pages for object "CFGRGMethods".
    DBCC results for 'billRetDetail'.
    There are 0 rows in 1 pages for object "billRetDetail".
    DBCC results for 'CFGTimeAnalysis'.
    There are 7 rows in 1 pages for object "CFGTimeAnalysis".
    DBCC results for 'CFGCLSortSelect'.
    There are 3 rows in 1 pages for object "CFGCLSortSelect".
    DBCC results for 'CFGTimeAnalysisHeadings'.
    There are 8 rows in 1 pages for object "CFGTimeAnalysisHeadings".
    DBCC results for 'billTaxDetail'.
    There are 0 rows in 1 pages for object "billTaxDetail".
    DBCC results for 'billUnitDetail'.
    There are 0 rows in 1 pages for object "billUnitDetail".
    DBCC results for 'unDetail'.
    There are 0 rows in 1 pages for object "unDetail".
    DBCC results for 'Advantage.X_050221_14373119_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050221_14373119_AR".
    DBCC results for 'CFGTKCategory'.
    There are 0 rows in 1 pages for object "CFGTKCategory".
    DBCC results for 'unMaster'.
    There are 0 rows in 1 pages for object "unMaster".
    DBCC results for 'CFGTKEmployeeGroup'.
    There are 0 rows in 1 pages for object "CFGTKEmployeeGroup".
    DBCC results for 'Advantage.X_050221_14480085_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050221_14480085_AR".
    DBCC results for 'GLGroup'.
    There are 0 rows in 1 pages for object "GLGroup".
    DBCC results for 'GLGroupDetail'.
    There are 0 rows in 1 pages for object "GLGroupDetail".
    DBCC results for 'CFGDates'.
    There are 87 rows in 1 pages for object "CFGDates".
    DBCC results for 'GLTable'.
    There are 0 rows in 1 pages for object "GLTable".
    DBCC results for 'VEA'.
    There are 180 rows in 9 pages for object "VEA".
    DBCC results for 'inControl'.
    There are 0 rows in 1 pages for object "inControl".
    DBCC results for 'VEF'.
    There are 1813 rows in 14 pages for object "VEF".
    DBCC results for 'Advantage.X_050922_09400294_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050922_09400294_AR".
    DBCC results for 'VEInitiation'.
    There are 0 rows in 1 pages for object "VEInitiation".
    DBCC results for 'Advantage.X_050922_13444919_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050922_13444919_AR".
    DBCC results for 'CFGTKMain'.
    There are 1 rows in 1 pages for object "CFGTKMain".
    DBCC results for 'Form1099Data2001'.
    There are 31 rows in 2 pages for object "Form1099Data2001".
    DBCC results for 'CFGEKCategory'.
    There are 0 rows in 1 pages for object "CFGEKCategory".
    DBCC results for 'inDetail'.
    There are 0 rows in 1 pages for object "inDetail".
    DBCC results for 'Advantage.X_050922_16130444_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050922_16130444_AR".
    DBCC results for 'Advantage.X_050923_08232190_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050923_08232190_AR".
    DBCC results for 'inMaster'.
    There are 0 rows in 1 pages for object "inMaster".
    DBCC results for 'CFGEKEmployeeGroup'.
    There are 0 rows in 1 pages for object "CFGEKEmployeeGroup".
    DBCC results for 'VO'.
    There are 2732 rows in 39 pages for object "VO".
    DBCC results for 'CFGEmployeeStatus'.
    There are 3 rows in 1 pages for object "CFGEmployeeStatus".
    DBCC results for 'XChargeWk'.
    There are 0 rows in 1 pages for object "XChargeWk".
    DBCC results for 'jeControl'.
    There are 1 rows in 1 pages for object "jeControl".
    DBCC results for 'CFGEmployeeType'.
    There are 2 rows in 1 pages for object "CFGEmployeeType".
    DBCC results for 'CFGVendorStatus'.
    There are 3 rows in 1 pages for object "CFGVendorStatus".
    DBCC results for 'FormW2Data2001'.
    There are 0 rows in 0 pages for object "FormW2Data2001".
    DBCC results for 'CFGEMSortSelect'.
    There are 30 rows in 1 pages for object "CFGEMSortSelect".
    DBCC results for 'CFGVESortSelect'.
    There are 3 rows in 1 pages for object "CFGVESortSelect".
    DBCC results for 'Advantage.X_051021_15523290_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051021_15523290_AR".
    DBCC results for 'Advantage.X_051031_15342061_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051031_15342061_AR".
    DBCC results for 'jeDetail'.
    There are 46 rows in 3 pages for object "jeDetail".
    DBCC results for 'Advantage.X_051101_14035775_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051101_14035775_AR".
    DBCC results for 'jeMaster'.
    There are 18 rows in 4 pages for object "jeMaster".
    DBCC results for 'CL'.
    There are 61 rows in 1 pages for object "CL".
    DBCC results for 'CFGETInterface'.
    There are 0 rows in 1 pages for object "CFGETInterface".
    DBCC results for 'laControl'.
    There are 0 rows in 1 pages for object "laControl".
    DBCC results for 'CLA'.
    There are 65 rows in 3 pages for object "CLA".
    DBCC results for 'CLInitiation'.
    There are 0 rows in 1 pages for object "CLInitiation".
    DBCC results for 'Advantage.X_AR_030602_11402487'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_030602_11402487".
    DBCC results for 'Advantage.X_051128_09025016_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051128_09025016_AR".
    DBCC results for 'ED'.
    There are 31684 rows in 1086 pages for object "ED".
    DBCC results for 'billBatchList'.
    There are 159 rows in 2 pages for object "billBatchList".
    DBCC results for 'CFGInstall'.
    There are 1 rows in 1 pages for object "CFGInstall".
    DBCC results for 'laDetail'.
    There are 0 rows in 1 pages for object "laDetail".
    DBCC results for 'CR'.
    There are 2432 rows in 31 pages for object "CR".
    DBCC results for 'BIED'.
    There are 131 rows in 7 pages for object "BIED".
    DBCC results for 'CFGInvMap'.
    There are 3 rows in 1 pages for object "CFGInvMap".
    DBCC results for 'CFGLabels'.
    There are 1 rows in 1 pages for object "CFGLabels".
    DBCC results for 'Advantage.X_051219_10520360_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051219_10520360_AR".
    DBCC results for 'laMaster'.
    There are 0 rows in 1 pages for object "laMaster".
    DBCC results for 'CFGLC1'.
    There are 5 rows in 1 pages for object "CFGLC1".
    DBCC results for 'crControl'.
    There are 0 rows in 1 pages for object "crControl".
    DBCC results for 'CFGLC2'.
    There are 3 rows in 1 pages for object "CFGLC2".
    DBCC results for 'LB'.
    There are 0 rows in 1 pages for object "LB".
    DBCC results for 'LD'.
    There are 32710 rows in 1100 pages for object "LD".
    DBCC results for 'CFGLC3'.
    There are 1 rows in 1 pages for object "CFGLC3".
    DBCC results for 'CFGLC4'.
    There are 0 rows in 1 pages for object "CFGLC4".
    DBCC results for 'BILD'.
    There are 68 rows in 3 pages for object "BILD".
    DBCC results for 'CFGLC5'.
    There are 0 rows in 1 pages for object "CFGLC5".
    DBCC results for 'crDetail'.
    There are 0 rows in 3 pages for object "crDetail".
    DBCC results for 'miControl'.
    There are 0 rows in 1 pages for object "miControl".
    DBCC results for 'PR'.
    There are 1050 rows in 69 pages for object "PR".
    DBCC results for 'crMaster'.
    There are 0 rows in 1 pages for object "crMaster".
    DBCC results for 'billFeeDetail'.
    There are 5398 rows in 130 pages for object "billFeeDetail".
    DBCC results for 'PRInitiation'.
    There are 0 rows in 1 pages for object "PRInitiation".
    DBCC results for 'miDetail'.
    There are 0 rows in 1 pages for object "miDetail".
    DBCC results for 'cvControl'.
    There are 0 rows in 1 pages for object "cvControl".
    DBCC results for 'BT'.
    There are 997 rows in 44 pages for object "BT".
    DBCC results for 'miMaster'.
    There are 0 rows in 1 pages for object "miMaster".
    DBCC results for 'Advantage.X_060220_11551165_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060220_11551165_AR".
    DBCC results for 'OverheadAllocation'.
    There are 222 rows in 7 pages for object "OverheadAllocation".
    DBCC results for 'PBLReportColumns'.
    There are 19 rows in 2 pages for object "PBLReportColumns".
    DBCC results for 'PBLReportOptions'.
    There are 300 rows in 5 pages for object "PBLReportOptions".
    DBCC results for 'cvDetail'.
    There are 0 rows in 1 pages for object "cvDetail".
    DBCC results for 'PBLReportFavorites'.
    There are 1 rows in 1 pages for object "PBLReportFavorites".
    DBCC results for 'BTA'.
    There are 8 rows in 1 pages for object "BTA".
    DBCC results for 'SE'.
    There are 2 rows in 1 pages for object "SE".
    DBCC results for 'cvMaster'.
    There are 0 rows in 1 pages for object "cvMaster".
    DBCC results for 'PBLReportWhere'.
    There are 2 rows in 1 pages for object "PBLReportWhere".
    DBCC results for 'Advantage.X_060329_09040623_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060329_09040623_AR".
    DBCC results for 'PBLReportWhereDetail'.
    There are 4 rows in 1 pages for object "PBLReportWhereDetail".
    DBCC results for 'EB'.
    There are 0 rows in 1 pages for object "EB".
    DBCC results for 'plAccountSS'.
    There are 0 rows in 1 pages for object "plAccountSS".
    DBCC results for 'plClientSS'.
    There are 1 rows in 1 pages for object "plClientSS".
    DBCC results for 'plEmployeeSS'.
    There are 5 rows in 1 pages for object "plEmployeeSS".
    DBCC results for 'plProjectSS'.
    There are 157 rows in 2 pages for object "plProjectSS".
    DBCC results for 'plVendorSS'.
    There are 0 rows in 1 pages for object "plVendorSS".
    DBCC results for 'ekDetail'.
    There are 0 rows in 1 pages for object "ekDetail".
    DBCC results for 'ekMaster'.
    There are 0 rows in 1 pages for object "ekMaster".
    CHECKDB found 0 allocation errors and 5 consistency errors in database 'Cloward'.
    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

    to fix these issues do i just need to run the dbcc updateusage command as it is noted throughout this log:

    open query analyzer and run the following.

    USE <database name>
    DBCC updateusage

    will running the updateusage command cause any data loss?
     
  • Monday, November 02, 2009 10:15 PMxchangepatewon Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    so i ran the dbcc updateusage command as follows and below is the output:

    use <database name>
    DBCC updateusage (0)   (Update sysindexes by specifying 0 for the current database)

    Output:

    DBCC UPDATEUSAGE: counts updated for table 'sysfiles1' (index 'sysfiles1', partition 1):
            DATA pages (In-row Data): changed from (2) to (1) pages.
    DBCC UPDATEUSAGE: counts updated for table 'PRF' (index 'PRF', partition 1):
            RSVD pages (In-row Data): changed from (-115) to (33) pages.
    DBCC UPDATEUSAGE: counts updated for table 'PRF' (index 'prfPeriodIDX', partition 1):
            RSVD pages (In-row Data): changed from (16) to (17) pages.
    DBCC UPDATEUSAGE: counts updated for table 'PRF' (index 'PRFPK', partition 1):
            RSVD pages (In-row Data): changed from (24) to (25) pages.
    DBCC UPDATEUSAGE: counts updated for table 'CFGPostControl' (index 'CFGPostControl', partition 1):
            USED pages (In-row Data): changed from (70) to (52) pages.
            RSVD pages (In-row Data): changed from (15) to (57) pages.
    DBCC UPDATEUSAGE: counts updated for table 'CFGPostControl' (index 'CFGPostControlPK', partition 1):
            RSVD pages (In-row Data): changed from (16) to (17) pages.
    DBCC UPDATEUSAGE: counts updated for table 'AR' (index 'AR', partition 1):
            USED pages (In-row Data): changed from (18) to (16) pages.
            RSVD pages (In-row Data): changed from (-185) to (17) pages.
    DBCC UPDATEUSAGE: counts updated for table 'AR' (index 'ARPK', partition 1):
            RSVD pages (In-row Data): changed from (8) to (17) pages.
    DBCC UPDATEUSAGE: counts updated for table 'billExpDetail' (index 'billExpDetail', partition 1):
            USED pages (In-row Data): changed from (71) to (58) pages.
            RSVD pages (In-row Data): changed from (7) to (65) pages.
    DBCC UPDATEUSAGE: counts updated for table 'billExpDetail' (index 'billExpDetailPK', partition 1):
            RSVD pages (In-row Data): changed from (16) to (17) pages.
    DBCC UPDATEUSAGE: counts updated for table 'RPTActivityList' (index 'RPTActivityList', partition 1):
            RSVD pages (In-row Data): changed from (0) to (17) pages.
    DBCC UPDATEUSAGE: counts updated for table 'RPTActivityList' (index 'UsernameIDX', partition 1):
            RSVD pages (In-row Data): changed from (17) to (18) pages.
    DBCC UPDATEUSAGE: counts updated for table 'billINDetail' (index 'billINDetail', partition 1):
            USED pages (In-row Data): changed from (34) to (30) pages.
            RSVD pages (In-row Data): changed from (-625) to (33) pages.
    DBCC UPDATEUSAGE: counts updated for table 'billINDetail' (index 'billINDetailPK', partition 1):
            RSVD pages (In-row Data): changed from (8) to (17) pages.
    DBCC UPDATEUSAGE: counts updated for table 'billINMaster' (index 'billINMaster', partition 1):
            USED pages (In-row Data): changed from (122) to (68) pages.
            RSVD pages (In-row Data): changed from (63) to (73) pages.
    DBCC UPDATEUSAGE: counts updated for table 'billINMaster' (index 'billINMasterPK', partition 1):
            RSVD pages (In-row Data): changed from (56) to (57) pages.
    DBCC UPDATEUSAGE: counts updated for table 'billInvMaster' (index 'billInvMaster', partition 1):
            USED pages (In-row Data): changed from (96) to (82) pages.
            RSVD pages (In-row Data): changed from (31) to (89) pages.
    DBCC UPDATEUSAGE: counts updated for table 'billInvMaster' (index 'billInvMasterPK', partition 1):
            RSVD pages (In-row Data): changed from (16) to (17) pages.
    DBCC UPDATEUSAGE: counts updated for table 'tkDetail' (index 'tkDetail', partition 1):
            RSVD pages (In-row Data): changed from (343) to (417) pages.
    DBCC UPDATEUSAGE: counts updated for table 'tkDetail' (index 'tkDetailPK', partition 1):
            RSVD pages (In-row Data): changed from (160) to (161) pages.
    DBCC UPDATEUSAGE: counts updated for table 'tkMaster' (index 'tkMaster', partition 1):
            RSVD pages (In-row Data): changed from (-49) to (25) pages.
    DBCC UPDATEUSAGE: counts updated for table 'tkMaster' (index 'tkMasterPK', partition 1):
            RSVD pages (In-row Data): changed from (16) to (17) pages.
    DBCC UPDATEUSAGE: counts updated for table 'billInvSums' (index 'billInvSums', partition 1):
            USED pages (In-row Data): changed from (44) to (30) pages.
            RSVD pages (In-row Data): changed from (-25) to (33) pages.
    DBCC UPDATEUSAGE: counts updated for table 'billInvSums' (index 'billInvSumsPK', partition 1):
            RSVD pages (In-row Data): changed from (16) to (17) pages.
    DBCC UPDATEUSAGE: counts updated for table 'billLabDetail' (index 'billLabDetail', partition 1):
            DATA pages (In-row Data): changed from (639) to (641) pages.
            USED pages (In-row Data): changed from (798) to (642) pages.
            RSVD pages (In-row Data): changed from (727) to (649) pages.
    DBCC UPDATEUSAGE: counts updated for table 'billLabDetail' (index 'billLabDetailPK', partition 1):
            RSVD pages (In-row Data): changed from (96) to (97) pages.
    DBCC UPDATEUSAGE: counts updated for table 'VO' (index 'VO', partition 1):
            RSVD pages (In-row Data): changed from (0) to (41) pages.
    DBCC UPDATEUSAGE: counts updated for table 'VO' (index 'VOPK', partition 1):
            RSVD pages (In-row Data): changed from (16) to (17) pages.
    DBCC UPDATEUSAGE: counts updated for table 'ED' (index 'edTransTypeedSubTypeIDX', partition 1):
            RSVD pages (In-row Data): changed from (1096) to (1097) pages.
    DBCC UPDATEUSAGE: counts updated for table 'ED' (index 'edAccountIDX', partition 1):
            RSVD pages (In-row Data): changed from (121) to (122) pages.
    DBCC UPDATEUSAGE: counts updated for table 'ED' (index 'edBillStatusIDX', partition 1):
            RSVD pages (In-row Data): changed from (106) to (107) pages.
    DBCC UPDATEUSAGE: counts updated for table 'ED' (index 'edInvoiceIDX', partition 1):
            RSVD pages (In-row Data): changed from (106) to (107) pages.
    DBCC UPDATEUSAGE: counts updated for table 'ED' (index 'edPeriodedPostSeqIDX', partition 1):
            RSVD pages (In-row Data): changed from (120) to (121) pages.
    DBCC UPDATEUSAGE: counts updated for table 'ED' (index 'EDPK', partition 1):
            RSVD pages (In-row Data): changed from (112) to (113) pages.
    DBCC UPDATEUSAGE: counts updated for table 'ED' (index 'edProjectedTaskIDX', partition 1):
            RSVD pages (In-row Data): changed from (153) to (154) pages.
    DBCC UPDATEUSAGE: counts updated for table 'ED' (index 'edVendoredVoucherIDX', partition 1):
            RSVD pages (In-row Data): changed from (131) to (132) pages.
    DBCC UPDATEUSAGE: counts updated for table 'CR' (index 'CR', partition 1):
            USED pages (In-row Data): changed from (56) to (32) pages.
            RSVD pages (In-row Data): changed from (7) to (33) pages.
    DBCC UPDATEUSAGE: counts updated for table 'CR' (index 'CRPK', partition 1):
            RSVD pages (In-row Data): changed from (16) to (17) pages.
    DBCC UPDATEUSAGE: counts updated for table 'LD' (index 'LD', partition 1):
            DATA pages (In-row Data): changed from (1097) to (1100) pages.
            USED pages (In-row Data): changed from (1724) to (1101) pages.
            RSVD pages (In-row Data): changed from (1437) to (1105) pages.
    DBCC UPDATEUSAGE: counts updated for table 'LD' (index 'ldBillStatusIDX', partition 1):
            RSVD pages (In-row Data): changed from (88) to (89) pages.
    DBCC UPDATEUSAGE: counts updated for table 'LD' (index 'ldPeriodldPostSeqIDX', partition 1):
            RSVD pages (In-row Data): changed from (96) to (97) pages.
    DBCC UPDATEUSAGE: counts updated for table 'LD' (index 'LDPK', partition 1):
            RSVD pages (In-row Data): changed from (72) to (73) pages.
    DBCC UPDATEUSAGE: counts updated for table 'LD' (index 'ldProjectldTaskIDX', partition 1):
            RSVD pages (In-row Data): changed from (160) to (161) pages.
    DBCC UPDATEUSAGE: counts updated for table 'PR' (index 'PR', partition 1):
            RSVD pages (In-row Data): changed from (81) to (73) pages.
    DBCC UPDATEUSAGE: counts updated for table 'billFeeDetail' (index 'billFeeDetail', partition 1):
            USED pages (In-row Data): changed from (161) to (131) pages.
            RSVD pages (In-row Data): changed from (103) to (137) pages.
    DBCC UPDATEUSAGE: counts updated for table 'billFeeDetail' (index 'billFeeDetailPK', partition 1):
            RSVD pages (In-row Data): changed from (32) to (33) pages.
    DBCC execution completed. If DBCC printed error messages, contact your system administrator.


    now i went back and ran the dbcc checkdb command again and now i get this:

    CHECKDB found 0 allocation errors and 0 consistency errors in database 'Contoso'

    is it safe to assume that this will fix the issue of my backups failing on this database now?


     
  • Monday, November 02, 2009 10:23 PMLekssAnswererUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Most probably this should end your problem . Please update the thread with whats the result for your next backup schedule
    Thanks, Leks
     
  • Monday, November 02, 2009 10:39 PMxchangepatewon Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    the backup will run tonight, i will let you know the outcome tomorrow. thanks to everyone who responded for your assistance on this issue.
     
  • Monday, November 02, 2009 10:53 PMAmit Banerjee - MSFT Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    As pointed to by the Backup Exec support article, there is an option to run CHECKDB on the database before backing it up. If the DBCC operation fails, then the backup job would also fail. Since CHECKDB is reporting 0 errors (compared to the 5 errors previously), your backup plan should succeed now.
    This posting is provided "AS IS" with no warranties, and confers no rights. My Blog: Troubleshooting SQL
     
  • Tuesday, November 03, 2009 2:14 PMxchangepatewon Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    well my backup ran, and still failed although im not sure whether this failure is pointing to my contoso DB or this ptcareerSQL DB listed on the bottom error:

    is this error still for the contoso DB, or for the ptcareerSQL db referenced in the error below?
    Backup- \\sqlserver2.contoso.com\D: New VolumeAn unknown or unexpected database error occurred while attempting a DBCC.
    An internal error occurred in DBCC that prevented further processing. Contact Customer Support Services.

    Backup- sqlserver2.contoso.com V-79-57344-33938 - An error occurred on a query to database ptcareersSQL.
    V-79-57344-33938 - Database 'ptcareersSQL' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.

    the top error was the same one i received before with the contoso DB but it actually referenced the name contoso DB in the error. this time it is not referencing its name.

    here is the error i received before i ran the dbcc command yesterday:
    Backup- \\sqlserver2.contoso.com\D: New Volume An unknown or unexpected database error occurred while attempting a DBCC.
    An internal error occurred in DBCC that prevented further processing. Contact Customer Support Services.
    An unknown or unexpected database error occurred while attempting a DBCC.
    DBCC results for 'Contoso'.

    and of course my next issue is fixing the ptcareerSQL db from showing as suspect and will need some assistance with that one. i will start a new thread for it shortly.

    any thoughts or suggestions as to what i should do next?

     
  • Tuesday, November 03, 2009 2:38 PMTiborKMVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Open a support case with MS Support (or similar). Suspect databases should only be handled by trained professionals.
    Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi
     
  • Tuesday, November 03, 2009 5:31 PMxchangepatewon Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    we determined that the ptcareersql db is not even being utilized by our company at the moment so the db was empty and was not holding any of our data within it. we detached the suspect one and reattached a working one. so will see if after the backups run tonight if i still receive those error messages.

     
  • Wednesday, November 04, 2009 2:52 PMxchangepatewon Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

    Well after looking at the backup exec logs and the SQL Error log i determined that i have a problem with a different database called Advantage. here is the manual dbcc checkdb there are a bunch of problems with this DB and i need some assistance on fixing this?

    Msg 8967, Level 16, State 216, Line 2
    An internal error occurred in DBCC that prevented further processing. Contact Customer Support Services.
    DBCC results for 'Advantage'.
    Msg 8921, Level 16, State 1, Line 2
    Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
    Msg 8909, Level 16, State 1, Line 2
    Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:123312) contains an incorrect page ID in its page header. The PageId in the page header = (0:0).
    Msg 8909, Level 16, State 1, Line 2
    Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 3472609771204378624 (type Unknown), page ID (1:114736) contains an incorrect page ID in its page header. The PageId in the page header = (148:1862270976).
    CHECKDB found 0 allocation errors and 2 consistency errors not associated with any single object.
    DBCC results for 'sys.sysrowsetcolumns'.
    There are 7205 rows in 40 pages for object "sys.sysrowsetcolumns".
    DBCC results for 'sys.sysrowsets'.
    There are 1532 rows in 11 pages for object "sys.sysrowsets".
    DBCC results for 'sysallocunits'.
    There are 1563 rows in 17 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 7205 rows in 48 pages for object "sys.syshobtcolumns".
    DBCC results for 'sys.syshobts'.
    There are 1532 rows in 11 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 1563 rows in 7 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 123 rows in 1 pages for object "sys.sysprivs".
    DBCC results for 'sys.sysschobjs'.
    There are 1945 rows in 26 pages for object "sys.sysschobjs".
    DBCC results for 'sys.syscolpars'.
    There are 6833 rows in 69 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 2 rows in 1 pages for object "sys.sysxprops".
    DBCC results for 'sys.sysscalartypes'.
    There are 27 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 3549 rows in 39 pages for object "sys.sysidxstats".
    DBCC results for 'sys.sysiscols'.
    There are 2802 rows in 13 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 2860 rows in 834 pages for object "sys.sysobjvalues".
    DBCC results for 'sys.sysclsobjs'.
    There are 16 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 135 rows in 1 pages for object "sys.syssingleobjrefs".
    DBCC results for 'sys.sysmultiobjrefs'.
    There are 1302 rows in 9 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 92 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 0 rows in 0 pages for object "sys.sysbinsubobjs".
    DBCC results for 'Advantage.X_060126_11335877'.
    There are 5 rows in 1 pages for object "Advantage.X_060126_11335877".
    DBCC results for 'CFGAPDiscount'.
    There are 1 rows in 1 pages for object "CFGAPDiscount".
    DBCC results for 'Advantage.X_030529_09554416'.
    There are 7202 rows in 28 pages for object "Advantage.X_030529_09554416".
    DBCC results for 'Advantage.X_AR_041117_14395370'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_041117_14395370".
    DBCC results for 'apppChecks'.
    There are 0 rows in 1 pages for object "apppChecks".
    DBCC results for 'Advantage.X_061114_15443262'.
    There are 504 rows in 2 pages for object "Advantage.X_061114_15443262".
    DBCC results for 'Advantage.X_020821_09350209'.
    There are 5643 rows in 22 pages for object "Advantage.X_020821_09350209".
    DBCC results for 'Advantage.X_050907_13551720_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050907_13551720_AR".
    DBCC results for 'Advantage.X_070920_10275056'.
    There are 0 rows in 0 pages for object "Advantage.X_070920_10275056".
    DBCC results for 'Advantage.X_060404_13003827_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060404_13003827_AR".
    DBCC results for 'Advantage.X_050317_09044579_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050317_09044579_AR".
    DBCC results for 'Advantage.X_050209_08505294_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050209_08505294_AR".
    DBCC results for 'Advantage.X_070214_16182360_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070214_16182360_AR".
    DBCC results for 'Advantage.X_030529_10130096'.
    There are 7106 rows in 28 pages for object "Advantage.X_030529_10130096".
    DBCC results for 'Advantage.X_061114_15465048'.
    There are 504 rows in 2 pages for object "Advantage.X_061114_15465048".
    DBCC results for 'Advantage.X_020821_09425215'.
    There are 5643 rows in 22 pages for object "Advantage.X_020821_09425215".
    DBCC results for 'Advantage.X_050907_13551720'.
    There are 3 rows in 1 pages for object "Advantage.X_050907_13551720".
    DBCC results for 'Advantage.X_050603_10110989_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050603_10110989_AR".
    DBCC results for 'Advantage.X_070614_14284350_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070614_14284350_AR".
    DBCC results for 'CFGPYWHCodes'.
    There are 3 rows in 1 pages for object "CFGPYWHCodes".
    DBCC results for 'Advantage.X_070403_16220134_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070403_16220134_AR".
    DBCC results for 'Advantage.X_060130_09011380_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060130_09011380_AR".
    DBCC results for 'Advantage.X_050209_08505294'.
    There are 201 rows in 1 pages for object "Advantage.X_050209_08505294".
    DBCC results for 'CFGAPForm1099'.
    There are 1 rows in 1 pages for object "CFGAPForm1099".
    DBCC results for 'Advantage.X_030529_10151127'.
    There are 2346 rows in 10 pages for object "Advantage.X_030529_10151127".
    DBCC results for 'Advantage.X_051115_15584430_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051115_15584430_AR".
    DBCC results for 'Advantage.X_AR_041117_14411268'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_041117_14411268".
    DBCC results for 'Advantage.X_061114_15491295'.
    There are 504 rows in 2 pages for object "Advantage.X_061114_15491295".
    DBCC results for 'Advantage.X_020821_09460666'.
    There are 5643 rows in 22 pages for object "Advantage.X_020821_09460666".
    DBCC results for 'Advantage.X_050908_09475593_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050908_09475593_AR".
    DBCC results for 'Advantage.X_070920_15344878'.
    There are 0 rows in 0 pages for object "Advantage.X_070920_15344878".
    DBCC results for 'EMPED'.
    There are 0 rows in 0 pages for object "EMPED".
    DBCC results for 'Advantage.X_060405_14032400_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060405_14032400_AR".
    DBCC results for 'Advantage.X_050321_11514837_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050321_11514837_AR".
    DBCC results for 'Advantage.X_060130_09011380'.
    There are 5 rows in 1 pages for object "Advantage.X_060130_09011380".
    DBCC results for 'Advantage.X_050209_08524554_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050209_08524554_AR".
    DBCC results for 'CFGAPLiability'.
    There are 2 rows in 1 pages for object "CFGAPLiability".
    DBCC results for 'Advantage.X_070214_16523124_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070214_16523124_AR".
    DBCC results for 'Advantage.X_030529_10171851'.
    There are 2346 rows in 10 pages for object "Advantage.X_030529_10171851".
    DBCC results for 'AR'.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 53575229, index ID 3, partition ID 847936036339712, alloc unit ID 847936036339712 (type In-row data): Page (1:208385) could not be processed.  See other errors for details.
    Msg 8941, Level 16, State 1, Line 2
    Table error: Object ID 53575229, index ID 3, partition ID 847936036339712, alloc unit ID 847936036339712 (type In-row data), page (1:208385). Test (sorted [i].offset >= PAGEHEADSIZE) failed. Slot 32, offset 0x1 is invalid.
    Msg 8942, Level 16, State 1, Line 2
    Table error: Object ID 53575229, index ID 3, partition ID 847936036339712, alloc unit ID 847936036339712 (type In-row data), page (1:208385). Test (sorted[i].offset >= max) failed. Slot 0, offset 0x20 overlaps with the prior row.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 53575229, index ID 3, partition ID 847936036339712, alloc unit ID 847936036339712 (type In-row data): Page (1:208414) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 29, Line 2
    Table error: Object ID 53575229, index ID 3, partition ID 847936036339712, alloc unit ID 847936036339712 (type In-row data), page (1:208414), row 103. Test (offsetNull >= BASEOFFSET) failed. Values are 1 and 4.
    Msg 8944, Level 16, State 29, Line 2
    Table error: Object ID 53575229, index ID 3, partition ID 847936036339712, alloc unit ID 847936036339712 (type In-row data), page (1:208414), row 103. Test (offsetNull >= BASEOFFSET) failed. Values are 1 and 4.
    There are 63791 rows in 467 pages for object "AR".
    CHECKDB found 0 allocation errors and 6 consistency errors in table 'AR' (object ID 53575229).
    DBCC results for 'Advantage.X_061114_16031560'.
    There are 504 rows in 2 pages for object "Advantage.X_061114_16031560".
    DBCC results for 'Advantage.X_020821_09510768'.
    There are 5643 rows in 22 pages for object "Advantage.X_020821_09510768".
    DBCC results for 'tsDetail'.
    There are 0 rows in 1 pages for object "tsDetail".
    DBCC results for 'Advantage.X_050603_10213627_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050603_10213627_AR".
    DBCC results for 'Advantage.X_070404_14542871_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070404_14542871_AR".
    DBCC results for 'Advantage.X_060131_15015410_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060131_15015410_AR".
    DBCC results for 'Advantage.X_030529_15331172'.
    There are 8015 rows in 31 pages for object "Advantage.X_030529_15331172".
    DBCC results for 'Advantage.X_AR_041118_09304901'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_041118_09304901".
    DBCC results for 'Advantage.X_061114_16044942'.
    There are 504 rows in 2 pages for object "Advantage.X_061114_16044942".
    DBCC results for 'Advantage.X_020821_09574042'.
    There are 6127 rows in 24 pages for object "Advantage.X_020821_09574042".
    DBCC results for 'tsMaster'.
    Msg 2508, Level 16, State 3, Line 2
    The In-row data RSVD page count for object "tsMaster", index ID 0, partition ID 4697050513408, alloc unit ID 4697050513408 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
    There are 2130 rows in 17 pages for object "tsMaster".
    CHECKDB found 0 allocation errors and 1 consistency errors in table 'tsMaster' (object ID 71671303).
    DBCC results for 'Advantage.X_070614_16383240'.
    There are 1 rows in 1 pages for object "Advantage.X_070614_16383240".
    DBCC results for 'Advantage.X_031209_17000142'.
    There are 3083 rows in 12 pages for object "Advantage.X_031209_17000142".
    DBCC results for 'Advantage.X_060406_09514417'.
    There are 6082 rows in 24 pages for object "Advantage.X_060406_09514417".
    DBCC results for 'Advantage.X_050321_14202715_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050321_14202715_AR".
    DBCC results for 'Advantage.X_050209_09030820_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050209_09030820_AR".
    DBCC results for 'CFGAPStateID'.
    There are 0 rows in 0 pages for object "CFGAPStateID".
    DBCC results for 'Advantage.X_070214_17041363'.
    There are 7032 rows in 28 pages for object "Advantage.X_070214_17041363".
    DBCC results for 'Advantage.X_030529_15363388'.
    There are 7111 rows in 28 pages for object "Advantage.X_030529_15363388".
    DBCC results for 'Advantage.X_051116_10521842_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051116_10521842_AR".
    DBCC results for 'Advantage.X_041118_09304901'.
    There are 685 rows in 3 pages for object "Advantage.X_041118_09304901".
    DBCC results for 'Advantage.X_061114_16092391'.
    There are 504 rows in 2 pages for object "Advantage.X_061114_16092391".
    DBCC results for 'Advantage.X_020821_10482102'.
    There are 5643 rows in 22 pages for object "Advantage.X_020821_10482102".
    DBCC results for 'PRTemplates'.
    There are 0 rows in 0 pages for object "PRTemplates".
    DBCC results for 'Advantage.X_050607_15273836'.
    There are 15 rows in 1 pages for object "Advantage.X_050607_15273836".
    DBCC results for 'Advantage.X_031209_17032042'.
    There are 3184 rows in 13 pages for object "Advantage.X_031209_17032042".
    DBCC results for 'Advantage.X_060406_15370423_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060406_15370423_AR".
    DBCC results for 'CFGPWPInterface'.
    There are 1 rows in 1 pages for object "CFGPWPInterface".
    DBCC results for 'Advantage.X_070404_15140755_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070404_15140755_AR".
    DBCC results for 'Advantage.X_060201_11131417'.
    There are 12006 rows in 47 pages for object "Advantage.X_060201_11131417".
    DBCC results for 'CFGAPVendorType'.
    There are 3 rows in 1 pages for object "CFGAPVendorType".
    DBCC results for 'Advantage.X_030529_15433409'.
    There are 2434 rows in 10 pages for object "Advantage.X_030529_15433409".
    DBCC results for 'Advantage.X_AR_041118_10113193'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_041118_10113193".
    DBCC results for 'Advantage.X_061114_16105214'.
    There are 504 rows in 2 pages for object "Advantage.X_061114_16105214".
    DBCC results for 'Advantage.X_020821_10524439'.
    There are 5643 rows in 22 pages for object "Advantage.X_020821_10524439".
    DBCC results for 'Advantage.X_050909_15244801_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050909_15244801_AR".
    DBCC results for 'UN'.
    There are 0 rows in 0 pages for object "UN".
    DBCC results for 'Advantage.X_050608_09560292_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050608_09560292_AR".
    DBCC results for 'Advantage.X_050322_07564587_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050322_07564587_AR".
    DBCC results for 'CFGPYAccruals'.
    There are 2 rows in 1 pages for object "CFGPYAccruals".
    DBCC results for 'Advantage.X_050209_09072624_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050209_09072624_AR".
    DBCC results for 'Advantage.X_070215_08583405_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070215_08583405_AR".
    DBCC results for 'Advantage.X_030529_15492260'.
    There are 2434 rows in 10 pages for object "Advantage.X_030529_15492260".
    DBCC results for 'Advantage.X_051116_15151427_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051116_15151427_AR".
    DBCC results for 'Advantage.X_041118_10183706_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_041118_10183706_AR".
    DBCC results for 'Advantage.X_050909_15244801'.
    There are 9 rows in 1 pages for object "Advantage.X_050909_15244801".
    DBCC results for 'sys.queue_messages_103723472'.
    There are 0 rows in 0 pages for object "sys.queue_messages_103723472".
    DBCC results for 'Form1099Data'.
    There are 25 rows in 2 pages for object "Form1099Data".
    DBCC results for 'Advantage.X_060407_08380245_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060407_08380245_AR".
    DBCC results for 'Advantage.X_070406_10031620_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070406_10031620_AR".
    DBCC results for 'Advantage.X_010531_10271093'.
    There are 15 rows in 1 pages for object "Advantage.X_010531_10271093".
    DBCC results for 'CFGARLedgerHeadings'.
    There are 7 rows in 1 pages for object "CFGARLedgerHeadings".
    DBCC results for 'Advantage.X_030529_16321101'.
    There are 2434 rows in 10 pages for object "Advantage.X_030529_16321101".
    DBCC results for 'Advantage.X_050912_11394362_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050912_11394362_AR".
    DBCC results for 'Advantage.X_041026_13030294_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_041026_13030294_AR".
    DBCC results for 'Advantage.X_050610_08465000_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050610_08465000_AR".
    DBCC results for 'Advantage.X_060407_08380245'.
    There are 12 rows in 1 pages for object "Advantage.X_060407_08380245".
    DBCC results for 'Advantage.X_050322_11171029_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050322_11171029_AR".
    DBCC results for 'Advantage.X_060202_08574202_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060202_08574202_AR".
    DBCC results for 'Advantage.X_010531_10394105'.
    There are 15 rows in 1 pages for object "Advantage.X_010531_10394105".
    DBCC results for 'Advantage.X_050209_11195810_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050209_11195810_AR".
    DBCC results for 'CFGARMap'.
    There are 6 rows in 1 pages for object "CFGARMap".
    DBCC results for 'Advantage.X_051117_09354816_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051117_09354816_AR".
    DBCC results for 'Advantage.X_AR_041118_10354036'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_041118_10354036".
    DBCC results for 'Advantage.X_061115_09155453_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_061115_09155453_AR".
    DBCC results for 'Advantage.X_020827_15505266'.
    There are 0 rows in 0 pages for object "Advantage.X_020827_15505266".
    DBCC results for 'sys.queue_messages_135723586'.
    There are 0 rows in 0 pages for object "sys.queue_messages_135723586".
    DBCC results for 'pwpMapping'.
    There are 136 rows in 2 pages for object "pwpMapping".
    DBCC results for 'Advantage.X_070618_08504521'.
    There are 6124 rows in 24 pages for object "Advantage.X_070618_08504521".
    DBCC results for 'Advantage.X_031212_10100626'.
    There are 7894 rows in 31 pages for object "Advantage.X_031212_10100626".
    DBCC results for 'Advantage.X_070409_15064867_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070409_15064867_AR".
    DBCC results for 'Advantage.X_050209_11195810'.
    There are 6 rows in 1 pages for object "Advantage.X_050209_11195810".
    DBCC results for 'Advantage.X_041026_13412671_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_041026_13412671_AR".
    DBCC results for 'Advantage.X_050610_09074308_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050610_09074308_AR".
    DBCC results for 'Advantage.X_031212_10350331'.
    There are 3206 rows in 13 pages for object "Advantage.X_031212_10350331".
    DBCC results for 'Advantage.X_050323_10154718_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050323_10154718_AR".
    DBCC results for 'CFGPYFormW2'.
    There are 1 rows in 1 pages for object "CFGPYFormW2".
    DBCC results for 'Advantage.X_060203_16162383_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060203_16162383_AR".
    DBCC results for 'Advantage.X_050210_09265971'.
    There are 3925 rows in 16 pages for object "Advantage.X_050210_09265971".
    DBCC results for 'Advantage.X_050913_15013594_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050913_15013594_AR".
    DBCC results for 'unControl'.
    There are 0 rows in 1 pages for object "unControl".
    DBCC results for 'sys.queue_messages_167723700'.
    There are 0 rows in 0 pages for object "sys.queue_messages_167723700".
    DBCC results for 'pwpMappingDefault'.
    There are 136 rows in 2 pages for object "pwpMappingDefault".
    DBCC results for 'Advantage.X_050610_09074308'.
    There are 5 rows in 1 pages for object "Advantage.X_050610_09074308".
    DBCC results for 'Advantage.X_031212_10381832'.
    There are 3206 rows in 13 pages for object "Advantage.X_031212_10381832".
    DBCC results for 'CFGTKCategory'.
    There are 0 rows in 1 pages for object "CFGTKCategory".
    DBCC results for 'Advantage.X_070409_17431628_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070409_17431628_AR".

     
  • Wednesday, November 04, 2009 2:54 PMxchangepatewon Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

    DBCC results for 'ED'.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 12539641593856 (type In-row data): Page (1:239790) could not be processed.  See other errors for details.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 12539641593856 (type In-row data): Page (1:239854) could not be processed.  See other errors for details.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 12539641593856 (type In-row data): Page (1:239998) could not be processed.  See other errors for details.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 12539641593856 (type In-row data): Page (1:240046) could not be processed.  See other errors for details.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 12539641593856 (type In-row data): Page (1:240174) could not be processed.  See other errors for details.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 12539641593856 (type In-row data): Page (1:240515) could not be processed.  See other errors for details.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 12539641593856 (type In-row data): Page (1:240862) could not be processed.  See other errors for details.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 12539641593856 (type In-row data): Page (1:240878) could not be processed.  See other errors for details.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 12539641593856 (type In-row data): Page (1:241246) could not be processed.  See other errors for details.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 12539641593856 (type In-row data): Page (1:249326) could not be processed.  See other errors for details.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 12539641593856 (type In-row data): Page (1:249710) could not be processed.  See other errors for details.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 12539641593856 (type In-row data): Page (1:249822) could not be processed.  See other errors for details.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 12539641593856 (type In-row data): Page (1:250158) could not be processed.  See other errors for details.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 12539641593856 (type In-row data): Page (1:250782) could not be processed.  See other errors for details.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 12539641593856 (type In-row data): Page (1:271230) could not be processed.  See other errors for details.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 12539641593856 (type In-row data): Page (1:271537) could not be processed.  See other errors for details.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 12539641593856 (type In-row data): Page (1:272126) could not be processed.  See other errors for details.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 12539641593856 (type In-row data): Page (1:272942) could not be processed.  See other errors for details.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 12539641593856 (type In-row data): Page (1:273006) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 12, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:239790), row 16. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 3697 and 239.
    Msg 8944, Level 16, State 12, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:239790), row 16. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 3697 and 239.
    Msg 8944, Level 16, State 18, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:239854), row 16. Test (columnOffsets->offTbl [varColumnNumber] >= priorOffset) failed. Values are 1 and 229.
    Msg 8944, Level 16, State 18, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:239854), row 16. Test (columnOffsets->offTbl [varColumnNumber] >= priorOffset) failed. Values are 1 and 229.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:239998), row 16. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 1685 and 237.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:239998), row 16. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 1685 and 237.
    Msg 8944, Level 16, State 28, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:240046), row 17. Test (!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_B))) failed. Values are 53 and 129.
    Msg 8944, Level 16, State 28, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:240046), row 17. Test (!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_B))) failed. Values are 53 and 129.
    Msg 8944, Level 16, State 12, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:240174), row 23. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 13568 and 241.
    Msg 8944, Level 16, State 12, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:240174), row 23. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 13568 and 241.
    Msg 8944, Level 16, State 28, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:240515), row 2. Test (!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_B))) failed. Values are 15 and 129.
    Msg 8944, Level 16, State 28, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:240515), row 2. Test (!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_B))) failed. Values are 15 and 129.
    Msg 8944, Level 16, State 16, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:240862), row 20. Test (VarColOffsets + (int)(sizeof (class VarColOffset) * nVarCols) <= (nextRec - pRec)) failed. Values are 28338 and 260.
    Msg 8944, Level 16, State 16, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:240862), row 20. Test (VarColOffsets + (int)(sizeof (class VarColOffset) * nVarCols) <= (nextRec - pRec)) failed. Values are 28338 and 260.
    Msg 8944, Level 16, State 12, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:240878), row 17. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 27648 and 243.
    Msg 8944, Level 16, State 12, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:240878), row 17. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 27648 and 243.
    Msg 8944, Level 16, State 28, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:241246), row 16. Test (!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_B))) failed. Values are 1 and 129.
    Msg 8944, Level 16, State 28, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:241246), row 16. Test (!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_B))) failed. Values are 1 and 129.
    Msg 8944, Level 16, State 17, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:249326), row 16. Test (columnOffsets->offTbl [varColumnNumber] <= (nextRec - pRec)) failed. Values are 9984 and 221.
    Msg 8944, Level 16, State 17, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:249326), row 16. Test (columnOffsets->offTbl [varColumnNumber] <= (nextRec - pRec)) failed. Values are 9984 and 221.
    Msg 8944, Level 16, State 12, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:249710), row 17. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 16385 and 247.
    Msg 8944, Level 16, State 12, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:249710), row 17. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 16385 and 247.
    Msg 8944, Level 16, State 28, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:249822), row 17. Test (!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_B))) failed. Values are 255 and 129.
    Msg 8944, Level 16, State 28, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:249822), row 17. Test (!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_B))) failed. Values are 255 and 129.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:250158), row 18. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 1717 and 247.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:250158), row 18. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 1717 and 247.
    Msg 8944, Level 16, State 17, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:250782), row 16. Test (columnOffsets->offTbl [varColumnNumber] <= (nextRec - pRec)) failed. Values are 12490 and 240.
    Msg 8944, Level 16, State 17, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:250782), row 16. Test (columnOffsets->offTbl [varColumnNumber] <= (nextRec - pRec)) failed. Values are 12490 and 240.
    Msg 8944, Level 16, State 12, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:271230), row 15. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 12288 and 270.
    Msg 8944, Level 16, State 12, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:271230), row 15. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 12288 and 270.
    Msg 8944, Level 16, State 15, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:271537), row 5. Test (nVarCols && (hdr->r_tagA & VARIABLE_COLUMNS)) failed. Values are 0 and 32.
    Msg 8944, Level 16, State 15, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:271537), row 5. Test (nVarCols && (hdr->r_tagA & VARIABLE_COLUMNS)) failed. Values are 0 and 32.
    Msg 8944, Level 16, State 16, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:272126), row 15. Test (VarColOffsets + (int)(sizeof (class VarColOffset) * nVarCols) <= (nextRec - pRec)) failed. Values are 34450 and 285.
    Msg 8944, Level 16, State 16, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:272126), row 15. Test (VarColOffsets + (int)(sizeof (class VarColOffset) * nVarCols) <= (nextRec - pRec)) failed. Values are 34450 and 285.
    Msg 8944, Level 16, State 12, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:272942), row 22. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 3072 and 242.
    Msg 8944, Level 16, State 12, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:272942), row 22. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 3072 and 242.
    Msg 8944, Level 16, State 12, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:273006), row 18. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 12288 and 218.
    Msg 8944, Level 16, State 12, Line 2
    Table error: Object ID 191339746, index ID 1, partition ID 294014618304512, alloc unit ID 294014618304512 (type In-row data), page (1:273006), row 18. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 12288 and 218.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 191339746, index ID 6, partition ID 1701389501857792, alloc unit ID 1701389501857792 (type In-row data): Page (1:334286) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 16, Line 2
    Table error: Object ID 191339746, index ID 6, partition ID 1701389501857792, alloc unit ID 1701389501857792 (type In-row data), page (1:334286), row 177. Test (VarColOffsets + (int)(sizeof (class VarColOffset) * nVarCols) <= (nextRec - pRec)) failed. Values are 24682 and 23.
    Msg 8944, Level 16, State 16, Line 2
    Table error: Object ID 191339746, index ID 6, partition ID 1701389501857792, alloc unit ID 1701389501857792 (type In-row data), page (1:334286), row 177. Test (VarColOffsets + (int)(sizeof (class VarColOffset) * nVarCols) <= (nextRec - pRec)) failed. Values are 24682 and 23.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 191339746, index ID 7, partition ID 1982864478568448, alloc unit ID 1982864478568448 (type In-row data): Page (1:82414) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 12, Line 2
    Table error: Object ID 191339746, index ID 7, partition ID 1982864478568448, alloc unit ID 1982864478568448 (type In-row data), page (1:82414), row 174. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 256 and 23.
    Msg 8944, Level 16, State 12, Line 2
    Table error: Object ID 191339746, index ID 7, partition ID 1982864478568448, alloc unit ID 1982864478568448 (type In-row data), page (1:82414), row 174. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 256 and 23.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 191339746, index ID 7, partition ID 1982864478568448, alloc unit ID 1982864478568448 (type In-row data): Page (1:83166) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 18, Line 2
    Table error: Object ID 191339746, index ID 7, partition ID 1982864478568448, alloc unit ID 1982864478568448 (type In-row data), page (1:83166), row 218. Test (columnOffsets->offTbl [varColumnNumber] >= priorOffset) failed. Values are 0 and 16.
    Msg 8944, Level 16, State 18, Line 2
    Table error: Object ID 191339746, index ID 7, partition ID 1982864478568448, alloc unit ID 1982864478568448 (type In-row data), page (1:83166), row 218. Test (columnOffsets->offTbl [varColumnNumber] >= priorOffset) failed. Values are 0 and 16.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 191339746, index ID 8, partition ID 2264339455279104, alloc unit ID 2264339455279104 (type In-row data): Page (1:187518) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 17, Line 2
    Table error: Object ID 191339746, index ID 8, partition ID 2264339455279104, alloc unit ID 2264339455279104 (type In-row data), page (1:187518), row 228. Test (columnOffsets->offTbl [varColumnNumber] <= (nextRec - pRec)) failed. Values are 143 and 22.
    Msg 8944, Level 16, State 17, Line 2
    Table error: Object ID 191339746, index ID 8, partition ID 2264339455279104, alloc unit ID 2264339455279104 (type In-row data), page (1:187518), row 228. Test (columnOffsets->offTbl [varColumnNumber] <= (nextRec - pRec)) failed. Values are 143 and 22.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 191339746, index ID 8, partition ID 2264339455279104, alloc unit ID 2264339455279104 (type In-row data): Page (1:187534) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 12, Line 2
    Table error: Object ID 191339746, index ID 8, partition ID 2264339455279104, alloc unit ID 2264339455279104 (type In-row data), page (1:187534), row 275. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 12336 and 22.
    Msg 8944, Level 16, State 12, Line 2
    Table error: Object ID 191339746, index ID 8, partition ID 2264339455279104, alloc unit ID 2264339455279104 (type In-row data), page (1:187534), row 275. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 12336 and 22.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 191339746, index ID 8, partition ID 2264339455279104, alloc unit ID 2264339455279104 (type In-row data): Page (1:187582) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 12, Line 2
    Table error: Object ID 191339746, index ID 8, partition ID 2264339455279104, alloc unit ID 2264339455279104 (type In-row data), page (1:187582), row 182. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 14640 and 22.
    Msg 8944, Level 16, State 12, Line 2
    Table error: Object ID 191339746, index ID 8, partition ID 2264339455279104, alloc unit ID 2264339455279104 (type In-row data), page (1:187582), row 182. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 14640 and 22.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 191339746, index ID 8, partition ID 2264339455279104, alloc unit ID 2264339455279104 (type In-row data): Page (1:187710) could not be processed.  See other errors for details.
    Msg 8941, Level 16, State 55, Line 2
    Table error: Object ID 191339746, index ID 8, partition ID 2264339455279104, alloc unit ID 2264339455279104 (type In-row data), page (1:187710). Test (dbccAuditRecSucceeded == TRUE) failed. Slot 182, offset 0x1004 is invalid.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 191339746, index ID 8, partition ID 2264339455279104, alloc unit ID 2264339455279104 (type In-row data): Page (1:209118) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 12, Line 2
    Table error: Object ID 191339746, index ID 8, partition ID 2264339455279104, alloc unit ID 2264339455279104 (type In-row data), page (1:209118), row 126. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 12848 and 40.
    Msg 8944, Level 16, State 12, Line 2
    Table error: Object ID 191339746, index ID 8, partition ID 2264339455279104, alloc unit ID 2264339455279104 (type In-row data), page (1:209118), row 126. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 12848 and 40.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 191339746, index ID 8, partition ID 2264339455279104, alloc unit ID 2264339455279104 (type In-row data): Page (1:209294) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 18, Line 2
    Table error: Object ID 191339746, index ID 8, partition ID 2264339455279104, alloc unit ID 2264339455279104 (type In-row data), page (1:209294), row 100. Test (columnOffsets->offTbl [varColumnNumber] >= priorOffset) failed. Values are 0 and 5.
    Msg 8944, Level 16, State 18, Line 2
    Table error: Object ID 191339746, index ID 8, partition ID 2264339455279104, alloc unit ID 2264339455279104 (type In-row data), page (1:209294), row 100. Test (columnOffsets->offTbl [varColumnNumber] >= priorOffset) failed. Values are 0 and 5.
    There are 1393056 rows in 48652 pages for object "ED".
    CHECKDB found 0 allocation errors and 83 consistency errors in table 'ED' (object ID 191339746).
    DBCC results for 'ARC'.
    Msg 2508, Level 16, State 3, Line 2
    The In-row data RSVD page count for object "ARC", index ID 0, partition ID 12630080815104, alloc unit ID 12630080815104 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
    There are 1277 rows in 14 pages for object "ARC".
    CHECKDB found 0 allocation errors and 1 consistency errors in table 'ARC' (object ID 192719739).
    DBCC results for 'Advantage.X_050210_09300130'.
    There are 3925 rows in 16 pages for object "Advantage.X_050210_09300130".
    DBCC results for 'Advantage.X_051117_09540426_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051117_09540426_AR".
    DBCC results for 'Advantage.X_AR_041118_16295435'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_041118_16295435".
    DBCC results for 'billAddDetail'.
    Msg 2508, Level 16, State 3, Line 2
    The In-row data RSVD page count for object "billAddDetail", index ID 0, partition ID 12948323827712, alloc unit ID 12948323827712 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
    There are 6126 rows in 97 pages for object "billAddDetail".
    CHECKDB found 0 allocation errors and 1 consistency errors in table 'billAddDetail' (object ID 197575742).
    DBCC results for 'Advantage.X_AR_041026_13424593'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_041026_13424593".
    DBCC results for 'Advantage.X_050613_11365851_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050613_11365851_AR".
    DBCC results for 'Advantage.X_031212_11392324'.
    There are 3105 rows in 12 pages for object "Advantage.X_031212_11392324".
    DBCC results for 'Advantage.X_050323_10204492_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050323_10204492_AR".
    DBCC results for 'Advantage.X_060206_10053495_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060206_10053495_AR".
    DBCC results for 'CLA'.
    Msg 2508, Level 16, State 3, Line 2
    The In-row data RSVD page count for object "CLA", index ID 0, partition ID 13678660550656, alloc unit ID 13678660550656 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
    There are 2889 rows in 75 pages for object "CLA".
    CHECKDB found 0 allocation errors and 1 consistency errors in table 'CLA' (object ID 208719796).
    DBCC results for 'billBatchList'.
    There are 238 rows in 2 pages for object "billBatchList".
    DBCC results for 'Advantage.X_041118_16295435'.
    There are 320 rows in 2 pages for object "Advantage.X_041118_16295435".
    DBCC results for 'billARDetail'.
    Msg 2508, Level 16, State 3, Line 2
    The In-row data RSVD page count for object "billARDetail", index ID 0, partition ID 13996903563264, alloc unit ID 13996903563264 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
    There are 28245 rows in 454 pages for object "billARDetail".
    CHECKDB found 0 allocation errors and 1 consistency errors in table 'billARDetail' (object ID 213575799).
    DBCC results for 'dtproperties'.
    There are 0 rows in 0 pages for object "dtproperties".
    DBCC results for 'exChecks'.
    There are 0 rows in 0 pages for object "exChecks".
    DBCC results for 'FormW2Data'.
    There are 0 rows in 0 pages for object "FormW2Data".
    DBCC results for 'Advantage.X_031212_11422932'.
    There are 3105 rows in 12 pages for object "Advantage.X_031212_11422932".
    DBCC results for 'Advantage.X_070412_13035403_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070412_13035403_AR".
    DBCC results for 'Advantage.X_060206_10053495'.
    There are 5 rows in 1 pages for object "Advantage.X_060206_10053495".
    DBCC results for 'EMTKGroups'.
    There are 0 rows in 0 pages for object "EMTKGroups".
    DBCC results for 'BIED'.
    Msg 2508, Level 16, State 3, Line 2
    The In-row data RSVD page count for object "BIED", index ID 0, partition ID 14864604856320, alloc unit ID 14864604856320 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
    Msg 8951, Level 16, State 1, Line 2
    Table error: table 'BIED' (ID 226815870). Data row does not have a matching index row in the index 'edBankCodeIDX' (ID 4). Possible missing or invalid keys for the index row matching:
    Msg 8955, Level 16, State 1, Line 2
    Data row (1:15025:26) identified by (HEAP RID = (1:15025:26)) with index values 'edBankCode = NULL and HEAP RID = (1:15025:26)'.
    Msg 8951, Level 16, State 1, Line 2
    Table error: table 'BIED' (ID 226815870). Data row does not have a matching index row in the index 'edTaxCodeIDX' (ID 6). Possible missing or invalid keys for the index row matching:
    Msg 8955, Level 16, State 1, Line 2
    Data row (1:76704:23) identified by (HEAP RID = (1:76704:23)) with index values 'edTaxCode = NULL and HEAP RID = (1:76704:23)'.
    Msg 8951, Level 16, State 1, Line 2
    Table error: table 'BIED' (ID 226815870). Data row does not have a matching index row in the index 'edTaxCodeIDX' (ID 6). Possible missing or invalid keys for the index row matching:
    Msg 8955, Level 16, State 1, Line 2
    Data row (1:112256:1) identified by (HEAP RID = (1:112256:1)) with index values 'edTaxCode = NULL and HEAP RID = (1:112256:1)'.
    Msg 8951, Level 16, State 1, Line 2
    Table error: table 'BIED' (ID 226815870). Data row does not have a matching index row in the index 'edTransTypeedSubTypeIDX' (ID 10). Possible missing or invalid keys for the index row matching:
    Msg 8955, Level 16, State 1, Line 2
    Data row (1:2161:2) identified by (HEAP RID = (1:2161:2)) with index values 'edTransType = 'JE' and edSubType = NULL and HEAP RID = (1:2161:2)'.
    Msg 8951, Level 16, State 1, Line 2
    Table error: table 'BIED' (ID 226815870). Data row does not have a matching index row in the index 'edTransTypeedSubTypeIDX' (ID 10). Possible missing or invalid keys for the index row matching:
    Msg 8955, Level 16, State 1, Line 2
    Data row (1:99976:26) identified by (HEAP RID = (1:99976:26)) with index values 'edTransType = 'JE' and edSubType = NULL and HEAP RID = (1:99976:26)'.
    There are 6773 rows in 263 pages for object "BIED".
    CHECKDB found 0 allocation errors and 6 consistency errors in table 'BIED' (object ID 226815870).
    DBCC results for 'Advantage.X_051117_14504926_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051117_14504926_AR".
    DBCC results for 'Advantage.X_AR_041118_16370790'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_041118_16370790".
    DBCC results for 'Advantage.X_061116_16325682_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_061116_16325682_AR".
    DBCC results for 'Advantage.X_AR_041026_13440096'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_041026_13440096".
    DBCC results for 'Advantage.X_070618_15195158'.
    There are 0 rows in 0 pages for object "Advantage.X_070618_15195158".
    DBCC results for 'Advantage.X_031212_11434669'.
    There are 3105 rows in 12 pages for object "Advantage.X_031212_11434669".
    DBCC results for 'Advantage.X_060207_08544452'.
    There are 1818 rows in 8 pages for object "Advantage.X_060207_08544452".
    DBCC results for 'Advantage.X_070215_11301101_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070215_11301101_AR".
    DBCC results for 'Advantage.X_041118_16370790'.
    There are 1175 rows in 5 pages for object "Advantage.X_041118_16370790".
    DBCC results for 'billBTDDetail'.
    There are 812 rows in 14 pages for object "billBTDDetail".
    DBCC results for 'unDetail'.
    There are 0 rows in 0 pages for object "unDetail".
    DBCC results for 'Advantage.X_041026_13453223_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_041026_13453223_AR".
    DBCC results for 'Advantage.X_060713_14585676_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060713_14585676_AR".
    DBCC results for 'Advantage.X_050614_14182635_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050614_14182635_AR".
    DBCC results for 'Advantage.X_031212_11453095'.
    There are 3105 rows in 12 pages for object "Advantage.X_031212_11453095".
    DBCC results for 'Advantage.X_060410_09005725_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060410_09005725_AR".
    DBCC results for 'Advantage.X_050323_11115761_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050323_11115761_AR".
    DBCC results for 'Advantage.X_050214_09124259'.
    There are 4261 rows in 17 pages for object "Advantage.X_050214_09124259".
    DBCC results for 'Advantage.X_051118_10344299_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051118_10344299_AR".
    DBCC results for 'Advantage.X_041118_16451555_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_041118_16451555_AR".
    DBCC results for 'billConDetail'.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 261575970, index ID 0, partition ID 17142642769920, alloc unit ID 17142642769920 (type In-row data): Page (1:123312) could not be processed.  See other errors for details.
    There are 9307 rows in 295 pages for object "billConDetail".
    CHECKDB found 0 allocation errors and 1 consistency errors in table 'billConDetail' (object ID 261575970).
    DBCC results for 'Advantage.X_061117_10043953_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_061117_10043953_AR".
    DBCC results for 'unMaster'.
    There are 0 rows in 0 pages for object "unMaster".
    DBCC results for 'Advantage.X_031212_12253139'.
    There are 3105 rows in 12 pages for object "Advantage.X_031212_12253139".
    DBCC results for 'Advantage.X_060410_09005725'.
    There are 5 rows in 1 pages for object "Advantage.X_060410_09005725".
    DBCC results for 'Advantage.X_050324_08115537_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050324_08115537_AR".
    DBCC results for 'CFGPYStateID'.
    There are 0 rows in 0 pages for object "CFGPYStateID".
    DBCC results for 'Advantage.X_060207_16193008_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060207_16193008_AR".
    DBCC results for 'CLInitiation'.
    There are 0 rows in 0 pages for object "CLInitiation".
    DBCC results for 'Advantage.X_070215_11515983_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070215_11515983_AR".
    DBCC results for 'Advantage.X_041118_16451555'.
    There are 1175 rows in 5 pages for object "Advantage.X_041118_16451555".
    DBCC results for 'Advantage.X_041026_13440096'.
    There are 0 rows in 0 pages for object "Advantage.X_041026_13440096".
    DBCC results for 'jeDetail'.
    There are 342 rows in 8 pages for object "jeDetail".
    DBCC results for 'LD'.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 287340088, index ID 0, partition ID 18831120007168, alloc unit ID 18831120007168 (type In-row data): Page (1:28206) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 0, partition ID 18831120007168, alloc unit ID 18831120007168 (type In-row data), page (1:28206), row 24. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 3259 and 254.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 0, partition ID 18831120007168, alloc unit ID 18831120007168 (type In-row data), page (1:28206), row 24. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 3259 and 254.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 287340088, index ID 0, partition ID 18831120007168, alloc unit ID 18831120007168 (type In-row data): Page (1:28510) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 16, Line 2
    Table error: Object ID 287340088, index ID 0, partition ID 18831120007168, alloc unit ID 18831120007168 (type In-row data), page (1:28510), row 23. Test (VarColOffsets + (int)(sizeof (class VarColOffset) * nVarCols) <= (nextRec - pRec)) failed. Values are 61738 and 241.
    Msg 8944, Level 16, State 16, Line 2
    Table error: Object ID 287340088, index ID 0, partition ID 18831120007168, alloc unit ID 18831120007168 (type In-row data), page (1:28510), row 23. Test (VarColOffsets + (int)(sizeof (class VarColOffset) * nVarCols) <= (nextRec - pRec)) failed. Values are 61738 and 241.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 287340088, index ID 0, partition ID 18831120007168, alloc unit ID 18831120007168 (type In-row data): Page (1:50158) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 16, Line 2
    Table error: Object ID 287340088, index ID 0, partition ID 18831120007168, alloc unit ID 18831120007168 (type In-row data), page (1:50158), row 18. Test (VarColOffsets + (int)(sizeof (class VarColOffset) * nVarCols) <= (nextRec - pRec)) failed. Values are 1067 and 227.
    Msg 8944, Level 16, State 16, Line 2
    Table error: Object ID 287340088, index ID 0, partition ID 18831120007168, alloc unit ID 18831120007168 (type In-row data), page (1:50158), row 18. Test (VarColOffsets + (int)(sizeof (class VarColOffset) * nVarCols) <= (nextRec - pRec)) failed. Values are 1067 and 227.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 287340088, index ID 0, partition ID 18831120007168, alloc unit ID 18831120007168 (type In-row data): Page (1:114736) could not be processed.  See other errors for details.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 287340088, index ID 0, partition ID 18831120007168, alloc unit ID 18831120007168 (type In-row data): Page (1:154638) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 0, partition ID 18831120007168, alloc unit ID 18831120007168 (type In-row data), page (1:154638), row 19. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 1716 and 249.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 0, partition ID 18831120007168, alloc unit ID 18831120007168 (type In-row data), page (1:154638), row 19. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 1716 and 249.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 287340088, index ID 0, partition ID 18831120007168, alloc unit ID 18831120007168 (type In-row data): Page (1:154766) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 0, partition ID 18831120007168, alloc unit ID 18831120007168 (type In-row data), page (1:154766), row 15. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 1716 and 229.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 0, partition ID 18831120007168, alloc unit ID 18831120007168 (type In-row data), page (1:154766), row 15. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 1716 and 229.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 287340088, index ID 0, partition ID 18831120007168, alloc unit ID 18831120007168 (type In-row data): Page (1:155582) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 17, Line 2
    Table error: Object ID 287340088, index ID 0, partition ID 18831120007168, alloc unit ID 18831120007168 (type In-row data), page (1:155582), row 19. Test (columnOffsets->offTbl [varColumnNumber] <= (nextRec - pRec)) failed. Values are 4843 and 259.
    Msg 8944, Level 16, State 17, Line 2
    Table error: Object ID 287340088, index ID 0, partition ID 18831120007168, alloc unit ID 18831120007168 (type In-row data), page (1:155582), row 19. Test (columnOffsets->offTbl [varColumnNumber] <= (nextRec - pRec)) failed. Values are 4843 and 259.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 287340088, index ID 0, partition ID 18831120007168, alloc unit ID 18831120007168 (type In-row data): Page (1:187838) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 15, Line 2
    Table error: Object ID 287340088, index ID 0, partition ID 18831120007168, alloc unit ID 18831120007168 (type In-row data), page (1:187838), row 29. Test (nVarCols && (hdr->r_tagA & VARIABLE_COLUMNS)) failed. Values are 0 and 32.
    Msg 8944, Level 16, State 15, Line 2
    Table error: Object ID 287340088, index ID 0, partition ID 18831120007168, alloc unit ID 18831120007168 (type In-row data), page (1:187838), row 29. Test (nVarCols && (hdr->r_tagA & VARIABLE_COLUMNS)) failed. Values are 0 and 32.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 287340088, index ID 2, partition ID 581781073428480, alloc unit ID 581781073428480 (type In-row data): Page (1:240558) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 16, Line 2
    Table error: Object ID 287340088, index ID 2, partition ID 581781073428480, alloc unit ID 581781073428480 (type In-row data), page (1:240558), row 235. Test (VarColOffsets + (int)(sizeof (class VarColOffset) * nVarCols) <= (nextRec - pRec)) failed. Values are 26 and 17.
    Msg 8944, Level 16, State 16, Line 2
    Table error: Object ID 287340088, index ID 2, partition ID 581781073428480, alloc unit ID 581781073428480 (type In-row data), page (1:240558), row 235. Test (VarColOffsets + (int)(sizeof (class VarColOffset) * nVarCols) <= (nextRec - pRec)) failed. Values are 26 and 17.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 287340088, index ID 2, partition ID 581781073428480, alloc unit ID 581781073428480 (type In-row data): Page (1:240622) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 2, partition ID 581781073428480, alloc unit ID 581781073428480 (type In-row data), page (1:240622), row 235. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 1586 and 17.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 2, partition ID 581781073428480, alloc unit ID 581781073428480 (type In-row data), page (1:240622), row 235. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 1586 and 17.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 287340088, index ID 3, partition ID 863256050139136, alloc unit ID 863256050139136 (type In-row data): Page (1:280766) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 3, partition ID 863256050139136, alloc unit ID 863256050139136 (type In-row data), page (1:280766), row 222. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 81 and 18.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 3, partition ID 863256050139136, alloc unit ID 863256050139136 (type In-row data), page (1:280766), row 222. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 81 and 18.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 287340088, index ID 3, partition ID 863256050139136, alloc unit ID 863256050139136 (type In-row data): Page (1:281278) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 28, Line 2
    Table error: Object ID 287340088, index ID 3, partition ID 863256050139136, alloc unit ID 863256050139136 (type In-row data), page (1:281278), row 223. Test (!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_B))) failed. Values are 5 and 129.
    Msg 8944, Level 16, State 28, Line 2
    Table error: Object ID 287340088, index ID 3, partition ID 863256050139136, alloc unit ID 863256050139136 (type In-row data), page (1:281278), row 223. Test (!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_B))) failed. Values are 5 and 129.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 287340088, index ID 3, partition ID 863256050139136, alloc unit ID 863256050139136 (type In-row data): Page (1:281406) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 3, partition ID 863256050139136, alloc unit ID 863256050139136 (type In-row data), page (1:281406), row 250. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 21 and 18.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 3, partition ID 863256050139136, alloc unit ID 863256050139136 (type In-row data), page (1:281406), row 250. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 21 and 18.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 287340088, index ID 3, partition ID 863256050139136, alloc unit ID 863256050139136 (type In-row data): Page (1:281470) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 28, Line 2
    Table error: Object ID 287340088, index ID 3, partition ID 863256050139136, alloc unit ID 863256050139136 (type In-row data), page (1:281470), row 223. Test (!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_B))) failed. Values are 5 and 129.
    Msg 8944, Level 16, State 28, Line 2
    Table error: Object ID 287340088, index ID 3, partition ID 863256050139136, alloc unit ID 863256050139136 (type In-row data), page (1:281470), row 223. Test (!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_B))) failed. Values are 5 and 129.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 287340088, index ID 3, partition ID 863256050139136, alloc unit ID 863256050139136 (type In-row data): Page (1:281518) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 3, partition ID 863256050139136, alloc unit ID 863256050139136 (type In-row data), page (1:281518), row 222. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 3679 and 18.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 3, partition ID 863256050139136, alloc unit ID 863256050139136 (type In-row data), page (1:281518), row 222. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 3679 and 18.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 287340088, index ID 3, partition ID 863256050139136, alloc unit ID 863256050139136 (type In-row data): Page (1:281582) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 3, partition ID 863256050139136, alloc unit ID 863256050139136 (type In-row data), page (1:281582), row 279. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 21 and 18.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 3, partition ID 863256050139136, alloc unit ID 863256050139136 (type In-row data), page (1:281582), row 279. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 21 and 18.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 287340088, index ID 3, partition ID 863256050139136, alloc unit ID 863256050139136 (type In-row data): Page (1:282030) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 3, partition ID 863256050139136, alloc unit ID 863256050139136 (type In-row data), page (1:282030), row 222. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 1169 and 18.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 3, partition ID 863256050139136, alloc unit ID 863256050139136 (type In-row data), page (1:282030), row 222. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 1169 and 18.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 287340088, index ID 3, partition ID 863256050139136, alloc unit ID 863256050139136 (type In-row data): Page (1:282398) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 3, partition ID 863256050139136, alloc unit ID 863256050139136 (type In-row data), page (1:282398), row 222. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 22 and 18.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 3, partition ID 863256050139136, alloc unit ID 863256050139136 (type In-row data), page (1:282398), row 222. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 22 and 18.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 287340088, index ID 5, partition ID 1426206003560448, alloc unit ID 1426206003560448 (type In-row data): Page (1:302734) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 5, partition ID 1426206003560448, alloc unit ID 1426206003560448 (type In-row data), page (1:302734), row 121. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 43 and 33.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 5, partition ID 1426206003560448, alloc unit ID 1426206003560448 (type In-row data), page (1:302734), row 121. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 43 and 33.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 287340088, index ID 5, partition ID 1426206003560448, alloc unit ID 1426206003560448 (type In-row data): Page (1:302926) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 5, partition ID 1426206003560448, alloc unit ID 1426206003560448 (type In-row data), page (1:302926), row 121. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 1617 and 33.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 5, partition ID 1426206003560448, alloc unit ID 1426206003560448 (type In-row data), page (1:302926), row 121. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 1617 and 33.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 287340088, index ID 5, partition ID 1426206003560448, alloc unit ID 1426206003560448 (type In-row data): Page (1:302990) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 5, partition ID 1426206003560448, alloc unit ID 1426206003560448 (type In-row data), page (1:302990), row 152. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 57 and 33.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 5, partition ID 1426206003560448, alloc unit ID 1426206003560448 (type In-row data), page (1:302990), row 152. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 57 and 33.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 287340088, index ID 5, partition ID 1426206003560448, alloc unit ID 1426206003560448 (type In-row data): Page (1:303118) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 15, Line 2
    Table error: Object ID 287340088, index ID 5, partition ID 1426206003560448, alloc unit ID 1426206003560448 (type In-row data), page (1:303118), row 121. Test (nVarCols && (hdr->r_tagA & VARIABLE_COLUMNS)) failed. Values are 0 and 32.
    Msg 8944, Level 16, State 15, Line 2
    Table error: Object ID 287340088, index ID 5, partition ID 1426206003560448, alloc unit ID 1426206003560448 (type In-row data), page (1:303118), row 121. Test (nVarCols && (hdr->r_tagA & VARIABLE_COLUMNS)) failed. Values are 0 and 32.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 287340088, index ID 5, partition ID 1426206003560448, alloc unit ID 1426206003560448 (type In-row data): Page (1:303438) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 5, partition ID 1426206003560448, alloc unit ID 1426206003560448 (type In-row data), page (1:303438), row 152. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 1585 and 33.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 5, partition ID 1426206003560448, alloc unit ID 1426206003560448 (type In-row data), page (1:303438), row 152. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 1585 and 33.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 287340088, index ID 5, partition ID 1426206003560448, alloc unit ID 1426206003560448 (type In-row data): Page (1:303502) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 5, partition ID 1426206003560448, alloc unit ID 1426206003560448 (type In-row data), page (1:303502), row 121. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 2095 and 33.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 5, partition ID 1426206003560448, alloc unit ID 1426206003560448 (type In-row data), page (1:303502), row 121. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 2095 and 33.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 287340088, index ID 5, partition ID 1426206003560448, alloc unit ID 1426206003560448 (type In-row data): Page (1:303614) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 5, partition ID 1426206003560448, alloc unit ID 1426206003560448 (type In-row data), page (1:303614), row 121. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 1048 and 33.

     
  • Wednesday, November 04, 2009 2:55 PMxchangepatewon Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 5, partition ID 1426206003560448, alloc unit ID 1426206003560448 (type In-row data), page (1:303614), row 121. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 1048 and 33.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 287340088, index ID 5, partition ID 1426206003560448, alloc unit ID 1426206003560448 (type In-row data): Page (1:303742) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 5, partition ID 1426206003560448, alloc unit ID 1426206003560448 (type In-row data), page (1:303742), row 121. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 1042 and 33.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 5, partition ID 1426206003560448, alloc unit ID 1426206003560448 (type In-row data), page (1:303742), row 121. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 1042 and 33.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 287340088, index ID 5, partition ID 1426206003560448, alloc unit ID 1426206003560448 (type In-row data): Page (1:304318) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 5, partition ID 1426206003560448, alloc unit ID 1426206003560448 (type In-row data), page (1:304318), row 152. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 1617 and 33.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 5, partition ID 1426206003560448, alloc unit ID 1426206003560448 (type In-row data), page (1:304318), row 152. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 1617 and 33.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 287340088, index ID 5, partition ID 1426206003560448, alloc unit ID 1426206003560448 (type In-row data): Page (1:304366) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 5, partition ID 1426206003560448, alloc unit ID 1426206003560448 (type In-row data), page (1:304366), row 121. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 3256 and 33.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 287340088, index ID 5, partition ID 1426206003560448, alloc unit ID 1426206003560448 (type In-row data), page (1:304366), row 121. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 3256 and 33.
    There are 1012353 rows in 34448 pages for object "LD".
    CHECKDB found 0 allocation errors and 82 consistency errors in table 'LD' (object ID 287340088).
    DBCC results for 'Advantage.X_050214_14460446_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050214_14460446_AR".
    DBCC results for 'Advantage.X_051118_11434153_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051118_11434153_AR".
    DBCC results for 'Advantage.X_041119_13454716_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_041119_13454716_AR".
    DBCC results for 'Advantage.X_061117_11213149_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_061117_11213149_AR".
    DBCC results for 'Advantage.X_AR_041026_13464417'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_041026_13464417".
    DBCC results for 'Advantage.X_050324_08545121_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050324_08545121_AR".
    DBCC results for 'Advantage.X_070215_12033260_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070215_12033260_AR".
    DBCC results for 'Advantage.X_041119_13454716'.
    There are 3 rows in 1 pages for object "Advantage.X_041119_13454716".
    DBCC results for 'Advantage.X_050914_17180330_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050914_17180330_AR".
    DBCC results for 'Advantage.X_041026_13464417'.
    There are 1173 rows in 5 pages for object "Advantage.X_041026_13464417".
    DBCC results for 'Advantage.X_050615_11574034_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050615_11574034_AR".
    DBCC results for 'Advantage.X_070619_09442353'.
    There are 6133 rows in 24 pages for object "Advantage.X_070619_09442353".
    DBCC results for 'Advantage.X_070417_14141478_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070417_14141478_AR".
    DBCC results for 'Advantage.X_060208_12002373_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060208_12002373_AR".
    DBCC results for 'EMInitiation'.
    There are 0 rows in 0 pages for object "EMInitiation".
    DBCC results for 'Advantage.X_050215_09194432_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050215_09194432_AR".
    DBCC results for 'BILD'.
    Msg 2508, Level 16, State 3, Line 2
    The In-row data RSVD page count for object "BILD", index ID 0, partition ID 21156083269632, alloc unit ID 21156083269632 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 322816212, index ID 4, partition ID 1147055990112256, alloc unit ID 1147055990112256 (type In-row data): Page (1:209246) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 322816212, index ID 4, partition ID 1147055990112256, alloc unit ID 1147055990112256 (type In-row data), page (1:209246), row 326. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 139 and 21.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 322816212, index ID 4, partition ID 1147055990112256, alloc unit ID 1147055990112256 (type In-row data), page (1:209246), row 326. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 139 and 21.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 322816212, index ID 6, partition ID 1710005943533568, alloc unit ID 1710005943533568 (type In-row data): Page (1:209310) could not be processed.  See other errors for details.
    Msg 8941, Level 16, State 55, Line 2
    Table error: Object ID 322816212, index ID 6, partition ID 1710005943533568, alloc unit ID 1710005943533568 (type In-row data), page (1:209310). Test (dbccAuditRecSucceeded == TRUE) failed. Slot 387, offset 0x1407 is invalid.
    There are 3251 rows in 132 pages for object "BILD".
    CHECKDB found 0 allocation errors and 6 consistency errors in table 'BILD' (object ID 322816212).
    DBCC results for 'Advantage.X_051121_11404751_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051121_11404751_AR".
    DBCC results for 'Advantage.X_041123_14475432_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_041123_14475432_AR".
    DBCC results for 'billExpDetail'.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 325576198, index ID 0, partition ID 21336961712128, alloc unit ID 21336961712128 (type In-row data): Page (1:18563) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 12, Line 2
    Table error: Object ID 325576198, index ID 0, partition ID 21336961712128, alloc unit ID 21336961712128 (type In-row data), page (1:18563), row 31. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 13104 and 258.
    Msg 8944, Level 16, State 12, Line 2
    Table error: Object ID 325576198, index ID 0, partition ID 21336961712128, alloc unit ID 21336961712128 (type In-row data), page (1:18563), row 31. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 13104 and 258.
    There are 142712 rows in 4376 pages for object "billExpDetail".
    CHECKDB found 0 allocation errors and 3 consistency errors in table 'billExpDetail' (object ID 325576198).
    DBCC results for 'Advantage.X_061120_13515613_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_061120_13515613_AR".
    DBCC results for 'Advantage.X_AR_041026_13535293'.
    There are 6823 rows in 34 pages for object "Advantage.X_AR_041026_13535293".
    DBCC results for 'Advantage.X_050324_08580221_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050324_08580221_AR".
    DBCC results for 'Advantage.X_051121_11404751'.
    There are 2 rows in 1 pages for object "Advantage.X_051121_11404751".
    DBCC results for 'Advantage.X_061120_13525009_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_061120_13525009_AR".
    DBCC results for 'VEA'.
    Msg 2508, Level 16, State 3, Line 2
    The In-row data RSVD page count for object "VEA", index ID 0, partition ID 22522906017792, alloc unit ID 22522906017792 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
    There are 2888 rows in 48 pages for object "VEA".
    CHECKDB found 0 allocation errors and 1 consistency errors in table 'VEA' (object ID 343672272).
    DBCC results for 'Advantage.X_041026_13535293'.
    There are 8963 rows in 35 pages for object "Advantage.X_041026_13535293".
    DBCC results for 'Advantage.X_050616_09532054_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050616_09532054_AR".
    DBCC results for 'Advantage.X_070619_10082454'.
    There are 741 rows in 3 pages for object "Advantage.X_070619_10082454".
    DBCC results for 'Advantage.X_070418_15505612_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070418_15505612_AR".
    DBCC results for 'PR'.
    Msg 2508, Level 16, State 3, Line 2
    The In-row data RSVD page count for object "PR", index ID 0, partition ID 23025438949376, alloc unit ID 23025438949376 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
    There are 20275 rows in 1393 pages for object "PR".
    CHECKDB found 0 allocation errors and 1 consistency errors in table 'PR' (object ID 351340316).
    DBCC results for 'Advantage.X_060209_09172056_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060209_09172056_AR".
    DBCC results for 'Advantage.X_050215_10032265_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050215_10032265_AR".
    DBCC results for 'Advantage.X_070215_12223279_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070215_12223279_AR".
    DBCC results for 'Advantage.X_051122_09263026_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051122_09263026_AR".
    DBCC results for 'Advantage.X_041124_08553556_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_041124_08553556_AR".
    DBCC results for 'VEF'.
    There are 38641 rows in 241 pages for object "VEF".
    DBCC results for 'Advantage.X_AR_041026_14014911'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_041026_14014911".
    DBCC results for 'GLGroup'.
    There are 13 rows in 1 pages for object "GLGroup".
    DBCC results for 'Advantage.X_070619_10130676'.
    There are 741 rows in 3 pages for object "Advantage.X_070619_10130676".
    DBCC results for 'Advantage.X_060411_10594876_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060411_10594876_AR".
    DBCC results for 'Advantage.X_050324_08591220_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050324_08591220_AR".
    DBCC results for 'Advantage.X_051122_09263026'.
    There are 6 rows in 1 pages for object "Advantage.X_051122_09263026".
    DBCC results for 'Advantage.X_061120_14132250_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_061120_14132250_AR".
    DBCC results for 'Advantage.X_050916_15260951_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050916_15260951_AR".
    DBCC results for 'VO'.
    There are 98425 rows in 1329 pages for object "VO".
    DBCC results for 'Advantage.X_050616_10244920_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050616_10244920_AR".
    DBCC results for 'GLGroupDetail'.
    There are 10 rows in 1 pages for object "GLGroupDetail".
    DBCC results for 'Advantage.X_070619_10201534'.
    There are 0 rows in 0 pages for object "Advantage.X_070619_10201534".
    DBCC results for 'Advantage.X_040120_11343205'.
    There are 3309 rows in 13 pages for object "Advantage.X_040120_11343205".
    DBCC results for 'Advantage.X_070418_16363197_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070418_16363197_AR".
    DBCC results for 'Advantage.X_050215_13585453_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050215_13585453_AR".
    DBCC results for 'CFGBillTaxes'.
    There are 1 rows in 1 pages for object "CFGBillTaxes".
    DBCC results for 'billFeeDetail'.
    There are 90400 rows in 2228 pages for object "billFeeDetail".
    DBCC results for 'Advantage.X_051122_15421980_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051122_15421980_AR".
    DBCC results for 'Advantage.X_041124_11123511'.
    There are 9557 rows in 37 pages for object "Advantage.X_041124_11123511".
    DBCC results for 'XChargeWk'.
    There are 0 rows in 0 pages for object "XChargeWk".
    DBCC results for 'Advantage.X_AR_041026_14171320'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_041026_14171320".
    DBCC results for 'Advantage.X_050616_10244920'.
    There are 34 rows in 1 pages for object "Advantage.X_050616_10244920".
    DBCC results for 'GLTable'.
    There are 1 rows in 1 pages for object "GLTable".
    DBCC results for 'Advantage.X_070619_10215508'.
    There are 0 rows in 0 pages for object "Advantage.X_070619_10215508".
    DBCC results for 'Advantage.X_060412_09315181_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060412_09315181_AR".
    DBCC results for 'Advantage.X_050324_08595435_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050324_08595435_AR".
    DBCC results for 'PRInitiation'.
    There are 0 rows in 1 pages for object "PRInitiation".
    DBCC results for 'Advantage.X_060214_11052811'.
    There are 5634 rows in 22 pages for object "Advantage.X_060214_11052811".
    DBCC results for 'Advantage.X_070215_14100240_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070215_14100240_AR".
    DBCC results for 'Advantage.X_061121_16175775_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_061121_16175775_AR".
    DBCC results for 'Advantage.X_050920_10082525_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050920_10082525_AR".
    DBCC results for 'Advantage.X_060718_16121272'.
    There are 439 rows in 3 pages for object "Advantage.X_060718_16121272".
    DBCC results for 'Advantage.X_050616_10224834_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050616_10224834_AR".
    DBCC results for 'inControl'.
    There are 2 rows in 2 pages for object "inControl".
    DBCC results for 'CFGPYWHMethod'.
    There are 4 rows in 1 pages for object "CFGPYWHMethod".
    DBCC results for 'Advantage.X_060214_11413812'.
    There are 5634 rows in 22 pages for object "Advantage.X_060214_11413812".
    DBCC results for 'Advantage.X_050216_08050732_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050216_08050732_AR".
    DBCC results for 'BT'.
    There are 18389 rows in 839 pages for object "BT".
    DBCC results for 'Advantage.X_051123_09064862_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051123_09064862_AR".
    DBCC results for 'Advantage.X_041130_09142751_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_041130_09142751_AR".
    DBCC results for 'BillingTemplates'.
    There are 242 rows in 6 pages for object "BillingTemplates".
    DBCC results for 'Advantage.X_AR_041026_14211255'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_041026_14211255".
    DBCC results for 'Advantage.X_060718_16174718'.
    There are 439 rows in 2 pages for object "Advantage.X_060718_16174718".
    DBCC results for 'Advantage.X_070619_10312152'.
    There are 540 rows in 3 pages for object "Advantage.X_070619_10312152".
    DBCC results for 'Advantage.X_050324_10133307_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050324_10133307_AR".
    DBCC results for 'CFGPYWHType'.
    There are 8 rows in 1 pages for object "CFGPYWHType".
    DBCC results for 'Advantage.X_060214_11435873'.
    There are 4848 rows in 19 pages for object "Advantage.X_060214_11435873".
    DBCC results for 'Advantage.X_070215_14325804_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070215_14325804_AR".
    DBCC results for 'billINMaster'.
    There are 206484 rows in 1911 pages for object "billINMaster".
    DBCC results for 'Advantage.X_050920_10335358_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050920_10335358_AR".
    DBCC results for 'Advantage.X_041026_14211590_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_041026_14211590_AR".
    DBCC results for 'Advantage.X_060718_16241934'.
    There are 5873 rows in 23 pages for object "Advantage.X_060718_16241934".
    DBCC results for 'Advantage.X_050616_13473070_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050616_13473070_AR".
    DBCC results for 'Advantage.X_060417_11282804'.
    There are 6183 rows in 25 pages for object "Advantage.X_060417_11282804".
    DBCC results for 'CL'.
    Msg 2508, Level 16, State 3, Line 2
    The In-row data RSVD page count for object "CL", index ID 0, partition ID 29179552792576, alloc unit ID 29179552792576 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
    There are 2480 rows in 23 pages for object "CL".
    CHECKDB found 0 allocation errors and 1 consistency errors in table 'CL' (object ID 445244641).
    DBCC results for 'CFGReportOptions'.
    There are 171 rows in 3 pages for object "CFGReportOptions".
    DBCC results for 'Advantage.X_051123_09345123_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051123_09345123_AR".
    DBCC results for 'Advantage.X_041130_09165007_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_041130_09165007_AR".
    DBCC results for 'billIntDetail'.
    There are 0 rows in 0 pages for object "billIntDetail".
    DBCC results for 'Advantage.X_061122_09442661_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_061122_09442661_AR".
    DBCC results for 'Advantage.X_060718_16302292'.
    There are 439 rows in 3 pages for object "Advantage.X_060718_16302292".
    DBCC results for 'Advantage.X_070619_10462155_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070619_10462155_AR".
    DBCC results for 'Advantage.X_060417_11314637'.
    There are 12832 rows in 50 pages for object "Advantage.X_060417_11314637".
    DBCC results for 'Advantage.X_050328_09174457_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050328_09174457_AR".
    DBCC results for 'Advantage.X_070426_14012624_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070426_14012624_AR".
    DBCC results for 'Advantage.X_050216_13422959_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050216_13422959_AR".
    DBCC results for 'Advantage.X_070215_14455618_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070215_14455618_AR".
    DBCC results for 'billInvMaster'.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 469576711, index ID 0, partition ID 30774179332096, alloc unit ID 30774179332096 (type In-row data): Page (1:123214) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 18, Line 2
    Table error: Object ID 469576711, index ID 0, partition ID 30774179332096, alloc unit ID 30774179332096 (type In-row data), page (1:123214), row 20. Test (columnOffsets->offTbl [varColumnNumber] >= priorOffset) failed. Values are 18 and 77.
    Msg 8944, Level 16, State 18, Line 2
    Table error: Object ID 469576711, index ID 0, partition ID 30774179332096, alloc unit ID 30774179332096 (type In-row data), page (1:123214), row 20. Test (columnOffsets->offTbl [varColumnNumber] >= priorOffset) failed. Values are 18 and 77.
    Msg 8944, Level 16, State 18, Line 2
    Table error: Object ID 469576711, index ID 0, partition ID 30774179332096, alloc unit ID 30774179332096 (type In-row data), page (1:123214), row 20. Test (columnOffsets->offTbl [varColumnNumber] >= priorOffset) failed. Values are 18 and 77.
    Msg 8964, Level 16, State 1, Line 2
    Table error: Object ID 469576711, index ID 0, partition ID 30774179332096, alloc unit ID 71806893240549376 (type LOB data). The off-row data node at page (1:35493), slot 10, text ID 195938877440 is not referenced.
    There are 88553 rows in 3090 pages for object "billInvMaster".
    CHECKDB found 0 allocation errors and 5 consistency errors in table 'billInvMaster' (object ID 469576711).
    DBCC results for 'Advantage.X_050920_10405352_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050920_10405352_AR".
    DBCC results for 'Advantage.X_060718_16380386'.
    There are 439 rows in 2 pages for object "Advantage.X_060718_16380386".
    DBCC results for 'Advantage.X_050616_13481755_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050616_13481755_AR".
    DBCC results for 'EB'.
    There are 53 rows in 1 pages for object "EB".
    DBCC results for 'CFGRGFormulas'.
    There are 22 rows in 1 pages for object "CFGRGFormulas".
    DBCC results for 'PBLReportOptions'.
    Msg 2508, Level 16, State 3, Line 2
    The In-row data RSVD page count for object "PBLReportOptions", index ID 0, partition ID 31414076833792, alloc unit ID 31414076833792 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
    There are 2921 rows in 38 pages for object "PBLReportOptions".
    CHECKDB found 0 allocation errors and 1 consistency errors in table 'PBLReportOptions' (object ID 479340772).
    DBCC results for 'Advantage.X_050216_14160503_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050216_14160503_AR".
    DBCC results for 'Advantage.X_051123_10475204_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051123_10475204_AR".
    DBCC results for 'Advantage.X_041130_09373009_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_041130_09373009_AR".
    DBCC results for 'Advantage.X_061122_09474714_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_061122_09474714_AR".
    DBCC results for 'Advantage.X_041026_14250767_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_041026_14250767_AR".
     
  • Wednesday, November 04, 2009 2:55 PMxchangepatewon Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote

    DBCC results for 'Advantage.X_060718_16442589'.
    There are 439 rows in 2 pages for object "Advantage.X_060718_16442589".
    DBCC results for 'inMaster'.
    There are 21 rows in 4 pages for object "inMaster".
    DBCC results for 'Advantage.X_060417_13183214'.
    There are 6211 rows in 24 pages for object "Advantage.X_060417_13183214".
    DBCC results for 'Advantage.X_050328_13341996_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050328_13341996_AR".
    DBCC results for 'CFGRGMethods'.
    There are 9 rows in 1 pages for object "CFGRGMethods".
    DBCC results for 'Advantage.X_060214_16460026_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060214_16460026_AR".
    DBCC results for 'Advantage.X_050617_10272653_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050617_10272653_AR".
    DBCC results for 'Advantage.X_060417_13253800'.
    There are 6211 rows in 24 pages for object "Advantage.X_060417_13253800".
    DBCC results for 'EM'.
    There are 580 rows in 34 pages for object "EM".
    DBCC results for 'CFGTimeAnalysis'.
    There are 9 rows in 1 pages for object "CFGTimeAnalysis".
    DBCC results for 'SE'.
    There are 6 rows in 1 pages for object "SE".
    DBCC results for 'Advantage.X_050216_15545053_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050216_15545053_AR".
    DBCC results for 'CFGCASortSelect'.
    There are 3 rows in 1 pages for object "CFGCASortSelect".
    DBCC results for 'Advantage.X_070215_16042460_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070215_16042460_AR".
    DBCC results for 'Advantage.X_051123_12364665_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051123_12364665_AR".
    DBCC results for 'Advantage.X_061122_12063358_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_061122_12063358_AR".
    DBCC results for 'Advantage.X_050920_16343460_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050920_16343460_AR".
    DBCC results for 'Advantage.X_060718_16494551'.
    There are 0 rows in 0 pages for object "Advantage.X_060718_16494551".
    DBCC results for 'jeControl'.
    There are 3 rows in 1 pages for object "jeControl".
    DBCC results for 'Advantage.X_070619_15411478_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070619_15411478_AR".
    DBCC results for 'Advantage.X_050328_14514632_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050328_14514632_AR".
    DBCC results for 'CFGTimeAnalysisHeadings'.
    There are 9 rows in 1 pages for object "CFGTimeAnalysisHeadings".
    DBCC results for 'Advantage.X_060215_09155682_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060215_09155682_AR".
    DBCC results for 'Advantage.X_AR_041026_14262898'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_041026_14262898".
    DBCC results for 'Advantage.X_050617_11010045_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050617_11010045_AR".
    DBCC results for 'Advantage.X_040224_09054160'.
    There are 3432 rows in 14 pages for object "Advantage.X_040224_09054160".
    DBCC results for 'Advantage.X_060215_10224590_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060215_10224590_AR".
    DBCC results for 'Advantage.X_050217_09583280_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050217_09583280_AR".
    DBCC results for 'Advantage.X_070215_16071029_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070215_16071029_AR".
    DBCC results for 'Advantage.X_051128_08040059_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051128_08040059_AR".
    DBCC results for 'Advantage.X_041206_10103176_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_041206_10103176_AR".
    DBCC results for 'Advantage.X_061127_09510147_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_061127_09510147_AR".
    DBCC results for 'Advantage.X_050921_08535166_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050921_08535166_AR".
    DBCC results for 'Advantage.X_041026_14260221_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_041026_14260221_AR".
    DBCC results for 'Advantage.X_060718_17204109'.
    There are 5873 rows in 23 pages for object "Advantage.X_060718_17204109".
    DBCC results for 'Advantage.X_070620_09262869'.
    There are 644 rows in 3 pages for object "Advantage.X_070620_09262869".
    DBCC results for 'Advantage.X_050329_10593211_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050329_10593211_AR".
    DBCC results for 'Advantage.X_060215_10224590'.
    There are 3333 rows in 13 pages for object "Advantage.X_060215_10224590".
    DBCC results for 'Advantage.X_041026_14293602_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_041026_14293602_AR".
    DBCC results for 'Advantage.X_060718_17234209'.
    There are 439 rows in 2 pages for object "Advantage.X_060718_17234209".
    DBCC results for 'Advantage.X_050617_11083497_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050617_11083497_AR".
    DBCC results for 'Advantage.X_070620_09294449'.
    There are 644 rows in 3 pages for object "Advantage.X_070620_09294449".
    DBCC results for 'Advantage.X_060424_10454467_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060424_10454467_AR".
    DBCC results for 'CFGTKEmployeeGroup'.
    There are 14 rows in 2 pages for object "CFGTKEmployeeGroup".
    DBCC results for 'Advantage.X_060215_11125341_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060215_11125341_AR".
    DBCC results for 'Advantage.X_050217_11222086_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050217_11222086_AR".
    DBCC results for 'Advantage.X_070215_16080028_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070215_16080028_AR".
    DBCC results for 'Advantage.X_051128_09151565_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051128_09151565_AR".
    DBCC results for 'Advantage.X_061127_16301678_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_061127_16301678_AR".
    DBCC results for 'Advantage.X_050921_08531284_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050921_08531284_AR".
    DBCC results for 'Advantage.X_070508_11003109_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070508_11003109_AR".
    DBCC results for 'Advantage.X_050217_11222086'.
    There are 708 rows in 3 pages for object "Advantage.X_050217_11222086".
    DBCC results for 'Advantage.X_041026_14314960_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_041026_14314960_AR".
    DBCC results for 'Advantage.X_060725_08371285_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060725_08371285_AR".
    DBCC results for 'Advantage.X_050620_11502883_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050620_11502883_AR".
    DBCC results for 'Advantage.X_050329_12572059_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050329_12572059_AR".
    DBCC results for 'Advantage.X_070216_09365532_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070216_09365532_AR".
    DBCC results for 'Advantage.X_051128_16372438_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051128_16372438_AR".
    DBCC results for 'Advantage.X_041209_08132476_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_041209_08132476_AR".
    DBCC results for 'billInvSums'.
    There are 115898 rows in 1229 pages for object "billInvSums".
    DBCC results for 'Advantage.X_050921_09280888_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050921_09280888_AR".
    DBCC results for 'EMP'.
    There are 405 rows in 12 pages for object "EMP".
    DBCC results for 'Advantage.X_050330_09344404_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050330_09344404_AR".
    DBCC results for 'Advantage.X_070510_09223620_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070510_09223620_AR".
    DBCC results for 'Advantage.X_050217_11244790_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050217_11244790_AR".
    DBCC results for 'CFGCLSortSelect'.
    There are 3 rows in 1 pages for object "CFGCLSortSelect".
    DBCC results for 'Advantage.X_041216_16352100'.
    There are 17 rows in 1 pages for object "Advantage.X_041216_16352100".
    DBCC results for 'billLabDetail'.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 629577281, index ID 0, partition ID 41259976687616, alloc unit ID 41259976687616 (type In-row data): Page (1:61198) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 629577281, index ID 0, partition ID 41259976687616, alloc unit ID 41259976687616 (type In-row data), page (1:61198), row 17. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 1667 and 329.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 629577281, index ID 0, partition ID 41259976687616, alloc unit ID 41259976687616 (type In-row data), page (1:61198), row 17. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 1667 and 329.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 629577281, index ID 0, partition ID 41259976687616, alloc unit ID 41259976687616 (type In-row data): Page (1:91454) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 17, Line 2
    Table error: Object ID 629577281, index ID 0, partition ID 41259976687616, alloc unit ID 41259976687616 (type In-row data), page (1:91454), row 8. Test (columnOffsets->offTbl [varColumnNumber] <= (nextRec - pRec)) failed. Values are 12491 and 329.
    Msg 8944, Level 16, State 17, Line 2
    Table error: Object ID 629577281, index ID 0, partition ID 41259976687616, alloc unit ID 41259976687616 (type In-row data), page (1:91454), row 8. Test (columnOffsets->offTbl [varColumnNumber] <= (nextRec - pRec)) failed. Values are 12491 and 329.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 629577281, index ID 0, partition ID 41259976687616, alloc unit ID 41259976687616 (type In-row data): Page (1:91518) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 15, Line 2
    Table error: Object ID 629577281, index ID 0, partition ID 41259976687616, alloc unit ID 41259976687616 (type In-row data), page (1:91518), row 5. Test (nVarCols && (hdr->r_tagA & VARIABLE_COLUMNS)) failed. Values are 0 and 32.
    Msg 8944, Level 16, State 15, Line 2
    Table error: Object ID 629577281, index ID 0, partition ID 41259976687616, alloc unit ID 41259976687616 (type In-row data), page (1:91518), row 5. Test (nVarCols && (hdr->r_tagA & VARIABLE_COLUMNS)) failed. Values are 0 and 32.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 629577281, index ID 0, partition ID 41259976687616, alloc unit ID 41259976687616 (type In-row data): Page (1:207918) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 15, Line 2
    Table error: Object ID 629577281, index ID 0, partition ID 41259976687616, alloc unit ID 41259976687616 (type In-row data), page (1:207918), row 17. Test (nVarCols && (hdr->r_tagA & VARIABLE_COLUMNS)) failed. Values are 0 and 32.
    Msg 8944, Level 16, State 15, Line 2
    Table error: Object ID 629577281, index ID 0, partition ID 41259976687616, alloc unit ID 41259976687616 (type In-row data), page (1:207918), row 17. Test (nVarCols && (hdr->r_tagA & VARIABLE_COLUMNS)) failed. Values are 0 and 32.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 629577281, index ID 2, partition ID 604209930108928, alloc unit ID 604209930108928 (type In-row data): Page (1:218270) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 28, Line 2
    Table error: Object ID 629577281, index ID 2, partition ID 604209930108928, alloc unit ID 604209930108928 (type In-row data), page (1:218270), row 100. Test (!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_B))) failed. Values are 1 and 129.
    Msg 8944, Level 16, State 29, Line 2
    Table error: Object ID 629577281, index ID 2, partition ID 604209930108928, alloc unit ID 604209930108928 (type In-row data), page (1:218270), row 100. Test (offsetNull >= BASEOFFSET) failed. Values are 1 and 4.
    Msg 8944, Level 16, State 28, Line 2
    Table error: Object ID 629577281, index ID 2, partition ID 604209930108928, alloc unit ID 604209930108928 (type In-row data), page (1:218270), row 100. Test (!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_B))) failed. Values are 1 and 129.
    Msg 8944, Level 16, State 29, Line 2
    Table error: Object ID 629577281, index ID 2, partition ID 604209930108928, alloc unit ID 604209930108928 (type In-row data), page (1:218270), row 100. Test (offsetNull >= BASEOFFSET) failed. Values are 1 and 4.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 629577281, index ID 2, partition ID 604209930108928, alloc unit ID 604209930108928 (type In-row data): Page (1:218334) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 28, Line 2
    Table error: Object ID 629577281, index ID 2, partition ID 604209930108928, alloc unit ID 604209930108928 (type In-row data), page (1:218334), row 100. Test (!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_B))) failed. Values are 1 and 129.
    Msg 8944, Level 16, State 29, Line 2
    Table error: Object ID 629577281, index ID 2, partition ID 604209930108928, alloc unit ID 604209930108928 (type In-row data), page (1:218334), row 100. Test (offsetNull >= BASEOFFSET) failed. Values are 1 and 4.
    Msg 8944, Level 16, State 28, Line 2
    Table error: Object ID 629577281, index ID 2, partition ID 604209930108928, alloc unit ID 604209930108928 (type In-row data), page (1:218334), row 100. Test (!(hdr->r_tagA & (VERSION_MASK | RECTAG_RESV_B))) failed. Values are 1 and 129.
    Msg 8944, Level 16, State 29, Line 2
    Table error: Object ID 629577281, index ID 2, partition ID 604209930108928, alloc unit ID 604209930108928 (type In-row data), page (1:218334), row 100. Test (offsetNull >= BASEOFFSET) failed. Values are 1 and 4.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 629577281, index ID 2, partition ID 604209930108928, alloc unit ID 604209930108928 (type In-row data): Page (1:218398) could not be processed.  See other errors for details.
    Msg 8944, Level 16, State 12, Line 2
    Table error: Object ID 629577281, index ID 2, partition ID 604209930108928, alloc unit ID 604209930108928 (type In-row data), page (1:218398), row 126. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 13623 and 40.
    Msg 8944, Level 16, State 12, Line 2
    Table error: Object ID 629577281, index ID 2, partition ID 604209930108928, alloc unit ID 604209930108928 (type In-row data), page (1:218398), row 126. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 13623 and 40.
    There are 445047 rows in 17246 pages for object "billLabDetail".
    CHECKDB found 0 allocation errors and 25 consistency errors in table 'billLabDetail' (object ID 629577281).
    DBCC results for 'Advantage.X_061128_14290525_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_061128_14290525_AR".
    DBCC results for 'Advantage.X_041026_14344969_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_041026_14344969_AR".
    DBCC results for 'Advantage.X_050620_13553837_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050620_13553837_AR".
    DBCC results for 'Advantage.X_040225_09045959'.
    There are 2634 rows in 11 pages for object "Advantage.X_040225_09045959".
    DBCC results for 'Advantage.X_060425_09291872_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060425_09291872_AR".
    DBCC results for 'Advantage.X_060215_17282490_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060215_17282490_AR".
    DBCC results for 'Advantage.X_050217_11350294_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050217_11350294_AR".
    DBCC results for 'Advantage.X_070216_09485270_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070216_09485270_AR".
    DBCC results for 'Advantage.X_050921_09325762_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050921_09325762_AR".
    DBCC results for 'Advantage.X_060725_09041081_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060725_09041081_AR".
    DBCC results for 'laControl'.
    There are 0 rows in 1 pages for object "laControl".
    DBCC results for 'Advantage.X_070626_08520428_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070626_08520428_AR".
    DBCC results for 'Advantage.X_040225_09071167'.
    There are 0 rows in 0 pages for object "Advantage.X_040225_09071167".
    DBCC results for 'Advantage.X_050330_10412244_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050330_10412244_AR".
    DBCC results for 'Advantage.X_070510_10015066_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070510_10015066_AR".
    DBCC results for 'Advantage.X_060215_17291103_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060215_17291103_AR".
    DBCC results for 'Advantage.X_051129_11172636_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051129_11172636_AR".
    DBCC results for 'Advantage.X_061129_10281178_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_061129_10281178_AR".
    DBCC results for 'Advantage.X_AR_041026_14410117'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_041026_14410117".
    DBCC results for 'Advantage.X_060725_09060463_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060725_09060463_AR".
    DBCC results for 'Advantage.X_060425_15392999_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060425_15392999_AR".
    DBCC results for 'Advantage.X_050217_13191884_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050217_13191884_AR".
    DBCC results for 'Advantage.X_070216_09542886_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070216_09542886_AR".
    DBCC results for 'Advantage.X_041221_16132700_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_041221_16132700_AR".
    DBCC results for 'Advantage.X_050921_10191403_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050921_10191403_AR".
    DBCC results for 'Advantage.X_070626_14475285_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070626_14475285_AR".
    DBCC results for 'Advantage.X_AR_040225_09302980'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_040225_09302980".
    DBCC results for 'Advantage.X_060425_15392999'.
    There are 4 rows in 1 pages for object "Advantage.X_060425_15392999".
    DBCC results for 'Advantage.X_070511_09054219_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070511_09054219_AR".
    DBCC results for 'Advantage.X_060216_09152008_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060216_09152008_AR".
    DBCC results for 'Advantage.X_051129_14164305_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051129_14164305_AR".
    DBCC results for 'Advantage.X_061130_11570223_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_061130_11570223_AR".
    DBCC results for 'Advantage.X_041026_14525093_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_041026_14525093_AR".
    DBCC results for 'Advantage.X_050621_15071120_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050621_15071120_AR".
    DBCC results for 'Advantage.X_060426_11395154_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060426_11395154_AR".
    DBCC results for 'Advantage.X_050217_14042193_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050217_14042193_AR".
    DBCC results for 'Advantage.X_041223_13462022_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_041223_13462022_AR".
    DBCC results for 'Advantage.X_050922_09445293_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050922_09445293_AR".
    DBCC results for 'Advantage.X_050622_14070301_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050622_14070301_AR".
    DBCC results for 'laDetail'.
    There are 0 rows in 1 pages for object "laDetail".
    DBCC results for 'Advantage.X_070627_10372418_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070627_10372418_AR".
    DBCC results for 'EMPA'.
    There are 18 rows in 1 pages for object "EMPA".
    DBCC results for 'Advantage.X_050330_16110454_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050330_16110454_AR".
    DBCC results for 'Advantage.X_070511_10432177'.
    There are 15209 rows in 59 pages for object "Advantage.X_070511_10432177".
    DBCC results for 'Advantage.X_051130_16470419_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051130_16470419_AR".
    DBCC results for 'Advantage.X_061204_12180469_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_061204_12180469_AR".
    DBCC results for 'Advantage.X_060727_10023304_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060727_10023304_AR".
    DBCC results for 'Advantage.X_040303_13273515'.
    There are 1077 rows in 5 pages for object "Advantage.X_040303_13273515".
    DBCC results for 'Advantage.X_060426_16511583_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060426_16511583_AR".
    DBCC results for 'SEUser'.
    There are 14 rows in 1 pages for object "SEUser".
    DBCC results for 'Advantage.X_060216_10424159_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060216_10424159_AR".
    DBCC results for 'Advantage.X_050217_14502581_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050217_14502581_AR".
    DBCC results for 'CFGDates'.
    There are 123 rows in 1 pages for object "CFGDates".
    DBCC results for 'Advantage.X_070216_13555897_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070216_13555897_AR".
    DBCC results for 'Advantage.X_041223_13513217_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_041223_13513217_AR".
    DBCC results for 'billLimDetail'.
    Msg 2508, Level 16, State 3, Line 2
    The In-row data RSVD page count for object "billLimDetail", index ID 0, partition ID 48600034836480, alloc unit ID 48600034836480 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
    There are 2638 rows in 42 pages for object "billLimDetail".
    CHECKDB found 0 allocation errors and 1 consistency errors in table 'billLimDetail' (object ID 741577680).
    DBCC results for 'EM_bak'.
    There are 0 rows in 0 pages for object "EM_bak".
    DBCC results for 'Advantage.X_050922_13360814_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050922_13360814_AR".
    DBCC results for 'Advantage.X_AR_041026_15160387'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_041026_15160387".
    DBCC results for 'Advantage.X_050623_14541924_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050623_14541924_AR".
    DBCC results for 'laMaster'.
    There are 0 rows in 1 pages for object "laMaster".
    DBCC results for 'Advantage.X_040303_13392729'.
    There are 2677 rows in 11 pages for object "Advantage.X_040303_13392729".
    DBCC results for 'Advantage.X_050331_09015599_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050331_09015599_AR".
    DBCC results for 'CFGVendorStatus'.
    There are 3 rows in 1 pages for object "CFGVendorStatus".
    DBCC results for 'Advantage.X_050217_14502581'.
    There are 8 rows in 1 pages for object "Advantage.X_050217_14502581".
    DBCC results for 'Advantage.X_051201_09554496_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051201_09554496_AR".
    DBCC results for 'billRetDetail'.
    There are 380 rows in 5 pages for object "billRetDetail".
    DBCC results for 'Advantage.X_021009_14471802'.
    There are 6273 rows in 25 pages for object "Advantage.X_021009_14471802".
    DBCC results for 'Advantage.X_060728_09121549_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060728_09121549_AR".
    DBCC results for 'Advantage.X_070627_11304230_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070627_11304230_AR".
    DBCC results for 'EMPAD'.
    There are 49 rows in 1 pages for object "EMPAD".
    DBCC results for 'CFGVESortSelect'.
    There are 3 rows in 1 pages for object "CFGVESortSelect".
    DBCC results for 'Advantage.X_060216_10504526_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060216_10504526_AR".
    DBCC results for 'Advantage.X_050217_15014753_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050217_15014753_AR".
    DBCC results for 'Advantage.X_021010_08422380'.
    There are 5779 rows in 23 pages for object "Advantage.X_021010_08422380".
    DBCC results for 'Advantage.X_050926_09500155_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050926_09500155_AR".
    DBCC results for 'Advantage.X_AR_041026_15271376'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_041026_15271376".
    DBCC results for 'Advantage.X_050624_09214912_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050624_09214912_AR".
    DBCC results for 'Advantage.X_050331_11012547_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050331_11012547_AR".
    DBCC results for 'Advantage.X_070514_09081027_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070514_09081027_AR".
    DBCC results for 'Advantage.X_051205_16282028'.
    There are 5105 rows in 20 pages for object "Advantage.X_051205_16282028".
    DBCC results for 'Advantage.X_050103_11591207_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050103_11591207_AR".
    DBCC results for 'billTaxDetail'.
    There are 175 rows in 3 pages for object "billTaxDetail".
    DBCC results for 'Advantage.X_070628_11143088_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070628_11143088_AR".
    DBCC results for 'Advantage.X_060502_15262351_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060502_15262351_AR".
    DBCC results for 'VE'.
    Msg 2508, Level 16, State 3, Line 2
    The In-row data RSVD page count for object "VE", index ID 0, partition ID 52385671544832, alloc unit ID 52385671544832 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
    There are 2855 rows in 58 pages for object "VE".
    CHECKDB found 0 allocation errors and 1 consistency errors in table 'VE' (object ID 799341912).
    DBCC results for 'Advantage.X_050218_08121564_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050218_08121564_AR".
    DBCC results for 'Advantage.X_051205_16303963'.
    There are 0 rows in 0 pages for object "Advantage.X_051205_16303963".
    DBCC results for 'Advantage.X_050107_08351877_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050107_08351877_AR".
    DBCC results for 'billUnitDetail'.
    There are 0 rows in 0 pages for object "billUnitDetail".
    DBCC results for 'Advantage.X_061211_15482141'.
    There are 6647 rows in 26 pages for object "Advantage.X_061211_15482141".
    DBCC results for 'Advantage.X_050928_15351098_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050928_15351098_AR".
    DBCC results for 'Advantage.X_041026_15573102_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_041026_15573102_AR".
    DBCC results for 'Advantage.X_050627_16075634_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050627_16075634_AR".
    DBCC results for 'Advantage.X_040406_11504026'.
    There are 7699 rows in 30 pages for object "Advantage.X_040406_11504026".
    DBCC results for 'EMPD'.
    There are 0 rows in 0 pages for object "EMPD".
    DBCC results for 'Advantage.X_050401_10354323_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050401_10354323_AR".
    DBCC results for 'Advantage.X_070514_11043741_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070514_11043741_AR".
    DBCC results for 'Advantage.X_060216_11222798_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060216_11222798_AR".
    DBCC results for 'CFGEKCategory'.
    There are 3 rows in 1 pages for object "CFGEKCategory".
    DBCC results for 'Advantage.X_070219_10112719_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070219_10112719_AR".
    DBCC results for 'Advantage.X_AR_041026_16434947'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_041026_16434947".
    DBCC results for 'Advantage.X_070629_16441503_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070629_16441503_AR".
    DBCC results for 'Advantage.X_040406_11553148'.
    There are 705 rows in 3 pages for object "Advantage.X_040406_11553148".
    DBCC results for 'Advantage.X_060508_10395594'.
    There are 4 rows in 1 pages for object "Advantage.X_060508_10395594".
    DBCC results for 'Advantage.X_050401_16443449_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050401_16443449_AR".
    DBCC results for 'Advantage.X_050218_08240771_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050218_08240771_AR".
    DBCC results for 'Advantage.X_051206_11263680_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051206_11263680_AR".
    DBCC results for 'Advantage.X_050111_08495119_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050111_08495119_AR".
    DBCC results for 'Advantage.X_050929_08493438_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050929_08493438_AR".
    DBCC results for 'Advantage.X_050627_17401113_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050627_17401113_AR".
    DBCC results for 'miControl'.
    There are 0 rows in 0 pages for object "miControl".
    DBCC results for 'Advantage.X_040406_14022370'.
    There are 0 rows in 0 pages for object "Advantage.X_040406_14022370".
    DBCC results for 'Advantage.X_060508_10395594_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060508_10395594_AR".
    DBCC results for 'Advantage.X_070514_11055012_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070514_11055012_AR".
    DBCC results for 'Advantage.X_070219_10385354_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070219_10385354_AR".
    DBCC results for 'Advantage.X_AR_041026_16481888'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_041026_16481888".
    DBCC results for 'Advantage.X_070702_08563544_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070702_08563544_AR".
    DBCC results for 'Advantage.X_050405_10505935_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050405_10505935_AR".
    DBCC results for 'exControl'.
    There are 0 rows in 0 pages for object "exControl".
    DBCC results for 'Advantage.X_060221_11311830'.
    There are 0 rows in 0 pages for object "Advantage.X_060221_11311830".
    DBCC results for 'Advantage.X_050218_15210433_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050218_15210433_AR".
    DBCC results for 'CFGEKEmployeeGroup'.
    There are 0 rows in 0 pages for object "CFGEKEmployeeGroup".
    DBCC results for 'Advantage.X_050111_08511823_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050111_08511823_AR".
    DBCC results for 'Advantage.X_AR_021023_10215904'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_021023_10215904".
    DBCC results for 'Advantage.X_050929_10083991_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050929_10083991_AR".
    DBCC results for 'Advantage.X_050628_10421302_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050628_10421302_AR".
    DBCC results for 'Advantage.X_070514_11085725_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070514_11085725_AR".
    DBCC results for 'CFGEmployeeStatus'.
    There are 3 rows in 1 pages for object "CFGEmployeeStatus".
    DBCC results for 'Advantage.X_070219_10414709_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070219_10414709_AR".
    DBCC results for 'Advantage.X_051207_09524969_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051207_09524969_AR".
    DBCC results for 'Advantage.X_021023_10215904'.
    There are 6316 rows in 25 pages for object "Advantage.X_021023_10215904".
    DBCC results for 'Advantage.X_041027_14584999_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_041027_14584999_AR".
    DBCC results for 'Advantage.X_060821_11123422_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060821_11123422_AR".
    DBCC results for 'Advantage.X_050221_09033372_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050221_09033372_AR".
    DBCC results for 'CFGEmployeeType'.
    There are 3 rows in 1 pages for object "CFGEmployeeType".
    DBCC results for 'Advantage.X_050112_08481685_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050112_08481685_AR".
    DBCC results for 'Advantage.X_AR_021023_10261954'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_021023_10261954".
    DBCC results for 'Advantage.X_050929_10104224_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050929_10104224_AR".
    DBCC results for 'miDetail'.
    There are 0 rows in 0 pages for object "miDetail".
    DBCC results for 'Advantage.X_060516_13524547_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060516_13524547_AR".
    DBCC results for 'LB'.
    There are 377 rows in 7 pages for object "LB".
    DBCC results for 'Advantage.X_050407_14341180'.
    There are 2323 rows in 10 pages for object "Advantage.X_050407_14341180".
    DBCC results for 'Advantage.X_070514_13400240_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070514_13400240_AR".
    DBCC results for 'CFGEMSortSelect'.
    There are 30 rows in 1 pages for object "CFGEMSortSelect".
    DBCC results for 'Advantage.X_070219_10522801'.
    There are 1003 rows in 4 pages for object "Advantage.X_070219_10522801".
    DBCC results for 'Advantage.X_051208_14402559_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051208_14402559_AR".
    DBCC results for 'Advantage.X_041027_15000527_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_041027_15000527_AR".
    DBCC results for 'Advantage.X_060830_15190895_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060830_15190895_AR".
    DBCC results for 'Advantage.X_050629_11210352_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050629_11210352_AR".
    DBCC results for 'miMaster'.
    There are 0 rows in 0 pages for object "miMaster".
    DBCC results for 'Advantage.X_050407_14344910_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050407_14344910_AR".
    DBCC results for 'Advantage.X_060223_11111413_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060223_11111413_AR".
    DBCC results for 'Advantage.X_051208_14402559'.
    There are 8 rows in 1 pages for object "Advantage.X_051208_14402559".
    DBCC results for 'Advantage.X_050117_11080040_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050117_11080040_AR".
    DBCC results for 'Advantage.X_AR_021023_10592856'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_021023_10592856".
    DBCC results for 'Advantage.X_050929_16364378_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050929_16364378_AR".
    DBCC results for 'Advantage.X_050705_11193168_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050705_11193168_AR".
    DBCC results for 'CR'.
    Msg 8928, Level 16, State 1, Line 2
    Object ID 942626401, index ID 2, partition ID 624725917237248, alloc unit ID 624725917237248 (type In-row data): Page (1:219342) could not be processed.  See other errors for details.
    Msg 8941, Level 16, State 55, Line 2
    Table error: Object ID 942626401, index ID 2, partition ID 624725917237248, alloc unit ID 624725917237248 (type In-row data), page (1:219342). Test (dbccAuditRecSucceeded == TRUE) failed. Slot 250, offset 0x1000 is invalid.
    There are 66439 rows in 715 pages for object "CR".
    CHECKDB found 0 allocation errors and 2 consistency errors in table 'CR' (object ID 942626401).
    DBCC results for 'Advantage.X_070515_09165149_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070515_09165149_AR".
    DBCC results for 'exDetail'.
    There are 0 rows in 0 pages for object "exDetail".
    DBCC results for 'Advantage.X_050221_13162940_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050221_13162940_AR".
    DBCC results for 'Advantage.X_AR_041027_16023168'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_041027_16023168".
    DBCC results for 'Advantage.X_050705_11193168'.
    There are 2 rows in 1 pages for object "Advantage.X_050705_11193168".
    DBCC results for 'OverheadAllocation'.
    There are 2607 rows in 39 pages for object "OverheadAllocation".
    DBCC results for 'Advantage.X_070706_14214694'.
    There are 6248 rows in 25 pages for object "Advantage.X_070706_14214694".
    DBCC results for 'Advantage.X_050407_15051293_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050407_15051293_AR".
    DBCC results for 'Advantage.X_060223_13135005_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060223_13135005_AR".
    DBCC results for 'Advantage.X_050118_14215202_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050118_14215202_AR".
    DBCC results for 'Advantage.X_050930_09185442_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050930_09185442_AR".
    DBCC results for 'Advantage.X_050708_09575017_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050708_09575017_AR".
    DBCC results for 'PBLReportColumns'.
    There are 169 rows in 5 pages for object "PBLReportColumns".
    DBCC results for 'Advantage.X_070515_10094973_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070515_10094973_AR".
    DBCC results for 'Advantage.X_050221_14491584_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050221_14491584_AR".
    DBCC results for 'Advantage.X_070220_10205568_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070220_10205568_AR".
    DBCC results for 'Advantage.X_051213_17174515_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051213_17174515_AR".
    DBCC results for 'Advantage.X_050118_14215202'.
    There are 3 rows in 1 pages for object "Advantage.X_050118_14215202".
    DBCC results for 'Advantage.X_061212_10273479'.
    There are 6661 rows in 26 pages for object "Advantage.X_061212_10273479".
    DBCC results for 'Advantage.X_050930_09185442'.
    There are 15 rows in 1 pages for object "Advantage.X_050930_09185442".
    DBCC results for 'Advantage.X_AR_041027_16062578'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_041027_16062578".
    DBCC results for 'PBLReportFavorites'.
    There are 10 rows in 1 pages for object "PBLReportFavorites".
    DBCC results for 'Advantage.X_060517_09055931_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060517_09055931_AR".
    DBCC results for 'Advantage.X_050413_13153324_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050413_13153324_AR".
    DBCC results for 'crControl'.
    There are 1 rows in 1 pages for object "crControl".
    DBCC results for 'exMaster'.
    There are 0 rows in 0 pages for object "exMaster".
    DBCC results for 'Advantage.X_060223_13223597_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060223_13223597_AR".
    DBCC results for 'Advantage.X_050221_14491584'.
    There are 1311 rows in 6 pages for object "Advantage.X_050221_14491584".
    DBCC results for 'Advantage.X_050119_09532194_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050119_09532194_AR".
    DBCC results for 'Advantage.X_051003_09110438_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051003_09110438_AR".
    DBCC results for 'Advantage.X_050221_16433433_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050221_16433433_AR".
    DBCC results for 'Advantage.X_070220_10202269_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070220_10202269_AR".
    DBCC results for 'Advantage.X_051216_10475628_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051216_10475628_AR".
    DBCC results for 'Advantage.X_021029_14261082'.
    There are 229 rows in 1 pages for object "Advantage.X_021029_14261082".
    DBCC results for 'Advantage.X_051003_09110438'.
    There are 7 rows in 1 pages for object "Advantage.X_051003_09110438".
    DBCC results for 'Advantage.X_AR_041028_09455240'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_041028_09455240".
    DBCC results for 'Advantage.X_050712_16054374_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050712_16054374_AR".
    DBCC results for 'PBLReportWhere'.
    There are 28 rows in 1 pages for object "PBLReportWhere".
    DBCC results for 'Advantage.X_060517_11545171_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060517_11545171_AR".
    DBCC results for 'Advantage.X_050415_08154222_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050415_08154222_AR".
    DBCC results for 'Advantage.X_060223_13593871_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060223_13593871_AR".
    DBCC results for 'Advantage.X_050221_16433433'.
    There are 202 rows in 1 pages for object "Advantage.X_050221_16433433".
    DBCC results for 'Advantage.X_050120_14403324_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050120_14403324_AR".
    DBCC results for 'Advantage.X_021029_14284172'.
    There are 229 rows in 1 pages for object "Advantage.X_021029_14284172".
    DBCC results for 'Advantage.X_051004_11081827_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051004_11081827_AR".
    DBCC results for 'Advantage.X_060921_13191266_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060921_13191266_AR".
    DBCC results for 'PBLReportWhereDetail'.
    There are 58 rows in 3 pages for object "PBLReportWhereDetail".
    DBCC results for 'Advantage.X_070515_17023018_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070515_17023018_AR".
    DBCC results for 'CFGETInterface'.
    There are 1 rows in 1 pages for object "CFGETInterface".
    DBCC results for 'Advantage.X_051220_08533894_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051220_08533894_AR".
    DBCC results for 'Advantage.X_070104_08411446_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070104_08411446_AR".
    DBCC results for 'Advantage.X_051004_11081827'.
    There are 3 rows in 1 pages for object "Advantage.X_051004_11081827".
    DBCC results for 'Advantage.X_AR_041028_09591311'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_041028_09591311".
    DBCC results for 'Advantage.X_011129_09472014'.
    There are 0 rows in 0 pages for object "Advantage.X_011129_09472014".
    DBCC results for 'Advantage.X_050713_16310844_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050713_16310844_AR".
    DBCC results for 'Advantage.X_050222_09574702_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050222_09574702_AR".
    DBCC results for 'Advantage.X_050120_16233845'.
    There are 3987 rows in 16 pages for object "Advantage.X_050120_16233845".
    DBCC results for 'Advantage.X_051005_13221354_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051005_13221354_AR".
    DBCC results for 'Advantage.X_060921_13270671_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060921_13270671_AR".
    DBCC results for 'Advantage.X_050713_16442765_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050713_16442765_AR".
    DBCC results for 'plAccountSS'.
    There are 2 rows in 1 pages for object "plAccountSS".
    DBCC results for 'Advantage.X_060522_13291616_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060522_13291616_AR".
    DBCC results for 'Advantage.X_050418_14042513'.
    There are 1153 rows in 5 pages for object "Advantage.X_050418_14042513".
    DBCC results for 'Advantage.X_060223_14422863_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060223_14422863_AR".
    DBCC results for 'Advantage.X_050222_09574702'.
    There are 202 rows in 1 pages for object "Advantage.X_050222_09574702".
    DBCC results for 'Advantage.X_051220_10560599_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_051220_10560599_AR".
    DBCC results for 'Advantage.X_070109_10320103_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070109_10320103_AR".
    DBCC results for 'Advantage.X_AR_041028_10002218'.
    There are 0 rows in 0 pages for object "Advantage.X_AR_041028_10002218".
    DBCC results for 'plClientSS'.
    There are 106 rows in 1 pages for object "plClientSS".
    DBCC results for 'Advantage.X_060522_13460132_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_060522_13460132_AR".
    DBCC results for 'crMaster'.
    There are 13 rows in 2 pages for object "crMaster".
    DBCC results for 'Advantage.X_050222_10054879_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_050222_10054879_AR".
    DBCC results for 'Advantage.X_070221_08141886_AR'.
    There are 0 rows in 0 pages for object "Advantage.X_070221_08141886_AR".
    DBCC results for 'BTBG'.
    There are 0 rows in 1 pages for object "BTBG".
    Msg 2508, Level 16, State 3, Line 2
    The In-row data RSVD page count for object "PRF", index ID 0, partition ID 82519754735616, alloc unit ID 82519754735616 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 1259151531, index ID 0, partition ID 82519754735616, alloc unit ID 82519754735616 (type In-row data), page (1:176238), row 83. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 1568 and 48.
    CHECKDB found 0 allocation errors and 2 consistency errors in table 'PRF' (object ID 1259151531).
    Msg 2508, Level 16, State 3, Line 2
    The In-row data RSVD page count for object "RPTActivityList", index ID 0, partition ID 95377440702464, alloc unit ID 95377440702464 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
    CHECKDB found 0 allocation errors and 1 consistency errors in table 'RPTActivityList' (object ID 1455344249).
    Msg 8944, Level 16, State 12, Line 2
    Table error: Object ID 1629248859, index ID 0, partition ID 106774453223424, alloc unit ID 106774453223424 (type In-row data), page (1:18718), row 54. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 12336 and 89.
    Msg 8944, Level 16, State 17, Line 2
    Table error: Object ID 1629248859, index ID 0, partition ID 106774453223424, alloc unit ID 106774453223424 (type In-row data), page (1:19422), row 33. Test (columnOffsets->offTbl [varColumnNumber] <= (nextRec - pRec)) failed. Values are 18487 and 89.
    Msg 8944, Level 16, State 13, Line 2
    Table error: Object ID 1629248859, index ID 0, partition ID 106774453223424, alloc unit ID 106774453223424 (type In-row data), page (1:29646), row 21. Test (ColumnOffsets <= (nextRec - pRec)) failed. Values are 115 and 89.
    Msg 8944, Level 16, State 15, Line 2
    Table error: Object ID 1629248859, index ID 0, partition ID 106774453223424, alloc unit ID 106774453223424 (type In-row data), page (1:51678), row 62. Test (nVarCols && (hdr->r_tagA & VARIABLE_COLUMNS)) failed. Values are 0 and 32.
    CHECKDB found 0 allocation errors and 4 consistency errors in table 'tkDetail' (object ID 1629248859).
    Msg 2508, Level 16, State 3, Line 2
    The In-row data RSVD page count for object "RPTProjectList", index ID 0, partition ID 112928567066624, alloc unit ID 112928567066624 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
    CHECKDB found 0 allocation errors and 1 consistency errors in table 'RPTProjectList' (object ID 1723153184).
    CHECKDB found 0 allocation errors and 240 consistency errors in database 'Advantage'.

    How should i go about fixing all these consistency errors?

     
  • Wednesday, November 04, 2009 8:17 PMxchangepatewon Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    would running dbcc updateusage help at all? i see several references in the log where it tells me to run DBCC updateusage.

    if i run the dbcc updateusage does that mean it could fix all of these table errors in the log file as well?

    or will i need to run some other command or contact MS Support?

    the problem for me is that i didnt know this DB was having these issues so i dont even know if i have a good backup to resort to at the moment.



     
  • Thursday, November 05, 2009 10:29 AMTiborKMVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Proposed Answer
    Sign In to Vote
    0
    Sign In to Vote
    Running DBCC UPDATEUSAGE will fix the incorrect space usage stats (the errors from CHECKDB which refers to DBCC UPDATEUSAGE). You seem to have more problems than that, though (from a quick reading of your posted errorlog) so it is likely that you have to fall back to your backups and/or contact MS support.
    Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi