dbcc checkdb in azure managed instance error, The database snapshot for online checks could not be created #935
Unanswered
pixies386
asked this question in
Questions & Answers
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
we are using EXECUTE dbo.DatabaseIntegrityCheck @databases = 'USER_DATABASES', @CheckCommands = 'CHECKDB', @LogToTable = 'Y',
it runs DBCC CHECKDB ([databasenameX]) WITH ALL_ERRORMSGS for all db
but in an azure managed instance is failing, in some databases.
"The database snapshot for online checks could not be created"
we have read that azure MI doesnt support database snapshots, but some databases doesnt thorow this error.
Have anyboy experienced this problem? we have seen that with tablock can be used to avoid using database snapshot but it is not optimal because of the locks it impose on database and tables.
thank you
pixies386
Beta Was this translation helpful? Give feedback.
All reactions