Microsoft built the capability into windows allowing files to be backed up to disk while other programs are using those files.
The VSS Servicer interacts with the Windows Volume Shadow Copy service (VSS), allowing files that are in use, such as SQL Server data files, to be copied (or backed up) without stopping all other services accessing those files. If your server needs to backup your databases without taking the database offline, or using the SQL Server Backup Stream, then turn on the SQL Server VSS Writer service on your computer.
By default, this service is installed for all instances of SQL Server.
If your backup software is simply copying files from your disk to your backup device, be sure to turn this service on. Otherwise, set it to manual start-up.
No comments:
Post a Comment
If you have any doubt or question, please contact us.