NOW AVAILABLE: Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery

Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery http://msdn.microsoft.com/en-us/library/hh781257.aspx Summary: This white paper discusses how to reduce planned and unplanned downtime, maximize application availability, and provide data protection using SQL Server 2012 AlwaysOn high availability and disaster recovery solutions.A key goal of this paper is to establish a common context for…

2

SQL Server 2012 AlwaysOn High Availability and Disaster Recovery Design Patterns

SQL Server 2012 AlwaysOn provides flexible design choices for selecting an appropriate high availability and disaster recovery solution for your application. Please refer to blog: http://blogs.msdn.com/b/sqlcat/archive/2013/11/20/sql-server-2012-alwayson-high-availability-and-disaster-recovery-design-patterns.aspx


Converting a database mirroring configuration to Availability Group

One of the common questions we hear all the time is what are the requirements for setting up an Availability Group and how does that compare to database mirroring. I would like to answer this by going over a migration scenario. Let’s take a scenario where you have a primary datacenter and a secondary datacenter. Your…


AlwaysOn Availability Group and Database Mirroring

In SQL Server 2008 R2, a typical high availability deployment uses Database Mirroring to protect application databases from planned and unplanned downtime.  Database Mirroring combined with log shipping and failover clustering provide a great set of features that meet the high availability requirements of mission critical applications.   In Database Mirroring today, if the application is…

2

Introducing SQL Server code-named "Denali" AlwaysOn

Welcome to the official Microsoft SQL Server team blog for SQL Server AlwaysOn. As a team we are excited to share our knowledge with you and more importantly we are keen to get valuable feedback from you about the new high availability and disaster recovery solution for SQL Server, AlwaysOn. Let us get started by…

4