Question Regarding Database Mirroring Operating Modes
Lincoln Burrows ~
Modified: April 16th, 2016 ~ ~ 1 Minute Reading
- This topic has 4 replies, 5 voices, and was last updated 8 years, 7 months ago by .
Viewing 5 posts - 1 through 5 (of 5 total)
-
Posts
-
It depends on two factors: mirroring mode and if the data is getting explicitly commit or implicitly…. The application will read only the committed data.
It depends on the modes if it is full safety mode Principal server will work until log file full because in safety mode the transaction wait for acknowledge from mirror to commit so the log file will grow quickly at the time.
If a mirror server fails then transaction will run as usual on principle. Only that mirroring will break.
Barry given the correct answer for this question. Principal Server works as usual (status like principle/disconnected) transaction will be running on principal only it won’t reflect on mirror DB.
Viewing 5 posts - 1 through 5 (of 5 total)
- You must be logged in to reply to this topic.