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

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.

Advertisements

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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s