PROBLEM

CAUSE

Since Altaro uses Microsoft Shadow Copy tasks to backup VMs, it will only trigger a Database Backup, not a Database Log Backup, thus transaction logs will only be truncated when Altaro runs a backup if you select the Simple Recovery Model for your SQL databases.

SOLUTION

Simple recovery model

Under a Simple Recovery Model, SQL will truncate the transaction logs when a Shadow copy is taken. This happens when Altaro requests a Shadow Copy from the MS Hyper-V VSS writer, this then cascades the shadow copy task into the guest VM and the MS SQL VSS writer will kick off a Database backup, This process will truncate the transaction logs, assuming of course that the SQL VSS writer is installed and enabled.

Full or Bulk Logged recovery model

Under the Full or Bulk Recovery Model the transaction logs are not truncated until a Database Log Backup has been completed. An Altaro backup is not considered a Database Log Backup. If the Full or Bulk Recovery Model is required, using the Microsoft SQL Management Studio to schedule a Transaction Log Backup Task will be required to maintain the Transaction Log size.

Note: This is not a best practice on how to set up a SQL server but an explanation of how Altaro interacts with SQL and its different recovery models.