An I/O error occurs in SQL Server due to cloning backup from a virtual machine.

An I/O error occurs in SQL Server due to cloning backup from a virtual machine.

CASE Environment:

Server Configuration: CPU: Intel E5-2690

RAM: 12 GB Virtual Machine

Operating System: Windows Server 2008 R2 Standard Edtion x64

Database Version: SQL SERVER 2008R2
Case study:

In the evening, I received an Alert email from the database. SQL Server Alert System: 'severity 016' occurred on \ xxxxx. The email content is as follows,

 
 

  
  
DATE/TIME: 2014/8/13 22:56:11 
  
  
DESCRIPTION:  BackupVirtualDeviceFile::SendFileInfoBegin:  failure on backup device '{0D9AFBD0-3C20-410F-A5E0-B9305296F52A}3'. Operating system error 995(failed to retrieve text for this error. Reason: 15105). 
  
  
  
  
  
COMMENT:   (None) 
  
  
  
  
  
JOB RUN:   (None) 
 
 

Check the SQL SERVER Error Log. For more information, see the following ),

 
 

  
  
Date: 22:56:11
  
  

  
  
Log SQL Server (archive number 7-0:00:00)
  
  

  
  
Source Backup
  
  

  
  
Message
  
  

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

 
 

  
  
Date: 22:56:11
  
  

  
  
Log SQL Server (archive number 7-0:00:00)
  
  

  
  
Source spid86
  
  

  
  
Message
  
  

  
  
I/O was resumed on database msdb. No user action is required.
  
  

 
 

 
 

  
  
Date: 22:56:11
  
  

  
  
Log SQL Server (archive number 7-0:00:00)
  
  

  
  
Source spid134
  
  

  
  
Message
  
  

  
  
Error: 18210, Severity: 16, State: 1.
  
  

  
  
Date: 22:56:11
  
  

  
  
Log SQL Server (archive number 7-0:00:00)
  
  

  
  
Source spid134
  
  

  
  
Message
  
  

  
  
BackupVirtualDeviceFile: SendFileInfoBegin: failure on backup device '{timeout} 5'. Operating system error 995 (failed to retrieve text for this error. Reason: 15105 ).
 
 

Check the system Application log and find the following error message:

A bit of suspicion is caused by some operation errors of the virtual machine, bold assumptions, careful proof. Therefore, when you contact the system administrator to communicate with the system administrator,

We found that he was backing up and cloning the VM at that time. This IO error occurs.

Author: Xiaoxiang hidden Source: http://www.cnblogs.com/kerrycode/