InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 08:45:52 GMT20http://www.sqlservercentral.com/Forums/Topic1363353-266-1.aspxPrevious post reported as spam.For the OP's issue, it looks like there the is a system latch on the database preventing the snapshot from occurring at that time. Can you research what other activity may be going on during the time that you are trying to run a DBCC Checkdb?Wed, 28 Nov 2012 06:13:51 GMTJoie Andrewhttp://www.sqlservercentral.com/Forums/Topic1363353-266-1.aspxThis problem occurs if the following conditions are true: * At least one other connection is using the database against which you run the DBCC CHECK command. * The database contains at least one file group that is marked as read-only.Starting with SQL Server 2005, DBCC CHECK commands create and use an internal database snapshot for consistency purposes when the command performs any checks. If a read-only file group exists in the database, the internal database snapshot is not created. To continue to perform the checks, the DBCC CHECK command tries to acquire an EX database lock. If other users are connected to this database, this attempt to acquire an EX lock fails. Therefore, you receive an error message.To resolve this problem, follow these steps instead of running the DBCC CHECK command against the database: 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. 2. Run the DBCC CHECK command against the database snapshot. 3. Drop the database snapshot after the DBCC CHECK command is completed.Ref: http://support.microsoft.com/kb/928518Wed, 26 Sep 2012 03:56:18 GMTprettsonshttp://www.sqlservercentral.com/Forums/Topic1363353-266-1.aspxDear All,Could someone please advice on this.Msg 3013, Level 16, State 1, Line 1BACKUP DATABASE is terminating abnormally.Msg 845, Level 17, State 1, Line 1Time-out occurred while waiting for buffer latch type 3 for page (1:23723), database ID 6.------------------Msg 1823, Level 16, State 2, Line 1A database snapshot cannot be created because it failed to start.Msg 7928, Level 16, State 1, Line 1The 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.Msg 5030, Level 16, State 12, Line 1The database could not be exclusively locked to perform the operation.Msg 7926, Level 16, State 1, Line 1Check 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.Msg 845, Level 17, State 1, Line 1Time-out occurred while waiting for buffer latch type 3 for page (1:23723), database ID 6.Thanks and Regards,Ravi.Mon, 24 Sep 2012 01:39:24 GMTravisamigo