SQL Clone
SQLServerCentral is supported by Redgate
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: 548 | Views in the last 30 days: 1
Related Articles

Connecting to Azure SQL Database Primary Endpoint – Failover Groups

When you have setup a Failover Group in Azure for your SQL Databases connecting to the R/W (Read / W...


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...


Failover consederations on Database Mirroring

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


Database mirroring failover with witness

Mirroring, Failover, Primary, Secondary, Witness


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

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

grouped failover