Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sbaustin
Starting Member
1 Post |
 Posted - 2010-02-09 : 10:46:59
|
| I have two DB's on a server that are both mirrored. On occasion, due to some network issue or timeout, one may switch to the mirror. The issue I have is that one of them references the other so in this scenario, I've got a mismatched principle/mirror. Is there anyway to force both db's to switch to the mirror if one of them does?DB1 - PrincipleDB2 - Principle....DB1 - Switches to MirrorDb2 - Stays PrincipleThere are some stored procs that reference each other that start to fail.Any ideas? |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2010-02-09 : 11:43:43
|
| That's what a cluster is really meant to do, not a mirror. You could "in theory" detect a wmi event that the mirror failed over and caused the other one to fail over..but now you're dealing in "spit & duct tape"Mike"oh, that monkey is going to pay" |
 |
|
|
|
|
|
DB Mirrors and SP's that reference them