locked
test the content of the mirrored database while principal is online RRS feed

  • Question

  • Folks,

    i am wondering if there is any way to test the content of the mirrored database while keeping the principal online.

    if i paused the mirror can i mount the mirrored database and inspect the content?

    if yes, can i resume the mirroring without affecting the solution?


    Samer F. Mustafa Microsoft Technical Team Leader. sf_mustafa@hotmail.com

    Wednesday, January 20, 2016 12:56 PM

Answers

  • Hi,

    Normally since mirror DB is in restoring state you cannot do anything on it. To use a mirror database for reporting, you can create a database snapshot on the mirror database and direct client connection requests to the most recent snapshot. A database snapshot is a static, read-only, transaction-consistent snapshot of its source database as it existed at the moment of the snapshot's creation. To create a database snapshot on a mirror database, the database must be in the synchronized mirroring state.

    Please read Snapshot on Mirror databases

    Creating snapshot on Mirror Database

    Remember snapshot is enterprise feature


    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Wiki Articles

    MVP


    Wednesday, January 20, 2016 1:03 PM