SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 Database Mirroring failover
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Sarath_Aluri
Starting Member

USA
10 Posts

Posted - 11/09/2012 :  16:00:43  Show Profile  Reply with Quote
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

USA
35940 Posts

Posted - 11/09/2012 :  16:51:52  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

USA
10 Posts

Posted - 11/10/2012 :  19:33:19  Show Profile  Reply with Quote
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

USA
35940 Posts

Posted - 11/12/2012 :  00:40:23  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

USA
10 Posts

Posted - 11/18/2012 :  11:12:17  Show Profile  Reply with Quote
Done.. I created a Script which does this. Thanks for your help Tara.
Go to Top of Page

SQLCrazyCertified
Starting Member

6 Posts

Posted - 11/20/2012 :  08:45:02  Show Profile  Reply with Quote
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

India
193 Posts

Posted - 11/11/2013 :  12:12:35  Show Profile  Reply with Quote
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

USA
10 Posts

Posted - 11/20/2013 :  11:14:54  Show Profile  Visit aspeckman's Homepage  Click to see aspeckman's MSN Messenger address  Reply with Quote
Its right here.
http://technet.microsoft.com/en-us/library/dd207312(v=office.12).aspx

Go to Top of Page

aspeckman
Starting Member

USA
10 Posts

Posted - 11/20/2013 :  11:46:39  Show Profile  Visit aspeckman's Homepage  Click to see aspeckman's MSN Messenger address  Reply with Quote
Here is another one that walks you through it.
http://mrsql.wordpress.com/tag/database_mirroring_state_change/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000