As you might be aware that SQL Server Code-Named “Denali” has introduced a new feature called Always ON for enhancing the availability of user database in a enterprise environment. In simple terms, AlwaysON is a high-availability and disaster recovery solution, which will enable you maximize availability of your critical user databases by use of “availability groups”
WARNING: The blog-post is based on pre-release software so things could change. For more details on CTP, please refer SQL Server Code-Named "Denali" CTP1 Release Notes
So what are “Availability Groups”?
Availability groups are set of failover partners (a.k.a availability replicas) to provide high availability to user database in Denali. Sure, this is lot more in depth and I suggest reading Denali Books-on-line for details.
In this blog post, I will guide you on how to configure AlwaysON – STEP-BY-STEP? Lets get going then !
Step 1. Windows OS and Cluster Configuration
a. For the purpose of testing, I have created a Windows 2008R2 two NODE cluster on virtual machine using Hyper-V and a Domain Controller
Read more: Microsoft SQL Server Tips & Tricks
WARNING: The blog-post is based on pre-release software so things could change. For more details on CTP, please refer SQL Server Code-Named "Denali" CTP1 Release Notes
So what are “Availability Groups”?
Availability groups are set of failover partners (a.k.a availability replicas) to provide high availability to user database in Denali. Sure, this is lot more in depth and I suggest reading Denali Books-on-line for details.
In this blog post, I will guide you on how to configure AlwaysON – STEP-BY-STEP? Lets get going then !
Step 1. Windows OS and Cluster Configuration
a. For the purpose of testing, I have created a Windows 2008R2 two NODE cluster on virtual machine using Hyper-V and a Domain Controller
Read more: Microsoft SQL Server Tips & Tricks