OctopusDeploy/Library — pull request #85 by CaioProiete (2014-09-28 03:41:27+00:00)
Title: Update SQL Backup Database template to initialize the backup

This is a one line change (line 95), so that SQL Server initializes the backup file (i.e. start with an empty file):
$smoBackup.Initialize = $true

Without initializing, every time you backup to a filename that already exists, causes it to append the backup to the existing file - which is not what anybody wants.