Comprehensive data protection for all workloads
Post Reply
GabesVirtualWorld
Expert
Posts: 248
Liked: 38 times
Joined: Jun 15, 2009 10:49 am
Full Name: Gabrie van Zanten
Contact:

SQL2008 backup - Creating snapshot VSSFreezer

Post by GabesVirtualWorld »

Hi

Trying to backup my SQL2008 VM but Veeam returns the following error:
Creating snapshot
VSSFreezer: Failed to freeze guest, wait timeout

Where should I start looking?

Veeam Backup & Replication 4.0 on W2003R2 Enterprise 32bit
SQL Server Windows 2008R2 Enterprise 64bit - SQL 2008 Enterprise v10.0.2531

Regards
Gabrie
Gostev
Chief Product Officer
Posts: 31779
Liked: 7279 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL2008 backup - Creating snapshot VSSFreezer

Post by Gostev »

Gabrie, do you have vCenter or Veeam Backup database on this server? If so, we have a number of existing threads describing what is causing this issue - try to look for your error with the forum search.
GabesVirtualWorld
Expert
Posts: 248
Liked: 38 times
Joined: Jun 15, 2009 10:49 am
Full Name: Gabrie van Zanten
Contact:

Re: SQL2008 backup - Creating snapshot VSSFreezer

Post by GabesVirtualWorld »

Hi

I did read those other posts, but must have misread them :-) I thought this only was the case when running vCenter PLUS sql on the VM, but the VM is only running the vCenter DB, not vCenter it self. And it is running the Veeam Monitor DB.

Btw, I had to check on the SQL Server to find out if it was or was not running the Veeam DB. How can I check in Veeam Backup & Repl which DB is being used?

Gabrie
Gostev
Chief Product Officer
Posts: 31779
Liked: 7279 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL2008 backup - Creating snapshot VSSFreezer

Post by Gostev »

You can see it from the following registry keys:

Code: Select all

HKEY_LOCAL_MACHINE\SOFTWARE\VeeaM\Veeam Backup and FastSCP
SqlDatabaseName
SqlInstanceName
SqlServerName
GabesVirtualWorld
Expert
Posts: 248
Liked: 38 times
Joined: Jun 15, 2009 10:49 am
Full Name: Gabrie van Zanten
Contact:

Re: SQL2008 backup - Creating snapshot VSSFreezer

Post by GabesVirtualWorld »

Ok, for Veeam Backup & Repl the database is running locally.

Concering the backup of the SQL server. Is this indeed because the vCenter DB is running on it? A backup of the vCenter VM works without issues. I'd hate to nail the SQL VM down to one host and use the backup method where you point to a host instead of vCenter to perform the backup.

Gabrie
Gostev
Chief Product Officer
Posts: 31779
Liked: 7279 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL2008 backup - Creating snapshot VSSFreezer

Post by Gostev »

Alternatively, you could disable Veeam VSS for this VM.
rizks_2000
Enthusiast
Posts: 77
Liked: never
Joined: Feb 17, 2010 1:12 am
Full Name: Anthony Rizk
Contact:

Re: SQL2008 backup - Creating snapshot VSSFreezer

Post by rizks_2000 »

Gostev:

I see in the last post you put here, disabling the Veeam VSS for the VM in question could fix this problem. What exactly does disabling the VSS do?
Gostev
Chief Product Officer
Posts: 31779
Liked: 7279 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL2008 backup - Creating snapshot VSSFreezer

Post by Gostev »

Anthony, this disables using our proprietary VSS integration that enables for transactionally consistent application aware backups with the help of Microsoft VSS technology. The stickied FAQ thread in this forum has more information about this.
Post Reply

Who is online

Users browsing this forum: mattskalecki and 134 guests