• aledavsanort - Tuesday, January 23, 2018 6:30 AM

    Backups of availability databases participating in availability groups can be conducted on any of the
    replicas.

    Except differentials, they are not supported on secondarys

    aledavsanort - Tuesday, January 23, 2018 6:30 AM


    Although backups are still supported on the primary replica, log backups can be conducted
    on any of the secondaries. Log backups completed on all replicas form a
    single log chain.

    This is correct

    aledavsanort - Tuesday, January 23, 2018 6:30 AM


    As a result, the transaction log backups do not all have to be performed on the same replica.
    This in no way means that serious thought should not be given to the location of your backups. It is
    recommended that you store all backups in a central location because all transaction log backups are
    required to perform a restore in the event of a disaster. Therefore, if a server is no longer available
    and it contained the backups, you will be negatively affected.

    Serious thought should be given to the location of backups for Availability Groups as they should ideally be centrally stored.
    This is thankfully made easier with Cluster Shared Volumes in Windows Server Failover Clusters and SQL Server 2014 onwards

    aledavsanort - Tuesday, January 23, 2018 6:30 AM


    Can i make a full backup for the primary database and it will let me make transaction logs in the secondaries?

    yes, you can. The secondarys have to be enabled for backup operations in the Availability Group config

    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? 

    what exactoly do you mean here, it's unclear

    aledavsanort - Tuesday, January 23, 2018 6:30 AM


    It creates a log chain, but it doesn't explain how the log chain works, what happens if i want to restore the primary database to a point in time? i got the full backup of the main database, how would i use these log chain backups made in the secondaries, will the primary allow the use of transaction logs made from another database engine to be used in it?

    same as you would any log backups, use a complete chain to roll the database forward

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉