Secondary server to change the another location?

  • Hi,

    The following database HA already configured

    Primary server

    SQL SERVER 2008 R2 64 bit,

    HA: Database mirroring

    Witness: Not configured

    Mirror Mode: High Performance

    Failover: manual

    Backup: Every 30 min Transaction Log backup configured in principal server

    When move the secondary server to change another location then what are steps need to be follow on primary server? IP address and server name will be remaining same after moving the secondary server.

    1.Just pause the mirroring session in primary server when shutdown the secondary server

    2.Re-start the mirroring session after placed secondary server to another location; duration may be 8 hrs will take for placing another location.

    Please confirm these steps are sufficient?

    Thanks

    ananda

  • are you asking how to failover to the mirror database?

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

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

  • pausing not strictly necessary but yes those are the steps. Take a log backup just before you start.

    The log of the primary will fill whilst the secondary is down so just make sure you have enough log space. If you run out of log space you will have to remove mirroring.

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

  • I am just asking secondary server movement to another location which was configured database mirroring setup?

    what are the steps need to follow during movement activity? suggestion Pls.

  • Perry, can you confirm my post is visible please?

    🙂

    Ananda, if it is, see my post

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

  • george sibbald (10/16/2013)


    Perry, can you confirm my post is visible please?

    🙂

    Ananda, if it is, see my post

    your post is visible :hehe:

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

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

  • phew, thank lord, thought it was just me

    cheers.

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

  • Mr. george sibbald your replay is most valuable..Pl. Do't mistake me, I am reply the Mr. Perry question

    Perry Whittle (10/15/2013)


    are you asking how to failover to the mirror database?

    Thanks

  • are you clear on the steps?, what you suggested is ok.

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

Viewing 9 posts - 1 through 8 (of 8 total)

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