How to disable the SQL server vss writer service

Written by jon guenther
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to disable the SQL server vss writer service
(Jupiterimages/Comstock/Getty Images)

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:
Easy

Other People Are Reading

Things you need

  • Microsoft Windows
  • Microsoft SQL Server

Show MoreHide

Instructions

  1. 1

    Click "Start."

  2. 2

    Navigate to "All Programs," "Administrative Tools" and click the "Services" icon.

  3. 3

    Scroll through the alphabetical list of Services and locate the entry "Volume Shadow Copy."

  4. 4

    Right-click the service name and left-click "Properties" from the menu.

  5. 5

    Select "Disabled" from the "Startup type" drop-down and click the "OK" button.

  6. 6

    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.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.