Lot of exciting information trickling out of Microsoft on the upcoming "Denali" release. One of the most promising enhancement I came across today is in the area of high-availability and disaster recovery - HADR.
The core conecpt behind this feature is something called as "availability groups". Availability groups essentailly are a set of failover partners (DBs), known as availability replicas. Each availability replica possesses a local copy of each of the databases in the availability group. One of these replicas, known as primary replica, maintains the primary copy of each database. The primary replica makes these databases, known as primary databases, available to users for read-write access. For each primary database, another availability replica, known as a secondary replica, maintains a failover copy of the database known as a secondary database.
Following image helps explain the concept:
Here's a really good ste-by-step guide to configure HADR in Denali using Availability Groups: SQL Server Denali - AlwaysON (HADR): Step-by-Setup setup guide
I wonder if a SQL Azure instance is a supported secondary replica. Will post the result as soon as I get some time to try it out.
Cheers!!
The core conecpt behind this feature is something called as "availability groups". Availability groups essentailly are a set of failover partners (DBs), known as availability replicas. Each availability replica possesses a local copy of each of the databases in the availability group. One of these replicas, known as primary replica, maintains the primary copy of each database. The primary replica makes these databases, known as primary databases, available to users for read-write access. For each primary database, another availability replica, known as a secondary replica, maintains a failover copy of the database known as a secondary database.
Following image helps explain the concept:
 |
| SQL Denali Availability Group |
Here's a really good ste-by-step guide to configure HADR in Denali using Availability Groups: SQL Server Denali - AlwaysON (HADR): Step-by-Setup setup guide
I wonder if a SQL Azure instance is a supported secondary replica. Will post the result as soon as I get some time to try it out.
Cheers!!
2 comments:
Thanks for the blog, it's really useful, especially the "step by step" URL. I was wondering how often do my availability group update themselves so that all of the new information could be restored as well.
Your site is very helpful
https://www.kiwibox.com/noran/blog/
https://oali78313.wixsite.com/website
http://publish.lycos.com/noranamro
https://www.prokr.net/ksa/jeddah-water-leaks-detection-isolate-companies/
http://al-nor.com/
Post a Comment