question

jhunu avatar image
jhunu asked

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
backupalways-onsecondary
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

jhunu avatar image jhunu commented ·
Thanks for the answer. My question is is it possible to have point in time recovery using Copy only backup and Tlog backup from Secondary replica in alwayson.
0 Likes 0 ·

1 Answer

·
Tom Staab avatar image
Tom Staab answered
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.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.