cancel
Showing results for 
Search instead for 
Did you mean: 

Snapshot Failure on Server 2008 R2 SP1 with SQL 2012

InsentraCameron
Level 4
Partner Accredited Certified

Hello everyone,

Configuration:

  • Server 2008 R2 SP1
  • SQL 2012
  • NBU 7.5.0.6
  • Policy is VMware based
  • VMware 4.1.0

The server was being backed up successfully prior to SQL 2012 being installed. As of SQL 2012 being installed the backups have been failing. The balance of the VMs are being successfully backed up. No errors are showing up the server event logs.

NBU Logs

8/10/2013 9:01:21 PM - Info bpfis(pid=38720) Backup started           
8/10/2013 9:01:21 PM - snapshot backup of client vs28hospsql3 using method VMware_v2
8/10/2013 9:13:28 PM - Critical bpbrm(pid=33476) from client server3: FTL - VMware snapshot failed: SYM_VMC_TASK_REACHED_ERROR_STATE    
8/10/2013 9:13:28 PM - Critical bpbrm(pid=33476) from client server3: FTL - VMware error received: Cannot create a quiesced snapshot because the create snapshot operation exceeded the time limit for holding off I/O in the frozen virtual machine.
8/10/2013 9:13:29 PM - Critical bpbrm(pid=33476) from client server3: FTL - snapshot processing failed, status 156   
8/10/2013 9:13:29 PM - Critical bpbrm(pid=33476) from client server3: FTL - snapshot creation failed, status 156   
8/10/2013 9:13:29 PM - Warning bpbrm(pid=33476) from client server3: WRN - ALL_LOCAL_DRIVES is not frozen    
8/10/2013 9:13:29 PM - Info bpfis(pid=38720) done. status: 156          
8/10/2013 9:13:29 PM - end Application Snapshot, Create Snapshot; elapsed time: 00:12:14
8/10/2013 9:13:29 PM - Info bpfis(pid=0) done. status: 156: snapshot error encountered       
8/10/2013 9:13:29 PM - end writing

There is very little load on this server so there should be no issue quiescing the server.

Is there anything else I should be looking at?

Cheers,

Cameron

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Yasuhisa_Ishika
Level 6
Partner Accredited Certified

Snapshot creation of this VM is timed out. Can you take snapshot of this VM manually from vCenter? If not, this is matter of VMware, Windows and SQL Server.

View solution in original post

2 REPLIES 2

Yasuhisa_Ishika
Level 6
Partner Accredited Certified

Snapshot creation of this VM is timed out. Can you take snapshot of this VM manually from vCenter? If not, this is matter of VMware, Windows and SQL Server.

InsentraCameron
Level 4
Partner Accredited Certified

Hello Yasuhisa,

I cannot create a snapshot with VMware.

I will have someone in the Windows team look into it.

Cheers,