One of my clients implemented Database Mirroring (SQL 2008 R2) in a high safety mode. The primary, mirror and witness are on three different servers. The DB code has a lot of cross DB references. So they are asking for an automated process to failover all the databases to mirror when atleast one database fails over. The automated process is not difficult to build. But wanted to get your ideas on any gotchas I should be aware of when doing something similar. Any thoughts are greatly appreciated.