Querying mirrored database

by BeginnerDBA   Last Updated June 23, 2017 21:06 PM

I need to create a snapshot one of our mirror databases.

Have gone thorough couple of links and looks like querying can be achieved here by creating snapshot at mirror server.

However i would need your help in understanding this for DB in my case where its over than 16 TB's and used 365*7. Things like when you create snap files, how much extra storage would be required in setting this snapshot database.

As far as i can understand it should not be another 16 TB, apart from reserved 16TB of mirrored database. Also how would one ensure that snapshot is in sync with principal with acceptable refresh or lag period of 30 minutes?

please advise



Related Questions


SQL Snapshot Redirect

Updated June 17, 2018 11:06 AM


how do I get a listing of snapshot datafiles

Updated April 11, 2016 08:02 AM