I'm getting the following error when running dbcc on a database server containing three different databases. Two of the commands run fine execpt for this database. What is the best way to handle this? I read different suggestions and one of them is to restored from a backup file, would that be a good solution?
Executing query "USE [TestDB] ".: 50% complete End Progress Error: 2013-06-12 00:01:09.92 Code: 0xC002F210 Source: Check Database Integrity Task Execute SQL Task Description: Executing the query "DBCC CHECKDB(N'TestDB) WITH NO_INFOMSGS " failed with the following error: "The In-row data RSVD page count for object "table1", index ID 1, partition ID 306297224822784, alloc unit ID 306297224822784 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE. The In-row data RSVD page count for object "table2", index ID 1, partition ID 369221408063488, alloc unit ID 369221408063488 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE. CHECKDB found 0 allocation errors and 1 consistency errors in table 'table1' (object ID 378757448). CHECKDB found 0 allocation errors and 1 consistency errors in table 'table2' (object ID 1338904287). CHECKDB found 0 allocation errors and 2 consistency errors in database 'TestDB'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error Progress: 2013-06-12 00:01:09.94 Source: Check Database Integrity Task