2011年3月17日 星期四

SQL Writer 自發性的啟動?

SQL Writer 預設和SQL Server一起安裝,主要目的在於和VSS互動,讓備份軟體可在SQL Server運行時,執行備份或復原鎖定的data files。

這個服務預設是Disabled的,但我試著把SQL 2005 sp2升級到sp4,卻發現升級精靈檢查鎖定檔案時,SQL Writer服務卻出現了!奇怪,難道我又誤入了什麼嗎? 查了一下文章,才發現SQL SQL 2005 上了 sp2後就會自動的啟動這項服務。原文如下:

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.

真是差點以為自己見鬼了...(筆記)

沒有留言:

張貼留言