Post reply

wht are the things we need to cosider afer database mirroring is configured

  • September 3, 2010 at 3:15 am

    #228652

    Hi All,

    we configured database mirroring.

    what are the things we need to consider after the mirroring is configured.

    when i use launch database mirroring monitor i can able to see two TABS,

    in that one among them is warning tab SET THRESHOLD button is there what is the use of that.how to set the thresholds .

    regards,

    anjali.

  • September 3, 2010 at 6:13 am

    #1216116

    It depends on what sort of mirroring you have setup, I would leave the thressholds alone unless you are experincing issues.

    One important thing to consider after implementing mirroring is to ensure that any application that connects to the databse is made 'mirror aware' this is easy enough in .NET as you can use FAILOVER PARTNER in the connection string. Other applications may take more work.

    Also you need to ensure that all your logins can access the mirror server and DB in case of failover as well as making sure your SQL Agent can handle a failover.

  • September 3, 2010 at 6:30 am

    #1216121

    In addition to the above...

    - Check that the Logins exist on the failover partner.

    - If you dont have a WITNESS server then consider this msdn article...

    http://msdn.microsoft.com/en-us/library/ms191449.aspx

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

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