SQL VDI Errors (SQLVDIMemoryName_0) SQL Backup failed messages logged in SQL Error Log

On one of our SQL Servers, we have noticed backup failed messages in SQL Error Logs.

BACKUP failed to complete the command BACKUP DATABASE master. Check the backup application log for detailed messages.

However when we have verified that our backup jobs did run fine and backup files were created. The time the error reported is different from the time of our original backups were scheduled. This led me to believe that there could be something else and checked the event viewer.

Below are some messages I noticed in the event viewer.

SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=2084. Thread=3588. Client. Instance=. VD=Global\{92331B1D-9F47-4B1F-BC7D-973625BF0799}2_SQLVDIMemoryName_0.

BackupVirtualDeviceFile::PrepareToFreeze: failure on backup device '{92331B1D-9F47-4B1F-BC7D-973625BF0799}1'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).

After checking with our service provider (hosted datacentre), we understood that Windows Admin team enabled SQL Server backups through VSS (Volume Shadow Services). During the execution this process freezes I/O temporarily to take shadow copy and release it back once process is complete.

We are taking SQL native backups to the local drive and our agreement with the provider is to take backup of the folders on system. Hence we requested Windows Admin of our Datacenter provider team to disable the SQL Server backups through VSS.

Refer below article for more details:

-Hari Mindi


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.