Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error Runnind DBCC CHECKDB('databasename') Expand / Collapse
Author
Message
Posted Wednesday, June 12, 2013 9:39 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, September 8, 2014 9:14 AM
Points: 163, Visits: 471
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

Post #1462702
Posted Wednesday, June 12, 2013 10:33 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 2:28 AM
Points: 43,008, Visits: 36,167
Run DBCC UPDATEUSAGE



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1462721
Posted Wednesday, June 12, 2013 10:47 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, September 8, 2014 9:14 AM
Points: 163, Visits: 471
do I need to run this script after hours to prevent getting in the way of users?
Post #1462731
Posted Wednesday, June 12, 2013 10:53 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 2:28 AM
Points: 43,008, Visits: 36,167
It probably would be a good idea.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1462737
Posted Thursday, June 13, 2013 12:14 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, September 8, 2014 9:14 AM
Points: 163, Visits: 471
The job ran successfully. Thank you.
Post #1463246
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse