Azure backup to url from SQL Server 2014 Failing

Copper Contributor

Hi,

 

We backup using the backup to URL option in SQL Server 2014 to an Azure General Purpose Storage account (Classic)

 

This has been working fine as  far as we know for some time. Recently some backups have been randomly failing with the message (I've removed the blob url and link to the file for security and replaced with 'OURCONTAINERURL'

 

BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'OURCONTAINERURL.bak'. Operating system error Backup to URL received an exception from the remote endpoint. Exception Message: Unrecoverable error occurred during Flush operation.


SQLVDI: Loc=CVDS::Close. Desc=Open devices!. ErrorCode=(0). Process=10296. Thread=19472. Client. Instance=MSSQLSERVER. VD=Global\OURCONTAINERURL.bak_SQLVDIMemoryName_0.



SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Process=10296. Thread=19472. Client. Instance=MSSQLSERVER. VD=Global\OURCONTAINERURL.bak_SQLVDIMemoryName_0.


BACKUP failed to complete the command BACKUP DATABASE 81420a7e342847d9824c00ee5eade519 WITH DIFFERENTIAL. Check the backup application log for detailed messages.


SQLVDI: Loc=TriggerAbort. Desc=invoked. ErrorCode=(0). Process=3420. Thread=6936. Server. Instance=MSSQLSERVER. VD=Global\OURCONTAINERURL.bak_SQLVDIMemoryName_0.


BackupVirtualDeviceFile::CloseMedia: Completion failure on backup device 'OURCONTAINERURL.bak'. Operating system error Error could not be gathered from Remote Endpoint.

This looks like an issue on the Azure storage end of things?

 

Any advice would be appreciated.

 

Best,

Jerome

0 Replies