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.
Procedure to 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: