Post reply

Database Mirroring

  • December 7, 2009 at 5:22 am

    #140440

    Hi,

    I would like to see the updated changes in the mirrored database that the change i made in principal.

    so i stopped mirroring. The mirrored database is in norecovery mode.

    how can i see the changes in mirrored server. any way to see the data?

    Note: Two instances have been created on the same server for db mirroring and implemented mirroring.

  • December 7, 2009 at 5:39 am

    #1088454

    Hi

    I would restart your mirroring.

    The easiest way to check that the mirror is being updated in to use the sql database mirroring monitor. (this will tell you if the databases are syncing and synchronised.

    If you actually want to see that the data exist in the mirror then best thing to do is failover the principle

    ALTER DATABASE ????? SET PARTNER FAILOVER

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

  • December 7, 2009 at 6:24 am

    #1088473

    You can also create a database snapshot on the mirror to avoid failover - if you're on Ent or Dev edition.

  • December 7, 2009 at 6:29 am

    #1088479

    By Stopping mirrorring you will not be able to see the changes.

    To see the changes.

    1.Make note of the changes you want to see.

    2.Failover the mirroring, now you should see the original principal server as mirrored and the mirrored server as principal,synchronising.

    3.Check for the changes in the new principal server.

    Pavan.

  • December 7, 2009 at 8:22 am

    #1088582

    Thanks for the replies...

    let me try to do fail over mirroring....

    Thank you once again...

    Regards,

    Chandhini

  • December 7, 2009 at 11:29 pm

    #1089034

    Thank you SQL Expertise..

    i tried Mirroring failover to verify the data is updated in mirrored database.

    it has come:-)

  • March 31, 2012 at 4:16 am

    #1467288

    Hi,

    One of our company client has already configured the mirroring but there is no witness server so i want to confirm if the principle server goes down or damaged then will it changes the mirrored server to principal server?

    Thank you.

  • March 31, 2012 at 6:26 am

    #1467298

    farrukh635 (3/31/2012)

    Hi,

    One of our company client has already configured the mirroring but there is no witness server so i want to confirm if the principle server goes down or damaged then will it changes the mirrored server to principal server?

    Please don't post the same question in multiple places. No replies to this please. Replies to: http://www.sqlservercentral.com/Forums/Topic1276157-146-1.aspx

    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

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

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