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

DBCC CHECKDB FAILED Expand / Collapse
Author
Message
Posted Wednesday, January 23, 2013 4:14 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 6:48 AM
Points: 2,633, Visits: 3,977
Hi Experts,

Got below messages when ran checkdb

Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error: "Process ID 75 attempted to unlock a resource it does not own: PAGE: Retry the transaction, because this error may be caused by a timing condition. If the problem persists, contact the database administrator.
During undoing of a logged operation in database '', an error occurred at log record ID . Typically, the specific failure is logged previously as an error in the Windows Event Log service. Restore the database or file from a backup, or repair the database.
A database snapshot cannot be created because it failed to start.
The database snapshot for online checks could not be created. Either the reason is given in a previous error or one of the underlying volumes does not support sparse files or alternate streams. Attempting to get exclusive access to run checks offline.
The database could not be exclusively locked to perform the operation.
Post #1410465
Posted Wednesday, January 23, 2013 4:45 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 2:59 AM
Points: 168, Visits: 273
Hi ,

Please check the link below ... hope this helps

http://connect.microsoft.com/SQLServer/feedback/details/241265/attempted-to-unlock-a-resource-it-does-not-own



Cheer Satish
Post #1410479
Posted Wednesday, January 23, 2013 5:05 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 6:48 AM
Points: 2,633, Visits: 3,977
Thanks Satish for the reply.

I have already gone through that and wont help in this situation.

We have SQL Server 2005 SP4
Post #1410488
Posted Wednesday, January 23, 2013 5:40 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, October 13, 2014 6:42 AM
Points: 5,216, Visits: 5,111
The database couldn't be X-locked to perform the snap, something was happening with the database which prevented the first step of CheckDB to complete.

It needs to create a snapshot of the db to check for consistancy errors, if it cant do this it fails.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1410510
Posted Wednesday, January 23, 2013 5:52 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 6:48 AM
Points: 2,633, Visits: 3,977
Thanks Anthony,

Any solution?? Anyway to find what this causes??
Post #1410515
Posted Wednesday, January 23, 2013 5:55 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, October 13, 2014 6:42 AM
Points: 5,216, Visits: 5,111
Could check the default trace see what else was happening at the time, or if you have any custom auditing try and look through that to see what was going on.



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1410516
Posted Wednesday, January 23, 2013 6:09 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 11:43 AM
Points: 193, Visits: 746
If you can't take an exclusive lock on the db, try kicking off users out of this db (make sure by running sp_who2) nobody is using that db, place it in single user mode, and then run consistency checks on that. Thoroughly check the output of dbcc for any errors noticed. Once, the checks have been completed, revert it to it's original state. If possible inform the users before carrying out dbcc checks, becoz of this you won't likely need to take the db into single user mode, as there won't be any live connections to the db.

Regards,
Faisal
Post #1410526
Posted Wednesday, January 23, 2013 9:02 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 6:48 AM
Points: 2,633, Visits: 3,977
Hi Faizal,

This is production box
Post #1410654
Posted Wednesday, January 23, 2013 11:28 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, October 22, 2014 2:04 PM
Points: 636, Visits: 5,012
You can create a snapshot of the DB and run CHECKDB against that.


Post #1410729
Posted Thursday, January 24, 2013 8:21 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 11:43 AM
Points: 193, Visits: 746
Hi Ratheesh,

If that's a prod box then you have 2 options left, either restore a copy of that db to a test environment, and run dbcc checks on that. In case if you don't have a test environment setup for this (which I think shouldn't be the case) then you need to ask some downtime from the business owners of that db coz this will be a resource intensive operation, and you don't want anything coming your way of testing.

There is an alternate option as well, wherein you can use sql virtual restore from red gate, pickup the backup of the database, restore it as a virtual db, and run consistency checks on them. It will not only save on the space, but less utilization of resources as well.Try testing it with a trial version, it would definitely do wonders for you.

The product actually is beneficial for VLDB's, as checks would be quite stressful, and if you're down with drive space...for e.g: if you have 8 TB of database (mostly in a datawarehouse scenario), and you can't physically restore the db, then you should opt for this product, it will do the stuff for you.

I hope this helps!!!

Regards,
Faisal
Post #1411163
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse