SQL Database backup fails and the SQL error log and System Application log both reporting: Operating system error 995

book

Article ID: 100045630

calendar_today

Updated On:

Description

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.
 

 

Resolution

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."