SQL Server Performance

SQL Server VSS writer service

Discussion in 'Getting Started' started by AFriend, Jun 25, 2009.

  1. AFriend New Member

    Hi Experts,
    I am using SQL 2005 and taking DB backup with Third party tool.Just want to know What is use of SQL Server VSS writer service and can we keep it disable for always?
    ---AFriend.
  2. MohammedU New Member

    SQL Writer Service
    The SQL Writer Service provides added functionality for backup and restore of SQL Server 2005 through the Volume Shadow Copy Service framework.
    This SQL Writer Service is automatically installed but not enabled by default. It must be explicitly enabled to run on the server machine and must be running at the time that the Volume Shadow Copy Service (VSS) application requests a backup or restore. Use the Microsoft Windows Services applet to configure the service. The SQL Writer Service installs on all operating systems but is only needed on server systems. For Microsoft Windows XP, use the MSDE Writer.
    SQL Server 2005 Service Pack 2 configures SQL Writer to start automatically.
    http://msdn.microsoft.com/en-us/library/ms175536(SQL.90).aspx

Share This Page