September 20, 2011 at 12:06 pm
I want to switch Database Mirroring from asynchronous to synchronous mode.
Am I right in thinking that there is a possibility that the mirror database could be inconsistent with the Principle?
If so, would the best way forward be to break the mirror and then set it back up again to ensure consistency between the two databases?
September 20, 2011 at 3:45 pm
you can change the safety mode at any time. You wont lose data. there is no need to break and reestablish mirroring.
http://msdn.microsoft.com/en-us/library/ms191456.aspx
---------------------------------------------------------------------
September 21, 2011 at 3:58 am
You will not loose data as the data will sycn on mirrored server periodically, only concern during DR you might loose data.
"More Green More Oxygen !! Plant a tree today"
September 26, 2011 at 12:40 pm
muldocta (9/20/2011)
Am I right in thinking that there is a possibility that the mirror database could be inconsistent with the Principle?
No. If you are wondering whether it suffers from the same types of consistency problems Transaction Replication can sometimes suffer from Mirroring is not subject to those problems because no one can access the secondary databases to make edits directly.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply