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.
- Skill level:
Other People Are Reading
Things you need
- Microsoft Windows
- Microsoft SQL Server
Navigate to "All Programs," "Administrative Tools" and click the "Services" icon.
Scroll through the alphabetical list of Services and locate the entry "Volume Shadow Copy."
Right-click the service name and left-click "Properties" from the menu.
Select "Disabled" from the "Startup type" drop-down and click the "OK" button.
Restart Windows if the VSS service was running.
Tips and 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.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for