Post reply

Schema Changes on SQL 2012 High Availability Group Databases

  • July 23, 2014 at 8:28 am

    #310295

    Hi

    So we have our HA group servers and databases, now we want to deploy schema changes to the HA group databases.

    1.) Can we deploy the changes to Server2.mydatabase whilst still having Server1.mydatabase available to users?

    2.) If yes, what is involved in doing so

    3.) If no, What is the best suggestions to apply schema changes to HA databases.

    Thanks

    James :ermm:

  • July 23, 2014 at 8:59 am

    #1731785

    Schema changes will get modified across in the same way as anything else. If you have to have users off one system to make the changes, you need them off both systems. If you can make the changes live, then you're good to go.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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