How to Disable the SQL Server VSS Writer Service
The SQL Writer in SQL Server uses the Volume Shadow Copy Service (VSS) to perform a backup or restore request of a database from an external application. The VSS is maintained as a Windows service versus a SQL Server service. This means SQL Server can continue to run and serve database files without VSS running. Use the Windows services console to disable SQL Server VSS Writer only when other applications do not require access to database files.
Other People Are Reading
Instructions
-
-
1
Click "Start."
-
2
Navigate to "All Programs," "Administrative Tools" and click the "Services" icon.
-
-
3
Scroll through the alphabetical list of Services and locate the entry "Volume Shadow Copy."
-
4
Right-click the service name and left-click "Properties" from the menu.
-
5
Select "Disabled" from the "Startup type" drop-down and click the "OK" button.
-
6
Restart Windows if the VSS service was running.
-
1
Tips & Warnings
Stop the VSS service and test your backup applications before deciding to permanently disable the service.
Verify the "Remote Procedure Call" service is enabled when attempting to restart the VSS service.
References
Resources
- Photo Credit Jupiterimages/Comstock/Getty Images
