November 30, 2011 at 10:58 am
I had a database set to high safety, synchronous mode without a mirror. The server containing the mirror went down, and caused the principle database to become read only. Every article I've read, it says that the mirror database becoming unavailable, should have no affect, except the principle database will run exposed. This is not the behavior I experienced. The principle database became read-only and no updates/inserts/deletes could take place.
High safety, synchronous mode means that a transaction needs to be committed on both the mirror and the principle. If the mirror becomes unavailable in the middle of a transaction, could it possibly cause an outage on the principle, since it wasn't committed on both?
Ideas?
November 30, 2011 at 12:00 pm
It is a SQL Server 2008 Enterprise SP2 server.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy