A couple of weeks ago when I was in Portland, one of the attendees asked a question about mirroring that I had not heard before. I thought about it for a few seconds and my gut was correct, but I needed to check it out. Here is the Question....
"If Server A (the Principal) has two databases on it that are being mirrored to Server B (the Mirror) and these two databases are tightly coupled (one has some SPs that reference objects in the othe db), and one of the databases fails over, but the other does not, what happens?"
"The short answer is that it breaks" - However there is someting that can be done. When a database fails over, it fires an event that may be captured and coded to make the other one failover too. I spoke with a trusted friend about this and they had actually coded this for a customer. So it does break, but it can be worked around.
I enjoyed seeing everyone at the Road Shows last week in Portland and Seattle. There will be a flurry of these shows over the next 7 weeks leading up to the PASS Community Summit on September 27. Visit www.sqlpass.org for more details.