Post reply

Swapping a server in a mirroring setup

  • November 1, 2011 at 8:00 am

    #259423

    We currently have a SQL 2008 Mirror setup, consisting of 3 VMs (Principal, Mirror, Witness)

    We want to swap out one of the VMs for a Physical Server. What's the best way to do this? My current thinking is this.

    1. Break the Mirror

    2. Re-setup the Mirror with the Physical Server and the original Principal

    3. Failover the Mirror so that the PHysical Server is the Principal (because the physical server is beefier)

    Ideally, we want the physical to always be the active server. Does it matter that in the properties of the DB in SSMS, the physical server would be configured as the Mirror? Should we do something about the connection string, which would have the VM as the primary and the Physical as the Mirror, meaning, should we reverse that?

    Thanks!

  • November 1, 2011 at 9:24 am

    #1401696

    Everything Ok up to here

    Steve-443559 (11/1/2011)

    3. Failover the Mirror so that the PHysical Server is the Principal (because the physical server is beefier)

    Just install the database onto the physical server as the principal then set vm up as a mirror.

    Steve-443559 (11/1/2011)

    Ideally, we want the physical to always be the active server.

    it wont be if you ever have a failover though!!

    Steve-443559 (11/1/2011)

    Does it matter that in the properties of the DB in SSMS, the physical server would be configured as the Mirror? Should we do something about the connection string, which would have the VM as the primary and the Physical as the Mirror, meaning, should we reverse that?

    Thanks!

    When using the SQLNative client or ADO.NET there is a FailoverPartner connection string option otherwise failover is a manual operation in respect to application connectivity

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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