Post reply

Restore DB which are part of Always On SQl 2016

  • August 30, 2019 at 5:00 pm

    #3675791

    Hello!

    I have databases on Primary Node which I need to restore.

    Is there any other options beside this?

    1. Delete DB from Availability Database group.
    2. Restore Primary.
    3. Restore Secondary with Full+T-log backup from Primary.
    4. Add DB to the AG.

    Step 3 can be replaced with automatic seeding but this seems to be taking longer than backup and restore.

     

    My question is there way where I can Restore Primary and Secondary Node from same backup and then later sync those?

    How does join come into play?

     

    Thanks in advance.

     

  • August 31, 2019 at 5:10 pm

    #3676061

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

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

  • August 31, 2019 at 5:27 pm

    #3676067

    No, you can't restore from the backup, aFAIK.

  • September 1, 2019 at 2:16 am

    #3676113

    Yes,  you can restore from the same backup to both the primary and secondary.

    Remove the database from AG, disable transaction log backups for that database on primary, restore to primary with recovery, restore to secondary with no recovery, use join only option to sync, restart log backups.

     

     

    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