none
DBCC checkdb error

    Question

  • Ran the DBCC checkdb on Database AFW05 and received the following error. The database was a sql 2000 version that was migrated over to SQL 2005 server.  

    CHECKDB found 0 allocation errors and 1 consistency errors in database 'AFW05'.

    DBCC results for 'BPWorksheetAccountXRef'.

    Msg 2508, Level 16, State 3, Line 2

    The In-row data RSVD page count for object "BPWorksheetAccountXRef", index ID 0, partition ID 17963418714112, alloc unit ID 17963418714112 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.

    There are 5296 rows in 17 pages for object "BPWorksheetAccountXRef".

    CHECKDB found 0 allocation errors and 1 consistency errors in table 'BPWorksheetAccountXRef' (object ID 274100017).

    Should I use

    DBCC udateusage (AFW05)

    go

    or should I use the additional switches. If I need the additional switches, what would the command be for correct syntax?

    JoppaPaul

    Thursday, August 30, 2012 7:16 PM

Answers

  • Run the updateusuage that is enough and re-run the DBCC CHECKDB & verify.. usually after migrate it requires to run the DBCC Updateusage

    or

    you can run the updateusuage on that particular Object then do re-run the checkdb and see

    http://msdn.microsoft.com/en-us/library/ms188414.aspx

    EX-

    B. Updating page or row counts or both for AdventureWorks, and suppressing informational messages

    The following example specifies AdventureWorks2012 as the database name and suppresses all informational messages.

    USE AdventureWorks2012;
    GO
    DBCC UPDATEUSAGE (AdventureWorks2012) WITH NO_INFOMSGS; 
    GO
    
    
    

    C. Updating page or row counts or both for the Employee table

    The following example reports updated page or row count information for the Employee table in the AdventureWorks2012 database.

    USE AdventureWorks2012;
    GO
    DBCC UPDATEUSAGE (AdventureWorks2012,"HumanResources.Employee");
    GO
    
    
    

    D. Updating page or row counts or both for a specific index in a table

    The following example specifies IX_Employee_ManagerID as the index name.

    USE AdventureWorks2012;
    GO
    DBCC UPDATEUSAGE (AdventureWorks2012, "HumanResources.Employee", IX_Employee_OrganizationLevel_OrganizationNode);
    GO
    
    
    


    Rama Udaya.K ramaudaya.blogspot.com ---------------------------------------- Please remember to mark the replies as answers if they help and un-mark them if they provide no help.



    Thursday, August 30, 2012 7:21 PM