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 Copy-only backup 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.

Creating a copy-only backup (legacy SQL Server policies)

Feedback

Feedback