| Author |
Topic |
|
Sarath_Aluri
Starting Member
10 Posts |
 Posted - 2012-11-09 : 16:00:43
|
| 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. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Sarath_Aluri
Starting Member
10 Posts |
Posted - 2012-11-10 : 19:33:19
|
| 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 ? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Sarath_Aluri
Starting Member
10 Posts |
Posted - 2012-11-18 : 11:12:17
|
| Done.. I created a Script which does this. Thanks for your help Tara. |
|
|
|
SQLCrazyCertified
Starting Member
6 Posts |
Posted - 2012-11-20 : 08:45:02
|
quote:
Originally posted by Sarath_Aluri
Done.. I created a Script which does this. Thanks for your help Tara.
Sarath,Do you mind sharing the script which you created?Thanks,SueTons. |
|
|
|
sgondesi
Posting Yak Master
200 Posts |
Posted - 2013-11-11 : 12:12:35
|
quote:
Originally posted by SQLCrazyCertified
quote:
Originally posted by Sarath_Aluri
Done.. I created a Script which does this. Thanks for your help Tara.
Sarath,Do you mind sharing the script which you created?Thanks,SueTons.
hai.iam srikar.did he share the script with you?-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc. |
|
|
|
aspeckman
Starting Member
10 Posts |
Posted - 2013-11-20 : 11:14:54
|
| Its right here.http://technet.microsoft.com/en-us/library/dd207312(v=office.12).aspx |
|
|
|
aspeckman
Starting Member
10 Posts |
|
|
|
Database Mirroring failover