LLI Wiki — My Digital Knowledge Base

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

SQL Server VSS Writer service stopped

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.

Mastodon LLIMastodon SocialFosstodon