What is the hardware and software requirement for implementing HADR in SQL Server ?

Leave a comment (0) Go to comments

What is the hardware and software requirement for implementing HADR in SQL Server ?

Infrastructure Required To test the HADR / High Availability Group

  1. Domain Controller for Authentication
  2. Two Virtual Machines with Windows Server 2008 R2 with Failover Clustering installed on each Node.
  3. Local Instance of SQL Server (Not Clustered Instance) installed on Virtual Machines with Windows Server 2008 R2 (which are mentioned in point 2)

I have already implemented and tested HADR in SQL Server Denali CTP1, Here is the STEP BY STEP guide to implement HADR in SQL Server 2011 with Screenshots.

In this Demo, this was the setup configuration, which I used

Configuration for Domain Controller

  • RAM : 512 MB
  • Windows Server Name : DC
  • Domain Name : DEMO
  • IP Address : 192.168.0.1

Configuration for Virtual Server – 1

  • RAM : 1 GB
  • Windows Server Name : DENALI-SQL
  • Windows Failover Cluster Name : DENALI_CLUSTER
  • SQL Instance Name : DENALI-SQL\INST1
  • Member of Domain : DEMO
  • Note :
    • This was One node Cluster
    • As this a One node cluster no need to create a shared storage
    • Server IP : 192.168.0.11
    • Failover Clustering IP Address : 192.168.0.15
    • SQL Server Cluster IP Address : 192.168.0.12

Configuration for Virtual Server – 2


  • RAM : 1 GB
  • Windows Server Name : DENALI-SQL2
  • Windows Failover Cluster Name : DENALI_CLUSTER2
  • SQL Instance Name : DENALI-SQL\INST2
  • Member of Domain : DEMO
  • Note :
    • This was again a single node Cluster
    • As this a One node cluster no need to create a shared storage
    • Server IP : 192.168.0.21
    • Failover Clustering IP Address : 192.168.0.25
    • SQL Server Cluster IP Address : 192.168.0.22

Note : All Servers are in same subnet of 255.255.255.0 and domain administrator account is being to complete this configuration.

STEP BY STEP guide to implement HADR in SQL Server 2011 with Screenshots

EOF - What is the hardware and software requirement for implementing HADR in SQL Server ?, 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.