Availability group

  • Looking for the options whenever the primary replica is refreshed then synching the secondary replica would need to be done and which would take long time if there are more that 1 secondary replica's. Checking to see is there a faster way to sync the secondary replica after the primary replica refresh? Thanks in Advance!

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • sqlguru wrote:

    Looking for the options whenever the primary replica is refreshed then synching the secondary replica would need to be done and which would take long time if there are more that 1 secondary replica's. Checking to see is there a faster way to sync the secondary replica after the primary replica refresh? Thanks in Advance!

    I'm sorry, can you explain this differently?

    Are you asking about the initial add of a database to the AG, and the options for creating the database on the secondary's? If so, typically the fastest way I have used is to restore the backups, apply the log backups, and add the DB's.

    If not, then can you please explain further?

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

  • I am wondering what is meant by 'refreshed' here.  If by refreshed you mean a database restore - then the quickest method would be to restore to all replicas at the same time from the same backups.  Bring the database online on the primary, add the database to the AG, and join the secondary replicas - which will all be at the same LSN because they were all restored from the same source.

    This would not require any log backups to be applied - unless those log backups are required to be applied to the primary to be it up to date.

    To prevent any issues - make sure you disable any automated log backups for the 'refreshed' database until all replicas have been added and synchronized.  If a log backup is run before you have joined the secondary replicas - those replicas will not successfully join until you apply the additional log backup(s).

     

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

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

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