SQL Database backup fails and the SQL error log and System Application log both reporting: Operating system error 995
Problem
A large SQL Database backup performed with Backup Exec always fails around the same size being backed up.
The following error message is logged in the SQL error log and in the System Application event log: Operating system error 995
A backup of a smaller SQL database or a backup of multiple smaller SQL databases is working fine.
Error Message
SQL Error Log:
BackupIoRequest::ReportIoError: write failure on backup device 'xxx'. Operating system error 995 (The I/O operation has been aborted because of either a thread exit or an application request.).
Application Event log:
Date: Date and Time
Log: Application
Event Type: Error
Source: MSSQLSERVER
Computer: Servername
User: Username
Event ID: 18210
Description: BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'xxx'. Operating system error 995 (The I/O operation has been aborted because of either a thread exit or an application request.).
Date: Date and Time
Log: Application
Event Type: Error
Source: MSSQLSERVER
Computer: Servername
User: Username
Event ID: 18210
Description: BackupIoRequest::ReportIoError: write failure on backup device 'xxx'. Operating system error 995 (The I/O operation has been aborted because of either a thread exit or an application request.).
Cause
This issue is caused by a virtual memory limitation of the Operating System on the system backed up.
Solution
1) Increase the virtual memory of the Operating System to ensure that the SQL API can perform all the required actions to successfully backup the SQL database.
2) If SQL is installed on a VMware virtual machine, the following steps can also be tried.
Uninstall VMware tools, Uninstall Remote Agent and then Install VMware tools and then Install Remote Agent. Then test the backup.
Note: Both remote agent-based or VMware backup of the VM can run into this error. Agent-based backup may fail with this error " 0xe000ff19 - A communications failure has occurred with a SQL Server resource
."