Post reply

Moving an excrypted Database with always on to SQL Standard Edition

  • January 13, 2020 at 10:28 pm

    #3715090

    Hi Guys

     

    Have got a request to move a database from SQL Enterprise Edition to SQL Standard Edition both SQL 2017

     

    The Database will be encrypted and part of an always on Configuration.

    I know sql standard edition does not support encryption so believe I will have to break the

    always on configuration and the encryption before backing up then reinstate the encryption and always on, unless someone

    has any suggestions.

    Has anyone had to do this.

    Thanks

  • 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 3 posts - 1 through 2 (of 2 total)

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