Skip to main content

Backup Warning - SQL Server Express 2008 R2

Thread needs solution
Beginner
Posts: 2
Comments: 2

Hello,

I am getting the following error and any help would be greatly appreciated.  The machines are brand new VMS, fully ptached and only have the OS and SQL Express installed.  All writers are present and stable.  I've re-installed both the VMTools and the Acronis Backup Agent and to no avail, the backups come with warnings.  I;ve tried going through technical support, but clearly they were unaware of even where to begin looking or the call kept getting disconnected.  The windows event logs were clean as a whistle and no other error messages present - can anyone help?

 

Applications quiescing using VMware VSS components has failed. Application data inside the backup might be inconsistent since the snapshot was taken without VSS. Internal error: VSS Writer with id: Microsoft SQL Server VSS Writer not found
Additional info: 
--------------------
Error code: 1
Module: 560
LineInfo: c0d34cead0ce9e15
Fields: 
Message: Applications quiescing using VMware VSS components has failed. Application data inside the backup might be inconsistent since the snapshot was taken without VSS. Internal error: VSS Writer with id: Microsoft SQL Server VSS Writer not found

0 Users found this helpful
Acronis Program Manager
Posts: 22
Comments: 3742

Hi Travis,

Such message can be given if you are trying to enable application-aware backup option while backing up a VM running Windows 7 (or other non-server OS). These guest OSes are not supported for application-consistent quescing by VMware (see link) and hence the VSS metadata is not collected properly, so application-aware option must be disabled for these machines. This of course is true only assuming that Microsoft VSS writer is indeed listed in "vssadmin list writers" outputs. If not then please continue working with our support team to complete the investigation.

Thank you.

--

Best regards,

Vasily

Acronis Virtualization Program Manager

Beginner
Posts: 2
Comments: 2

Well that's good and bad I suppose.  I was on the phone and working with Acronis for hours - this would have saved a lot of time.

Question - what is the impact of not being able to do application-aware backups on these two machines?

Thanks!

 

Travis

Acronis Program Manager
Posts: 22
Comments: 3742

Hi Travis,

Application-aware processing for SQL practically does the following things:

1) Ensures that SQL instances/databases are quiesced properly by capturing and analyzing VSS manifest output generated by VMware Tools (generated during quiesced snapshot).

2) Performs SQL logs truncation after backup

Therefore in your case as an alternative you can either truncate SQL logs manually or enable circular logging.

Thank you.

--

Best regards,

Vasily

Acronis Virtualization Program Manager

Beginner
Posts: 2
Comments: 2

Thanks!  I'll do the truncation myself!  Much apprecaited!