Can not run DBCC Checkdb on database

SQL Server 2005 64 Bit Version 9.00.2050.00 (SP1) Enterprise Edition
Can not run DBCC Checkdb on database because receiving the following error
messages:
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.
We have tried running this command on other databases on this same instance
of SQL Server and the DBCC Checkdb process runs. In several databases the
snapshot cannot be created, but the process does run successfully directly
on the database, and on other databases the whole process runs as designed.
This database that is erroring is also copied to another server running SQL
Server 2005 32 bit Enterprise edition 9.00.2047(SP1) and we can successfully
run DBCC Checkdb on that database on that 32 bit server.
*side note- both databases were on the same release and the error was
already occuring on the 64 bit version
Any suggested remedies appreciated.Hello,
Thank you for posting here.
From the problem description of the post you submitted, my understanding
is: the following error message is received when attempting to run the
"DBCC Checkdb" command on a SQL Server 2005 64
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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. See Books Online for details of when this behavior is expected and
what workarounds exist. Also see previous errors for more details.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
If I have misunderstood about your concern, feel free to let me know.
Based on my experience and knowledge, this behavior can be caused by one of
the following factors.
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
At this point, to troubleshoot the issue, I suggest we try the following
suggestion.
Suggestion 1: Change the startup account of SQL Server service to Local
System account
=======================================
1. Open SQL Server Configuration Manager
2. Highlight "SQL Server 2005 services", double click SQL Server
(MSSQLSERVER) in the right panel.
3. On the open window, please set "Built-in account" to "Local System" and
click OK.
4. System will prompt us to restart the service. Click Yes to continue.
After that, let's run the DBCC CHECKDB command again. If the issue stays,
let's move on to the next suggestion.
Suggestion 2: Manually create the database snapshot
========================================
1. Create a database snapshot of the database for which you want to perform
the checks.
For more information about how to create a database snapshot, see the "How
to: Create a Database Snapshot (Transact-SQL)" topic in SQL Server 2005
Books Online at
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/187fbba3-c555-4030-9bdf-0f01
994c5230.htm
2. Run the DBCC CHECK command against the database snapshot.
3. Drop the database snapshot after the DBCC CHECK command is completed.
Please let me know the results at your earliest convenience. If anything is
unclear in my reply, please don't hesitate to let me know and I will be
glad to help. Thank you for your efforts and time.
Have a nice day!
Best regards,
Adams Qu, MCSE 2000, MCDBA
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "Russell" <Clarksville@.nospam.nospam>
| Subject: Can not run DBCC Checkdb on database
| Date: Wed, 2 May 2007 10:29:16 -0500
| Lines: 28
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| Message-ID: <#j2Y66MjHHA.2368@.TK2MSFTNGP04.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: nsc64.90.20-10.newsouth.net 64.90.20.10
| Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP04.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:14600
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| SQL Server 2005 64 Bit Version 9.00.2050.00 (SP1) Enterprise Edition
|
| Can not run DBCC Checkdb on database because receiving the following
error
| messages:
| 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.
| We have tried running this command on other databases on this same
instance
| of SQL Server and the DBCC Checkdb process runs. In several databases the
| snapshot cannot be created, but the process does run successfully
directly
| on the database, and on other databases the whole process runs as
designed.
|
| This database that is erroring is also copied to another server running
SQL
| Server 2005 32 bit Enterprise edition 9.00.2047(SP1) and we can
successfully
| run DBCC Checkdb on that database on that 32 bit server.
|
| *side note- both databases were on the same release and the error was
| already occuring on the 64 bit version
|
| Any suggested remedies appreciated.
|
|
|
|
|
|
||||Hello,
How's everything going?
I'm wondering if the suggestion has helped or if you have any further
questions. Please feel free to respond to the newsgroups if you need any
additional help.
Have a great day!
Best regards,
Adams Qu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
==============
PLEASE NOTE: The partner managed newsgroups are provided to assist with
break/fix issues and simple how to questions.
We also love to hear your product feedback!
Let us know what you think by posting
from the web interface: Partner Feedback
from your newsreader: microsoft.private.directaccess.partnerfeedback.
We look forward to hearing from you!
========================================
==============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============
| X-Tomcat-ID: 77322427
| References: <#j2Y66MjHHA.2368@.TK2MSFTNGP04.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: v-adamqu@.online.microsoft.com (Adams Qu [MSFT])
| Organization: Microsoft
| Date: Thu, 03 May 2007 05:25:56 GMT
| Subject: RE: Can not run DBCC Checkdb on database
| X-Tomcat-NG: microsoft.public.sqlserver.server
| Message-ID: <6tj5KOUjHHA.3352@.TK2MSFTNGHUB02.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| Lines: 136
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:14652
| NNTP-Posting-Host: TOMCATIMPORT1 10.201.218.122
|
| Hello,
|
| Thank you for posting here.
|
| From the problem description of the post you submitted, my understanding
| is: the following error message is received when attempting to run the
| "DBCC Checkdb" command on a SQL Server 2005 64
|
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
| 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. See Books Online for details of when this behavior is expected
and
| what workarounds exist. Also see previous errors for more details.
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
| If I have misunderstood about your concern, feel free to let me know.
|
| Based on my experience and knowledge, this behavior can be caused by one
of
| the following factors.
|
| 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
|
| At this point, to troubleshoot the issue, I suggest we try the following
| suggestion.
|
| Suggestion 1: Change the startup account of SQL Server service to Local
| System account
| =======================================
| 1. Open SQL Server Configuration Manager
| 2. Highlight "SQL Server 2005 services", double click SQL Server
| (MSSQLSERVER) in the right panel.
| 3. On the open window, please set "Built-in account" to "Local System"
and
| click OK.
| 4. System will prompt us to restart the service. Click Yes to continue.
|
| After that, let's run the DBCC CHECKDB command again. If the issue stays,
| let's move on to the next suggestion.
|
| Suggestion 2: Manually create the database snapshot
| ========================================
| 1. Create a database snapshot of the database for which you want to
perform
| the checks.
|
| For more information about how to create a database snapshot, see the
"How
| to: Create a Database Snapshot (Transact-SQL)" topic in SQL Server 2005
| Books Online at
|
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/187fbba3-c555-4030-9bdf-0f01
| 994c5230.htm
|
| 2. Run the DBCC CHECK command against the database snapshot.
| 3. Drop the database snapshot after the DBCC CHECK command is completed.
|
| Please let me know the results at your earliest convenience. If anything
is
| unclear in my reply, please don't hesitate to let me know and I will be
| glad to help. Thank you for your efforts and time.
|
| Have a nice day!
|
| Best regards,
|
| Adams Qu, MCSE 2000, MCDBA
| Microsoft Online Support
|
| Microsoft Global Technical Support Center
|
| Get Secure! - www.microsoft.com/security
| ========================================
=============
| When responding to posts, please "Reply to Group" via your newsreader so
| that others may learn and benefit from your issue.
| ========================================
=============
| This posting is provided "AS IS" with no warranties, and confers no
rights.
|
| --
| | From: "Russell" <Clarksville@.nospam.nospam>
| | Subject: Can not run DBCC Checkdb on database
| | Date: Wed, 2 May 2007 10:29:16 -0500
| | Lines: 28
| | X-Priority: 3
| | X-MSMail-Priority: Normal
| | X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| | X-RFC2646: Format=Flowed; Original
| | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| | Message-ID: <#j2Y66MjHHA.2368@.TK2MSFTNGP04.phx.gbl>
| | Newsgroups: microsoft.public.sqlserver.server
| | NNTP-Posting-Host: nsc64.90.20-10.newsouth.net 64.90.20.10
| | Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP04.phx.gbl
| | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:14600
| | X-Tomcat-NG: microsoft.public.sqlserver.server
| |
| | SQL Server 2005 64 Bit Version 9.00.2050.00 (SP1) Enterprise Edition
| |
| | Can not run DBCC Checkdb on database because receiving the following
| error
| | messages:
| | 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.
| | We have tried running this command on other databases on this same
| instance
| | of SQL Server and the DBCC Checkdb process runs. In several databases
the
| | snapshot cannot be created, but the process does run successfully
| directly
| | on the database, and on other databases the whole process runs as
| designed.
| |
| | This database that is erroring is also copied to another server running
| SQL
| | Server 2005 32 bit Enterprise edition 9.00.2047(SP1) and we can
| successfully
| | run DBCC Checkdb on that database on that 32 bit server.
| |
| | *side note- both databases were on the same release and the error was
| | already occuring on the 64 bit version
| |
| | Any suggested remedies appreciated.
| |
| |
| |
| |
| |
| |
| |
|
|