Post reply

how often is data transferred to a mirror server?

  • July 7, 2008 at 9:19 am

    #184298

    is data transferred to a mirror server each time a transaction is committed on the primary or bulk upated at scheduled times?

    Also, what if i do an update outside a transaction. how is that mirrored to the mirror server?

  • July 7, 2008 at 10:03 am

    #839010

    Depends if you have synchronous or asynchronous mirroring.

    In synchronous mirroring, the data is transferred to the mirror and confirmed as hardened in the mirror's transaction log before the client is notified that the operation is complete.

    In asynchronous mirroring, the data is transferred to the mirror when it's modified on the principle, but the client is notified of completion immediatly, not waiting for a confirmation from the mirror.

    All inserts/update/deletes occur within a transaction. If you don't explicitly begin a transaction, the transaction starts with the update statement and is auto-committed.

    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

  • July 7, 2008 at 10:31 am

    #839036

    In addition, a few minutes spent reading : http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx may answer additional questions. It only takes a quick scan to answer some of the simple questions.

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

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