Thanks Robert, much appreciated...

Anyone?

Did anyone have any thoughts on this?

Yeah latency sounds like a possible culprit!

It looks like our apps are not handling the database freeze very well when it's in limbo.

Do you think the principal freezes when...

I understand the 2 phase commit, and usually this is fine when the connections are up, however if the mirror is down then I believe the principal will just build...

Thanks for the continued help.

The principal and mirror databases are both in data centres connected together over a VPN over a 100mb Internet connection (tier 1).

The sites Are...

Did you have any thoughts on this last question Perry?

Your help is really appreciated.

Thanks again

Thanks

I have another question if I may?

If we have the system running as normal (not paused), and the principal and Witness lose connection with the mirror server (Firewall fails at...

Perry Whittle (9/19/2011)

---

Yes it should, because you wiped out the witness...

Perry Whittle (9/19/2011)

---

yes, if you want to take the mirror down for a maintenance op or some other business reason then this is what the pause is for. If you...

I understand what you are saying, I'm just confused as I thought pausing the mirroring would have basically disabled eveything, leaving the principal database unaffected and accessible.

What does the "pause"...

Does the order that I take things down matter then?

Surely if I pause the...

Thanks for the fast reponse - much appreciated!

I paused the mirror as I was taking the firewall at the principal site down for maintenance.

With the firewall down, the witness and...