SQL Server 2012 AlwaysOn Availability Groups
SQL Server 2012′s coolest new feature gives you high availability, disaster recovery, scale-out reads, and much more. Here’s our posts and tutorials on how to use it.
Introduction to AlwaysOn Availability Groups – Brent explains why this new feature in SQL Server 2012 is better than any high availability or disaster recovery feature we’ve had before and how it can help your business.
How to Implement AlwaysOn Availability Groups
Free Setup Checklist PDF – Get started with our big setup checklist that covers planning, Windows, SQL Server, and the Availability Group setup.
An Introduction to SQL Server Clusters – AlwaysOn relies on Windows clustering, but relax – this isn’t your grandfather’s clustering. Kendra Little explains the differences between shared disk clustering and the AlwaysOn Availability Groups clustering.
How to Set Up AlwaysOn Availability Groups – A screenshot tour showing a simple lab installation from start to finish.
Video – How to Test Availability Groups in SQL Server 2012 – Kendra Little shows you how to set up a lab using free virtualization software and evaluation versions of Windows and SQL Server to get started learning AlwaysOn.
Using AlwaysOn Availability Groups in Amazon EC2 – If you’d like to use the cloud as a disaster recovery datacenter or just get higher availability by spreading your SQL Servers between availability zones, Jeremiah Peschka explains how to do it.
Why Availability Groups Make It Cool Again to Be a Sysadmin – Sideburns and sysadmins are back with a vengeance. DBAs need a lot of help from sysadmins in order to get AlwaysOn functionality up and running.
Managing SQL Server 2012 Availability Groups
Where to Run DBCC – you can run this corruption test against any of your SQL Server instances now, not just the primary, but should you only run it on a secondary? Brent explains why it’s closely related to where you run backups.
Why Your Network Connection Matters – if your primary SQL Server’s network connection blips, even for a moment, your databases will go offline if they’re in an Availability Group. Brent explains how to work around it.