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 12»»

DBCC CHECKDB Error .... Expand / Collapse
Author
Message
Posted Monday, August 19, 2013 3:05 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, January 10, 2014 10:30 PM
Points: 168, Visits: 1,060
Hi ,

On one of the production box , I am facing the below error while running the weekly maintenance job :

ERROR :

Msg 5030, Level 16, State 12, Server XXX , Line 1
The database could not be exclusively locked to perform the operation.
Msg 7926, Level 16, State 1, Server XXX , Line 1
Check statement aborted. The database could not be checked as a database snapshot could not be created and the database or table could not be locked. See Books Online for details of when this behavior is expected and what workarounds exist. Also see previous errors for more details.
Outcome: Failed
Duration: 00:00:20

COMMAND which is getting execute on the back end :

Command: DBCC CHECKDB ([DB Name]) WITH NO_INFOMSGS, ALL_ERRORMSGS, DATA_PURITY

This error is coming for MSDB Database and couple of user databases as well . For some of the databases the maintenance job is running fine , only for few databases the error is coming.

I grantd the SQL SERVER& AGENT account full permissions in the MDF/LDF file path but this doesn't seems to be permission issue. There is no error log entry which is getting generated while the job fails.

Also the job is running on SQL 2005 Standard edition (9.0.5057) , hence manually taking snapshots is not possible.

Please help !!!!!!!!!!!
Post #1485693
Posted Monday, August 19, 2013 3:16 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 4:44 AM
Points: 2,397, Visits: 2,935
Can you check and see if the commands are being blocked by other (long-)running queries?

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1485698
Posted Monday, August 19, 2013 3:24 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, January 10, 2014 10:30 PM
Points: 168, Visits: 1,060
There is no blocking traced on the back end. Its a Share point instance and around 200 sleeping connections are present as of now.

Post #1485703
Posted Monday, August 19, 2013 6:14 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 7:08 AM
Points: 943, Visits: 2,950
http://support.microsoft.com/kb/928518



The SQL Guy @ blogspot

@SeanPearceSQL

About Me
Post #1485749
Posted Monday, August 19, 2013 6:20 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 @ 6:44 AM
Points: 40,207, Visits: 36,616
What's in the SQL Server error log?


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 #1485753
Posted Monday, August 19, 2013 6:47 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, January 10, 2014 10:30 PM
Points: 168, Visits: 1,060
The solution explained in the Link cannot be implemented in this case as SQL Standard edition is running and hence no snapshots can be taken .
Post #1485775
Posted Monday, August 19, 2013 7:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 30, 2013 8:59 AM
Points: 7, Visits: 28
Still we are having the same issue..Job failing..Please help us to fix the issue.
Post #1485784
Posted Monday, August 19, 2013 7:25 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 @ 6:44 AM
Points: 40,207, Visits: 36,616
GilaMonster (8/19/2013)
What's in the SQL Server error log?



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 #1485802
Posted Monday, August 19, 2013 7:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 30, 2013 8:59 AM
Points: 7, Visits: 28
Job completed successfully after giving the Full rights to Sql server account..Thanks every one for your instant help
Post #1485804
Posted Tuesday, August 20, 2013 4:34 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
Are you using different account for SQL server and agent? why?

Regards
Durai Nagarajan
Post #1486178
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse