How to setup Availability Group in SQL Server DENALI (2011)?

Leave a comment (0) Go to comments

How to setup Availability Group in SQL Server Denali?

Step 1 : Enable the HADR service on both clustered DENALI instances

  • Open SQL Server Configuration Manager
  • Select SQL Server Services
  • Right-click on your SQL Server, in my case SQL Server (INST1) and select Properties

Step 2 : Create an Availability Group

  • Open SQL Server Management Studio on DENALI-SQL\INST1
  • Select Management
  • Right-click Availability Groups and select New Availability Group

A Step by Step guide with screenshots has already been posted by me on “How to setup HIGH availability Groups in SQL Server“. Please check that out at following URL

http://sqlserver-training.com/how-to-implement-hadr-a-high-availability-and-disaster-recovery-solution-in-sql-server-step-by-step-guide-with-screenshots/-

EOF - How to setup Availability Group in SQL Server DENALI (2011)?, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.