Post reply

Changing database compatibility level in Availability Group

  • August 10, 2018 at 3:30 am

    #407843

    Hi folks,

    Looking to change the compatibility level of a database from 100 to 110 sitting in a 3-node Availability Group.  Was curious to know whether the compatibility level would be filtered through the group once changed on the Primary node, or (as i'm pretty sure I will need to do) I would need to remove the database from the Availability Group and then re-add it again after the change has been made.

    Thanks in advance.

  • August 10, 2018 at 5:26 am

    #2001177

    I was curious so I tried it, and it filtered straight through on my synchronous AG. Cool. (I changed from 140 to 130 and back again). No need to remove the database from the AG.

    The change was reflected in the error log of the primary node but not the secondary (which makes sense).

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

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