Post reply

DB Mirroring transactions

  • September 4, 2014 at 4:41 am

    #295921

    Hi Guys

    In a miroring & log shipping setup what are the queries applied to mirror/secondary databases?

    eg. If we run alter index in principal database does sql server run the same on mirror database? Also what would be the case for below

    Backup database ,Update Stats.

    I googled but I am unable find information on this. Hoping to get answers from you. Thanks for your time.

    Cheers

    Vinoth

  • September 4, 2014 at 4:48 am

    #1743137

    Every single data modification is applied to the secondary.

    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

  • September 4, 2014 at 6:13 am

    #1743162

    everthing will be transferred, be it schema change or DML/DDL/DCL operation.

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

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