Copy-only backups for MS SQL

Backup Manager supports copy-only backups of MS SQL databases. Unlike regular backups, copy-only backups do not make any changes to the database and do not interfere with the normal sequence (Full / Incremental or Full / Differential) of database and log backups (visit MSDN Library to learn more). You can restore copy-only backups in the same way as regular backups.

To perform a copy-only backup, do the following:

  1. Add UseCopyOnlySnapshot=1 to the [MsSql] selection of the Backup Manager configuration file (config.ini)
  2. Stop and restart the Backup Service Controller from Services Console (services.msc)
  3. Perform a backup

To switch from performing copy-only backups to performing full backups, you need to:

  1. Change the value of the UseCopyOnlySnapshot parameter to 0 or remove the parameter from the configuration file (config.ini) altogether
  2. Stop and restart the Backup Service Controller from Services Console (services.msc)