June 21, 2008 at 4:37 am
Hi all,
In case of any mode of Database Mirroring either synchronous or asynchronous, are there any possibilities that at the time when principal server is online, we can use mirror server for read only query processing.
or is it like that only, that we can access only one database i.e either principal or mirror at any given time.
June 21, 2008 at 7:33 am
The mirror is always unreadable, but if you use Enterprise Edition you can create a snapshot of it and read from that.
June 21, 2008 at 7:36 am
As Matt suggested, go with the DB SNAPSHOT, insted of landing up with complex solutions to Simple problems.
Maninder
www.dbanation.com
June 21, 2008 at 8:35 am
Thank you very much, as in our case it is not possible as we are using workgroup edition.
Thanks a million.
June 21, 2008 at 2:21 pm
Keep in mind if you did move to database snapshots that the snapshots are point in time and don't keep up with changes to the primary.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply