How Many Nines Do We Need? Introducing SQL Server AlwaysOn
With natural disasters like earthquakes and fires in the news so often, and the economy still struggling to stabilize, IT Professionals know that many disasters can shut down a SQL Server.
Microsoft has already implemented a lot of high availability solutions in previous editions of SQL Server, like failover clustering, database mirroring, log shipping,… But,when it comes to high availability, SQL Server 2012 changes the game for SQL Server deployments by introducing SQL Server AlwaysOn. You can increase application availability and get a better return on your hardware investments through a simplified high availability deployment and management experience.
In this session you will see the key capabilities and concepts of Database Availability and Instance Availability.
Instance Availability: SQL Server Failover Cluster Instances, SQL Server Multi-Subnet Failover Cluster and how to deploy a SQL Server Multi-Site Cluster (Demo).
Database Availability: Deploying availability groups, configuration Application Failover using a Virtual Name, Initiating a failover to the secondary and possibilities with the active secondary.
SQL Server Days 2011 is brought to you by the Belgian SQL Server User Group (SQLUG.be VZW) in collaboration with Microsoft Belux.
Published Date: January 12, 2012
Presented By: Pieter Vanhove
Tags: Media , Zune , iPod , SQL Server Days 2011 Belgium , Pieter Vanhove , Screencasts , TechNet Edge , SQL Server , Belux