VM backups and SQL Server: the VSS Writer role
How a virtual machine backup affects SQL Server databases, depending on the state of the SQL Server VSS Writer service.
A virtual machine backup that takes a snapshot of the server can interact with SQL Server database files. The behaviour depends on the state of the SQL Server VSS Writer service.
SQL Server VSS Writer service running
- I/O on the data files is frozen while the snapshot is created.
- The VM backup includes a full backup of each database.
- The SQL Server instance is not locked, but the backup can slow it down.
SQL Server VSS Writer service stopped
- The database files are not included in the VM backup.
- The databases must then be backed up by other means.
- The VM backup can still affect SQL Server performance.
Recommendations
A full backup included in the VM backup can break the backup chain maintained by the DBA. In that case, back up the databases more often than once a week, and back up the transaction log as well. Discuss this with the DBA before setting up VM backups.