We have a application which creates 5 databases while installation. I set the Database mirroring for all the 5 databases on a different server. We are testing the failover scenarios. If the SQL service is stopped on principal then all the DB's will be failed over which is what the app needs. So if one of the DB's is failed over then the app doesnt work. My question is.. IS there any way to failover all the DB's in the named instance if one is failed ? we need to schedule a job for this.
Hi Tara, Thanks for the response. We are using 2008 R2. I am not sure if we can upgrade it to 2012. Is there any other way we can do it on 2008 Like may be an SP or a SQL ?
It would need to be done with custom scripts. I'm not sure that I've ever seen scripts written to do this yet, so you probably will need to roll your own.
Database Mirroring failover
Posted - 11/09/2012 : 16:00:43
