August 6, 2015 at 9:16 am
Proposed configuration:
Using a centralized backup server from which to run SQL backups. (this server is not part of this AVG)
AVG with backup preference set to primary.
SQL backup (daily full and hourly logs run from centralized backup server) with target set to AG Listener name.
Any opinion on whether or not this sufficient? Any failover should still target Primary Replica.
Thanks,
S Morrison
August 6, 2015 at 9:41 am
Being an Availability Group, you can also take backups from the replicas. Transaction log backups should still come from the primary replica, as this is the only way to clear out inactive entries in the transaction log file.
The BACKUP DATABASE command requires the COPY_ONLY flag when you back up from the replicas. The difference between a COPY_ONLY full backup and a normal one is that the COPY_ONLY backup will not reset the differential base. If you're not taking differential backups, then this is not really a concern.
-Eddie
Eddie Wuerch
MCM: SQL
August 6, 2015 at 10:34 am
Eddie Wuerch (8/6/2015)
Transaction log backups should still come from the primary replica, as this is the only way to clear out inactive entries in the transaction log file.
This is incorrect, a transaction log backup against a secondary will truncate the log on the primary where applicable.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply