SQL Enterprise 2017 Mirror Database Snapshot issue

  • jcl2399 - Wednesday, November 15, 2017 1:10 PM

      The only issue is the Snapshot is not updating the transactions being held at the mirror level. 

    That's exactly as it should work. It's a *snapshot* of the database as of the time that it was created. It's static, read-only and unchanging.

    I suspect you may be mis-reading the documentation. As the source database gets changed, so the old version of the pages are written into the snapshot (that's the 'update' process), keeping it as of the time it was created.

    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 post 1 (of 2 total)

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