Creating a copy-only backup (legacy SQL Server policies)
Any backup can be created as copy-only. An Instant Recovery backup is automatically created as copy-only. For legacy SQL Server policies, set the COPYONLY TRUE setting in the backup batch file. For SQL Server Intelligent Policies, enable on the Microsoft SQL Server tab.
See About tuning parameters for SQL Server backups.
To create a copy-only backup
- Open an existing batch file in a text editor.
- Insert the following:
COPYONLY TRUE
- Save the batch file.