This article applies to:
- OS: Windows Server
- Product edition: Phoenix Cloud and Gov Cloud
SQL Backup fails with error VSS10. This article explains the reason behind this behavior and its solution.
Sometimes, SQL backups fail when VSS SQL writer goes missing from the writers' list intermittently. The backups run fine after the VSS service is restarted but the issue reoccurs in a few days.
The issue might occur due to a crash in a Service Host (SVCHOST.EXE). The critical one being the COM+ Event System (EventSystem) which is the glue for the VSS writer. Even if the COM+ Event System immediately comes online, SQL Writer does not detect the failure and again initialize with VSS Writer (neither does the BITS service). Restarting the SQL Writer service corrects the issue but with manual intervention.
For a more robust resolution of this issue, load the COM+ Event System (EventSystem) into its own SVCHOST so that it does get impacted by problems form other services.
From the admin command prompt, run:
sc config EventSystem type= own
This requires an OS reboot to take effect.
After the OS reboot, verify whethr the EventSystem is in its own SVCHOST with:
tasklist /FI "IMAGENAME eq svchost.exe" /SVC