4

I have two databases that are mirrored to another server using database mirroring.

The mirror server has to be down for some reason for few days.

Now, the production server is having principal databases in (PRINCIPAL/DISCONNECTED) State.

Clients can access those databases.

Questions

  • So what happens when they keep on adding data to these databases??
  • Will the data get committed or waits till the mirror comes up?
RolandoMySQLDBA
185k34 gold badges327 silver badges541 bronze badges
asked Apr 2, 2010 at 9:36
0

2 Answers 2

2

Your .LDF log is growing, as it cannot be truncated because the mirror is unavailable. Eventually you'll run out of space unless you either break the mirroring or bring the mirror back online.

answered Mar 9, 2012 at 4:12
1
  • Absolutely correct, you need to remove the mirroring and re-initialize the mirror copy when the server becomes available again. Commented Mar 9, 2012 at 21:45
1

The transactions will be committed on the principle. When the mirror is up again, it will take more time to synchronize.

answered Jan 13, 2011 at 17:36
1
  • This is a valid option if the mirror is down for a small amount of time, but spanning days on a busy database is probably a bad idea. Commented Mar 9, 2012 at 21:46

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.