locked
database administrator (core DBA) RRS feed

  • Question

  • hello sir,

    my self chandrika..

    If mirroring got failed. How do i know, and what alerts will get ? will please clarify my doubt.

    • Moved by Tom Phillips Thursday, January 30, 2014 3:46 PM Database mirroring question
    Thursday, January 30, 2014 3:18 PM

Answers

  • As already suggested their could be many reason for failures, few you can search on below:

    http://technet.microsoft.com/en-us/library/ms190913.aspx

    http://technet.microsoft.com/en-us/library/ms189127.aspx


    Please click the Mark as answer button and vote as helpful if this reply solves your problem

    • Proposed as answer by Ramesh Babu Vavilla Friday, January 31, 2014 7:03 AM
    • Marked as answer by tracycai Tuesday, February 4, 2014 2:42 AM
    Friday, January 31, 2014 6:20 AM
  • If mirroring got failed. How do i know, and what alerts will get ? will please clarify my doubt.

    Hello Chandrika,

    There can me many reasons for mirror to fail.It can be due to mirror server not available ,network failure between principal and mirror.Log file getting full on primary server due to lack of transaction log backup.

    You can use mirroring monitor to see status,size of logs being sent .You have to manually configure alert for DB mirroirng

    Other very good option is to use Witness for automatic failover

    http://technet.microsoft.com/en-us/library/ms175191.aspx


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    • Proposed as answer by Ramesh Babu Vavilla Friday, January 31, 2014 7:03 AM
    • Marked as answer by tracycai Tuesday, February 4, 2014 2:42 AM
    Thursday, January 30, 2014 3:44 PM
  • check my blog for monitoring mirroring

    http://sqlservr.blog.com/2013/03/29/monotoring-sql-server-database-mirroring/


    Ramesh Babu Vavilla MCTS,MSBI

    • Marked as answer by tracycai Tuesday, February 4, 2014 2:42 AM
    Friday, January 31, 2014 7:04 AM

All replies

  • If mirroring got failed. How do i know, and what alerts will get ? will please clarify my doubt.

    Hello Chandrika,

    There can me many reasons for mirror to fail.It can be due to mirror server not available ,network failure between principal and mirror.Log file getting full on primary server due to lack of transaction log backup.

    You can use mirroring monitor to see status,size of logs being sent .You have to manually configure alert for DB mirroirng

    Other very good option is to use Witness for automatic failover

    http://technet.microsoft.com/en-us/library/ms175191.aspx


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    • Proposed as answer by Ramesh Babu Vavilla Friday, January 31, 2014 7:03 AM
    • Marked as answer by tracycai Tuesday, February 4, 2014 2:42 AM
    Thursday, January 30, 2014 3:44 PM
  • As already suggested their could be many reason for failures, few you can search on below:

    http://technet.microsoft.com/en-us/library/ms190913.aspx

    http://technet.microsoft.com/en-us/library/ms189127.aspx


    Please click the Mark as answer button and vote as helpful if this reply solves your problem

    • Proposed as answer by Ramesh Babu Vavilla Friday, January 31, 2014 7:03 AM
    • Marked as answer by tracycai Tuesday, February 4, 2014 2:42 AM
    Friday, January 31, 2014 6:20 AM
  • check my blog for monitoring mirroring

    http://sqlservr.blog.com/2013/03/29/monotoring-sql-server-database-mirroring/


    Ramesh Babu Vavilla MCTS,MSBI

    • Marked as answer by tracycai Tuesday, February 4, 2014 2:42 AM
    Friday, January 31, 2014 7:04 AM