Post reply

Backup Jobs on Availability Groups

  • February 11, 2015 at 7:11 am

    #398009

    Hi All,

    we currently use Backup Scripts from Ola Hallengren, It Says Full (non copy-only) and differential backups are performed on the primary replica. Full(Copy-only) backups and transaction log backups are performed on the preferred replica

    we currently do FULL(COPY_ONLY) Backup everyday and LOG Backups for every 15 min, is there any performance benefit on running the FULL (non copy-only) on the preferred replica ..

    Thanks for all your help

  • February 11, 2015 at 7:25 am

    #1776931

    your questions not clear, typically you may offload backup operations to secondary databases.

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

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

  • February 11, 2015 at 7:35 am

    #1776935

    You can't run a non-copy_only backup on anything other than the primary replica. Only copy_only backups (and log backups) can be run on the preferred replica.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 11, 2015 at 7:41 am

    #1776937

    Thank you so much.. Appreciate your response

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply