Performing a SQL Server Copy-Only Backup Operation

A copy-only backup is a backup, which is independent of the sequence of regular Full backup.

When you run a log backup after a copy-only full backup, the log backup is automatically chained to the copy-only full backup and follows the retention rules of the copy-only full backup. If there are any missing logs during the log backup, the next backup operation is automatically converted to a regular full backup.

This type of backup can be performed for a special purpose and does not affect the overall backup and restore procedures. It applies to Full backups only.

Procedure

  1. From the navigation pane, go to Protect > Databases.

    The Overview page appears.

  2. On the Instances tab, click the SQL instance.

    The instance page appears.

  3. On the Subclients tab, in the row for the subclient that you want to back up, click the action button action_button, and then select Backup.

    The Backup options dialog box appears.

  4. Select Full backup, and then move the Copy-Only toggle key to the right.

  5. Click Submit.

Loading...