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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 DB Mirrors and SP's that reference them

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 - Principle
DB2 - Principle

....

DB1 - Switches to Mirror
Db2 - Stays Principle

There 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"
Go to Top of Page
   

- Advertisement -