Skip to main content
How to enable a SQL native (copy-only) backup
Updated over a week ago


A copy-only backup is a SQL Server backup that is independent of the sequence of conventional SQL Server backups. It does not affect the sequencing of regular log backups. Hence, it prevents log chain broken issues from occurring on Hybrid Workloads.

Procedureto create a copy-only backup by using SQL Server Management Studio

Note: It is recommended to create a new maintenance plan and use the copy-only option during the creation process. Only changing the job to copy-only in the existing plan might not help in certain scenarios.

  • Create a new maintenance plan

  • Check the copy-only option:

  • Ensure that all the databases that are configured on Phoenix which might get affected are selected under Databases section:

See also

Did this answer your question?