Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Grouped Failover, a 2008R2 version of Availability Groups

By Remko de Boer,

One of the new cool features in SQL 2012 is the SQL Server Availability groups. In other words being able to failover a group of databases which are logically connected. i.e. SharePoint databases. Well, it is also possible to do that in SQL 2008 (R2). It’s called a Grouped Failover. Instead of configuring it in SQL mirroring, you have to administrate the connected databases yourself and with a single stored procedure you will be able to failover a group of databases. It also gives you the option to failover a group of mirrored databases when the principal is down.

How to implement this solution

First run the script and it will create a database, 3 tables and a stored procedure. Of the 3 tables 2 of them need to be filled with configuration you desire or need. In the table tblFailoverGroups you create 1 or more failover groups. In the table tblFailoverGroupDatabases you need to add the databases that are linked to the failover group you just created. You can also add databases that are not mirrored, but have a logical connection to the failover group. These database will not failover since they are not mirrored.

Total article views: 468 | Views in the last 30 days: 6
 
Related Articles
BLOG

Connection Strings: Database Mirroring Failover Partner Setup & Sample Backup/Restore Preparation Script

  After having setup my first SQL 2008 R2 Enterprise (build level 10.50.1702) database mirror as Hi...

BLOG

Failover consederations on Database Mirroring

These topics will give you the brief idea of what happens behind the scenes during failover occurs i...

FORUM

Database mirroring failover with witness

Mirroring, Failover, Primary, Secondary, Witness

BLOG

"Failover Partner" keyword in connection string - Q&A

1. How to connect client to a Database Mirroring Session with failover aware A: add FailoverPartn...

BLOG

Handling Database Mirror Failover within an SSIS Package

Recently I was asked how to handle a Mirrored Database Failover within an SSIS package.  For those o...

Tags
grouped failover    
scripts    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones