DBCC CHECKDB – Msg 7928, Level 16, State 1, Line 3 The database snapshot for online checks could not be created.

Posted on by

Do you execute DBCC CHECKDB on your Azure SQL Database? From past experience I know some people do, I would suggest not to bother. Why?

Well I have mentioned in older blog posts that this is the responsibility of Microsoft. They have official announcements on what they actually do (https://azure.microsoft.com/en-us/blog/data-integrity-in-azure-sql-database/).

I have covered in the past the performance impact – https://blobeater.blog/2017/09/04/dbcc-checkdb-azure-sql-database/

What I have noticed recently is that I have been getting the following quite often, so nowadays, I just don’t bother with the command. (For Azure SQL Database PaaS)

msg 7928, Level 16, State 1, Line 3
The 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 8921, Level 16, State 3, Line 3
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.

1 thought on “DBCC CHECKDB – Msg 7928, Level 16, State 1, Line 3 The database snapshot for online checks could not be created.”

  1. Pingback: DBCC CHECKDB Error on Azure SQL Database – Curated SQL

Leave a Reply