[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

DBCC CheckDB  fails with error 7926 and error 5030

Posted on 2008-11-13
2
Medium Priority
?
2,215 Views
Last Modified: 2012-05-05
DBCC CheckDB will not run against databases.

Executing

DBCC CheckDB('master')

returns

Msg 5030, Level 16, State 12, Line 1
The database could not be exclusively locked to perform the operation.
Msg 7926, Level 16, State 1, 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.

I'd be very grateful for some help



0
Comment
Question by:DavidHannen
2 Comments
 
LVL 31

Accepted Solution

by:
James Murrell earned 2000 total points
ID: 22950409
1. The SQL Server startup account does not have sufficient permission on the SQL Server data folder.
2. At least one other connection is using the database against which you  run the DBCC CHECK command.  
3. The database contains at least one file group that is marked as read-only.

For more information regarding this issue, please refer tot the following
KB article:

Error message when you run any of the DBCC CHECKDB commands in SQL Server
2005: "The database could not be exclusively locked to perform the
operation"
http://support.microsoft.com/?id=928518
0
 

Author Closing Comment

by:DavidHannen
ID: 31516385
Thanks
I had given the SQL Server Service account the correct permissions to the wrong folder. Doh!

Thanks for the push in the right direction. Sometimes caanot see for looking!!
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question