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, full Volume Shadow Services (VSS)-enabled backups, and full IntelliSnap backups.

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

From the CommCell Browser, expand Client Computers > client > SQL Server > instance.
Right-click the subclient, and then click Backup.

The Backup Options dialog box appears.
Select the backup type and job initiation:
1. In the Backup Type section, select Full.
2. In the Job Initiation section, specify whether to run the backup now or whether to schedule it.
  
  Note
  
  If you specify to schedule the backup, define the schedule.
  
  For information about scheduling backups, see Schedule Backups.
To have the software perform an integrity check, click Advanced. Then, in the Advanced Backup Options dialog box, on the Data tab, select the Copy-only check box, and then click OK.
Click OK.