Backup of vCenter Server SQL database using Veeam Backup & Replication

When using Veeam Backup & Replication for an application aware image processing  backup  of the virtual machine which hosts the SQL database used by VMware vCenter Server, the backup will fail with a VSSControl: Failed to freeze guest, wait timeout error.  This happens when Veeam communicates with vCenter Server for creation of the VSS snapshot. It is a kind of deadlock where Veeam B&R wants to communicate with vCenter while at the same time the database is frozen because of the VSS-snapshot.

To solve this problem, add the IP-adress of the ESX host which runs the vCenter Server SQL database to the Veeam console (the servers list in the left panel). Then adjust the job and select the virtual machine with the SQL database from the ESX host instead of via the vCenter Server. Veeam B&R will then use the host for communication with the VM to do the VSS snapshot.

You have to make sure the SQL VM does not move to another ESX host. Use a DRS Host Affinity rule to tie the SQL VM to the particular host which was added to the Veeam console. As a best practise the VM running vCenter Server should as well be pinned to a certain server so you always know where it is running in case of problems.

Advertisements

About Marcel van den Berg
I am a technical consultant with a strong focus on server virtualization, desktop virtualization, cloud computing and business continuity/disaster recovery.

One Response to Backup of vCenter Server SQL database using Veeam Backup & Replication

  1. Daniel says:

    Thanks Marcel,
    I was just looking for this.
    Works like a charm (y)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: