• Repost - originally posted 14-05-2012

SQL Server 2012 Availability Groups Lessons Pt 1


We recently set up a production SQL Server 2012 system with AlwaysOn Availability Groups (AG) to provide High Availability (HA). During installation we encountered a number of issues. The purpose of this blog (and others to follow) is to give you some tips that may make your setup go seamlessly. Tip 1: Make sure the account under which you are creating the AG has permission to create an AD object.

Another option would be to create a SQL Server installation only account that would have full administrative privileges. When not required it could be locked and the password changed each time it needs to be used.


Recent Posts

See All

SQL Server 2012 Availability Groups Lessons Pt 8

This is the eighth tip on SQL Server 2012 availability groups (AG) to help you understand what else you need to consider in creating a high availability environment with AG. Tip 8: Like database mirro

SQL Server 2012 Availability Groups Lessons Pt 7

This is the seventh tip on SQL Server 2012 availability groups (AG) to understand their configuration and setup. Tip 7: In our current setup we have an AG with a primary and two synchronous secondarie

SQL Server 2012 Availability Groups Lessons Pt 6

This is the sixth tip on SQL Server 2012 availability groups to make sure CDC works. Tip 6: Change Data Capture (CDC) has been around since SQL Server 2008, but now you need to incorporate CDC with SQ