FIX: Can’t create database snapshot when you use DBCC CHECKDB in SQL Server 2014
If there's no other connection to the database, the DBCC operation is completed without errors. However, you receive the following error message:
If there are other connections to the database, the DBCC operation fails, and you receive the following error message:
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.
Cumulative Update informationThe issue was first fixed in the following cumulative update of SQL Server.
Recommendation: Install the latest cumulative update for SQL Server
Article ID: 3099548 - Last Review: 12/22/2015 03:15:00 - Revision: 1.0
- kbqfe kbsurveynew kbfix kbexpertiseadvanced KB3099548