Post reply

SQL 2008 mirroring questions

  • April 18, 2012 at 6:07 am

    #255040

    Hi,

    I'm setting up a SQL2008 R2 mirroring for a production environment.

    At the moment we have configured a test env with two sql 2008 R2 instances on two different servers.

    Since I'm new on this I have the following questions on failover/failback:

    - we have made a configruation with witness so I suppose that if I take down the MIRRORED DATABASE on the principal the target should become active automatically.

    How do clients connection be redirected ? Do I need to change the connection strings ?

    - How do I failback ?

    thanks for the help

    SC

  • April 18, 2012 at 6:39 am

    #1475300

    sc_2111 (4/18/2012)

    if I take down the MIRRORED DATABASE on the principal the target should become active automatically.

    Loss of the Principal will indeed bring the mirror online, again, check Automatic Failover in Books Online for full info

    sc_2111 (4/18/2012)

    How do clients connection be redirected ? Do I need to change the connection strings ?

    you will need to ensure the connection string has the Failover Partner option and that the database connection supports this parameter.

    sc_2111 (4/18/2012)

    - How do I failback ?

    you may use either the GUi or a T-SQL ALTER DATABASE statement (see Books Online)

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

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

  • April 18, 2012 at 6:44 am

    #1475304

    Thanks , I found the info too late , I did post already

    Thanks for the patience

    SC

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

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