Post reply

Does querying a mirror snapshot access the principal?

  • June 20, 2014 at 2:15 am

    #290206

    Hi

    Would someone kindly confirm that querying a snapshot created on the mirror side of a mirrored pair of databases accesses or not accesses the principal when retrieving the unchanged data pages?

    I'm fairly convinced the principal is not touched at all by any snapshot queries.

    Thanks in advance

  • June 20, 2014 at 2:19 am

    #1723487

    It accesses the mirror DB.

    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

  • June 20, 2014 at 2:26 am

    #1723490

    Thanks very much for the quick reply Gail.

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

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