Post reply

Moving an excrypted Database with always on to SQL Standard Edition

  • January 14, 2020 at 12:48 pm

    #3715191

    Do you have enough space on one of the AG nodes to restore a copy of the database?  You don't want to break the AG if you can help it as that's your HA/DR solution so if you have enough space or can add enough space (even if its temporary) that would be the preferred option to go down.

    Then restore it, remove encryption, double check your not using any Enterprise only features, backup, restore to Standard edition.

  • January 14, 2020 at 9:11 pm

    #3715417

    Thank You

    Will take a look - see if that will work.

     

     

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

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