Avamar: Vmware Image Backup Issues on Windows VM with SQL Server
Summary: VMware image backups of Windows virtual machines running SQL Server may show inconsistent SQL log behavior when quiesce is enabled. In some scenarios, SQL logs record full database backups instead of COPY_ONLY events, which can disrupt existing backup chains. In other cases, SQL logs show no backup-related entries, indicating that the backup completed in a crash‑consistent state. These issues may be related to VMware Snapshot Provider settings, VSS configuration, or missing SQL VSS writers. ...
This article applies to
This article does not apply to
This article is not tied to any specific product.
Not all product versions are identified in this article.
Symptoms
Virtual Machine (VM) Image backup is taken with quiesce enabled (by default).
- When VM image backup is taken for VM with SQL Server on it, we should see
"DB Full (COPY_ONLY)"events in SQL Logs. Instead, we may have two different cases:- Each Database gets "
DB Full" backup created event in SQL logs - There is no any 'backup' event at all registered on SQL.
- Each Database gets "
Cause
Case 1:
- By default, each image backup is using quiesce when creating a snapshot.
- Relevant portion from backup log:
In first case, the backup is application-consistent, however it does not create COPY_ONLY backups which can interfere (break backup chain) with other SQL backups on this SQL instance2018-05-01 22:01:02 avvcbimage Info <42650>: Creating snapshot 'Avamar-152521206017ff362a23f6a0cbf536c74c164886b6c56ad7b6', quiesceFS=1 . . . 2018-05-01 22:01:43 avvcbimage Info <42208>: No VSS manifest found. This is expected for non-Windows VMs, and older version of Windows VMs that do not support VSS. 2018-05-01 22:01:43 avvcbimage Info <42209>: For Windows VMs with VSS support, the VM must be powered on and VMware Tools must be running for the manifest file to be generated.
- Relevant portion from backup log:
Case 2:
- We do not see
"avvcbimage Info <42208>: No VSS manifest found"message in the image backup log, however there are no backup related events in SQL Log. - In second case, the backup is crash-consistent, so it does not capture all data and transactions in memory during the backup.
Resolution
Case 1:
- Check the state of
"VMware Snapshot Provider"service. - Ensure that the VMware Snapshot Provider is not running and that the startup type is listed as Manual.
- Some third-party Software may have a recommendation to disable Volume Shadow Copy in VM Tools.
https://www.veritas.com/support/en_US/article.100003428 (External Link) - The
"Volume Shadow Copy"has to be enabled in VM Tools.
- Some third-party Software may have a recommendation to disable Volume Shadow Copy in VM Tools.
Case 2:
- Check the writers list on affected SQL VM.
- As administrator in command prompt, run:
vssadmin list writers Ensure that SQL VSS Writer is listed,- If not listed then address the issue to
Windows/SQL Administratorif this writer is not present.
- If not listed then address the issue to
- For more info (both cases) check the KB below:
Troubleshooting Volume Shadow Copy (VSS) quiesce related issues (External Link)
- As administrator in command prompt, run:
Affected Products
Avamar ClientProducts
Avamar ClientArticle Properties
Article Number: 000031958
Article Type: Solution
Last Modified: 10 Mar 2026
Version: 4
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.