Backups of availability databases participating in availability groups can be conducted on any of the
replicas.
Perry Whittle
Except differentials, they are not supported on secondarys
How would someone backup the database the proper way then? full backups and transaction logs all the time?
By proper way i mean: Full backup > Differential > Log
aledavsanort - Tuesday, January 23, 2018 6:30 AM
So.. if i make a full database backup in my primary it will allow me to make transaction logs in the secondaries? if so.. i can apply the transaction logs to the primary?
Perry Whittle
what exactoly do you mean here, it's unclear
If i make a full backup on the primary database and the transaction logs in the secondary database, the transaction logs could be applied to the primary database to go to a point in time?
Everything falls if i can't make the differential backups in secondary replicas, i tought it would be a good idea to have the secondary replica make the full > differentials > log backups so we could put less pressure in the primary replica.
That's how it is and it's by design
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉