SolarWinds Backup Help

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 of 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 Backup Manager configuration file.
  2. Perform a backup.
  3. Change the value of the UseCopyOnlySnapshot parameter to 0 or remove the parameter from the file altogether.