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
 SQL Server 2008 Forums
 High Availability (2008)
 Database Mirroring failover

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

Posted - 2012-11-09 : 16:51:52
You need SQL Server 2012! Availability Groups feature handles this scenario perfectly. Any chance you can upgrade to 2012?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

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

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-11-12 : 00:40:23
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.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

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

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

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 Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.
Go to Top of Page

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

Go to Top of Page

aspeckman
Starting Member

10 Posts

Posted - 2013-11-20 : 11:46:39
Here is another one that walks you through it.
http://mrsql.wordpress.com/tag/database_mirroring_state_change/
Go to Top of Page
   

- Advertisement -