principlesqlMinor
SQL Server 2012 always-on backup, full vs copy-only
Viewed 0 times
full2012sqlalwayscopyserveronlybackup
Problem
I need a quick clarification on copy-only backup vs full backup as it pertains to transaction log numbering and restore if required.
I have SQL Server 2012 setup with always on for multiple databases. The availability groups are setup with preferred backup on replica.
only copy-only and transaction log backups are possible on replica. Does this mean I will need to do a full backup on primary if a restore of the transaction log is required?
Thank you
I have SQL Server 2012 setup with always on for multiple databases. The availability groups are setup with preferred backup on replica.
only copy-only and transaction log backups are possible on replica. Does this mean I will need to do a full backup on primary if a restore of the transaction log is required?
Thank you
Solution
Does this mean I will need to do a full backup on primary if a restore of the transaction log is required?
NO -- You can add t-log backups to a restore of a COPY_ONLY backup
NO -- You can add t-log backups to a restore of a COPY_ONLY backup
Context
StackExchange Database Administrators Q#63946, answer score: 6
Revisions (0)
No revisions yet.