Post reply

Principal and Mirror server

  • May 17, 2016 at 12:48 am

    #310648

    Hi Guys,

    I have 2 servers in production, let’s say A and B

    A is principal and B is Mirror server . ( Database MIRRORING)

    1.If I stop the mirroring process and insert data in table Mirror server and continue mirroring process , will it synchronize to the principal ?

    2.If I change record with different value ( for the same record ) in principal and mirror server , which one will win ?

    Thank you

    Any feedback are highly appreciated

  • May 17, 2016 at 4:13 am

    #1879431

    You can't edit data in mirror db, so booth questions: not aplicable.

  • May 17, 2016 at 6:38 pm

    #1879725

    Thanks for the reply , I mean I stop the MIRRORING process first before I insert/change data

  • May 18, 2016 at 2:32 am

    #1879760

    You can't edit data in mirror db. If you disable the mirroring session and bring db online then there is no mirror 🙂

  • May 18, 2016 at 3:00 am

    #1879765

    WhiteLotus (5/17/2016)

    Thanks for the reply , I mean I stop the MIRRORING process first before I insert/change data

    By stop you mean pause the synchronisation or completely drop the mirroring?

    If the first, then the previous reply stands, mirror databases are not accessible at all.

    If the second, then there's no mirroring to resume as you've dropped it entirely, you have two separate databases at that point.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 19, 2016 at 12:55 am

    #1880098

    Hi Gail ,

    Thanks for the reply !

    I mean pause the mirroring process and insert data to mirror database . So if I want to insert data to Mirror database , I need to insert from Principal server and Continue mirroring afterward ( I hope data will be synchronize from principal to mirror )

    Am I right ?

    Thank you

  • May 25, 2016 at 11:36 pm

    #1881486

    Any feedback about this?

Viewing 7 posts - 1 through 6 (of 6 total)

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