Jun 24

Backup of VMware Windows MS SQL guest fails

VE Comments Off on Backup of VMware Windows MS SQL guest fails

Problem(Abstract)

Tivoli Storage Manager for Virtual Environments is used to back up a Windows guest that runs Microsoft SQL. The backup of the VM fails with the ANS9365E and ANS5250E errors.

Symptom

The following errors are logged during the backup :


04/30/2014 23:18:46 ANS9365E VMware vStorage API error for virtual machine 'myguest'.
TSM function name : visdkCreateVmSnapshotMoRef
TSM file : vmvisdk.cpp (5416)
API return code : 67
API error message : An error occurred while quiescing the virtual machine. See the virtual machine's event log for details.
04/30/2014 23:18:46 ANS5250E An unexpected error was encountered.
TSM function name : vmVddkFullVMPrePareToOpenVMDKs
TSM function : snapshot targetMoRefP is null
TSM return code : 115
TSM file : ..\..\common\vm\vmbackvddk.cpp (12439)
04/30/2014 23:18:46 ANS1228E Sending of object 'myguest' failed.

 

Diagnosing the problem

Examine the vmware.log of the virtual machine, located in the folder of the virtual machine in the datastore. The following errors are logged :

2014-05-05T02:32:18.259Z| vcpu-1| I120: [msg.snapshot.quiesce.vmerr] The guest OS has reported an error during quiescing.
2014-05-05T02:32:18.259Z| vcpu-1| I120+ The error code was: 5
2014-05-05T02:32:18.259Z| vcpu-1| I120+ The error message was: 'VssSyncStart' operation failed: IDispatch error #8449 (0x80042301)

Examine the Windows event log of the Windows guest. The following errors are logged :

4/30/2014 11:18:30 PM VSS Error None 6008 N/A MYGUEST
Sqllib error: Failed to create VDS object. hr = 0x80040154.
4/30/2014 11:18:30 PM VSS Error None 20 N/A MYGUEST
Volume Shadow Copy Service error: A critical component required by the Volume Shadow Copy service is not registered. This might happened if an error occurred during Windows setup or during
installation of a Shadow Copy provider. The error returned from CoCreateInstance on class with CLSID
{40700425-0080-11d2-851f-00c04fc21759} and Name MSSQL_ClientVirtualDeviceSet is [0x80040154].

 

Resolving the problem

In this case, the backup fails is caused by a VSS problem on the Windows guest. Follow the steps below to resolve the error :

  1. Stop SQL Server.
  2. Click Start/Run and enter the following command in the Open box, and then click OK.

    Regsvr32 Path\SQLVDI.DLL

    The default path of the Sqlvdi.dll file is C:\Program Files\Microsoft SQL Server\80\COM.
  3. Restart SQL Server.
  4. Run the backup of the VM

Refer to the following Microsoft article for more information about the VSS SQL error.
http://support.microsoft.com/kb/830575

written by Bosse