Copy Only backup in secondary for point in recovery
Can we use Copy only backup and T log backup to restore a database to point in recovery in always on. I have an always on setup. I did an copy only backup and tlog backup on secondary. and tried to restore it on another server will one copy only backup and all log backups. please advice
Yes, you can perform a point-in-time restore from a copy_only backup. The copy_only flag only matters for the source database to not interrupt your regular maintenance process flow. In other words, it will not reset the baseline for differential backups. To perform the backup on the secondary, you need an active secondary (i.e. configured to be readable) on an availability group configured to support backups from the secondary. Then the database and log backup files can be restored to another server without any concern whether or not they were done using the copy_only option.