locked
Database Mirroring RRS feed

  • Question

  • Hi all,

    The mirroring session is synchronous mode(without witness), in synchronous mode log records are committed into mirror server then mirror server send acknowledgement to principal server. In case first log records are committed into mirror server, the mirror server does not send acknowledgement to principal server, this type of situations what happens database mirroring. can any one explain it?


    Raveendra

    Tuesday, May 8, 2012 6:08 AM

Answers

  • Hi Ravi,
    In this situation transaction is not commited.

    On the other hand, if mirror server is not avilable at all, SQL would perform only local commit and this is called as "exposed" state. You should see "suspended" http://msdn.microsoft.com/en-us/library/ms189284.aspx


    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog | Team Blog | @Twitter

    Tuesday, May 8, 2012 7:06 AM

All replies

  • Hi Ravi,
    In this situation transaction is not commited.

    On the other hand, if mirror server is not avilable at all, SQL would perform only local commit and this is called as "exposed" state. You should see "suspended" http://msdn.microsoft.com/en-us/library/ms189284.aspx


    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog | Team Blog | @Twitter

    Tuesday, May 8, 2012 7:06 AM
  • Hi Balmukund,

    Thanks for your response. I have one Question, give me some reasons why mirror database goes into suspended state and what are redo errors on mirror server?


    Raveendra

    Saturday, May 12, 2012 7:49 AM