Post reply

How do I compare principal and mirror server ?

  • November 9, 2016 at 6:06 pm

    #315530

    Hi All ,

    I configured mirroring in database servers – SQL 2008 R2 , status is synchronized . A few days after that someone did Failover ( part of disaster recovery exercise)

    I assume there will be no data loss – mirror server becomes principal server

    But my team reported there is a mismatch .

    How do I compare both servers ? As I can’t query in database- mirror server right now ?

    Any feedback are really appreciated

    cheers

  • November 10, 2016 at 6:16 am

    #1911634

    is this an asynch or synch mirror session, is there a witness present?

    What in particular are your team reporting a mismatch on?

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

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

  • November 14, 2016 at 7:24 pm

    #1912378

    sync and no mirror

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

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