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)
or should I use the additional switches. If I need the additional switches, what would the command be for correct syntax?
Run the updateusuage that is enough and re-run the DBCC CHECKDB & verify.. usually after migrate it requires to run the DBCC Updateusage
you can run the updateusuage on that particular Object then do re-run the checkdb and see
The following example specifies AdventureWorks2012 as the database name and suppresses all informational messages.
DBCC UPDATEUSAGE (AdventureWorks2012) WITH NO_INFOMSGS;
The following example reports updated page or row count information for the
Employee table in the AdventureWorks2012 database.
DBCC UPDATEUSAGE (AdventureWorks2012,"HumanResources.Employee");
The following example specifies IX_Employee_ManagerID as the index name.
DBCC UPDATEUSAGE (AdventureWorks2012, "HumanResources.Employee", IX_Employee_OrganizationLevel_OrganizationNode);
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.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?