• 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.


7 views0 comments

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