So a thread I started a while back really got me questioning the basis from how we've configured our setup for disaster recovery, and I'm really starting to think it's flawed, or at least can be ...

We've had SQL 2005 mirroring running successfully for a while now, but the issue I have is our applications reference the primary server by name directly and when the mirror fails over to box #2 I'm ...