SQL 2012 Failover Cluster Build (Step by Step) – Part 3:Adding a New Instance

Introduction

This is my 3rd and last post of the series of building SQL Server 2012 failover cluster. This will cover the steps adding a new named database instance to the cluster that is already created. Please refer to the 1st part for understanding the context of the overall demonstration. You must finish part 1 in order to apply the steps defined here in your case.

Part 1: Installing SQL Server 2012 failover cluster

Part 2: Adding second node to the cluster

How-to steps

This will be very similar to SQL Server 2012 installation in part 1. So, the recommendations given there apply here as well. Assumed you logged in with a cluster admin account to Node1 or Node2.

Step#

Screen capture

1.       Start the Setup media

clip_image001

 

2.       Click Installation. Then ‘New SQL  Server failover cluster installation’

clip_image002

 

3.       OK

clip_image003

 

4.       Uncheck ‘Include SQL Server product updates’ if not connected to Internet. Then Next

clip_image004

 

5.       Next

clip_image005

 

6.       Provide the product key. Then Next

clip_image007

 

 

7.       Check the license agreement checkbox. Then Next

clip_image008

 

8.       Next

clip_image009

 

9.       Select Instance Features. Then Next

clip_image010

 

10.   Next

clip_image011

 

11.   Provide Network and Instance Name. Then Next

 

clip_image012

 

 

 

12.   Next

clip_image013

 

13.   Next

 

clip_image014

 

 

 

14.   Select disks needed by the instance. Then Next

clip_image015

 

 

 

 

15.   Check IP Type (IPv4) and provide IP Address. Then Next

clip_image016

 

16.   Provide service account credentials for engine and agent services. Then Next.

clip_image017

 

17.   Add current user as sysadmin.

Click on Data Directories tab. Then  give path to each directory

 

clip_image018

 

18.   Next

clip_image019

 

19.   Next

clip_image020

 

20.   Next

clip_image021

 

21.   SUCCESS. Close.

clip_image022

 

 

Conclusion

In this post, I have shared with you the scenario of adding a new database instance to the SQL Server 2012 failover cluster that is created in the part 1. This is the last piece of the post series of implementing highly available SQL data services by utilizing clusters. But, not the last on High Available (HA) data services, which is one of the major enhancements of SQL 2012 Server. There are more to say about SQL 2012 Server HA features, added some resources below. Perhaps next time, we can dive into it, stay tunedSmile

Resources on SQL Server 2012 HA

  1. High Availability Solutions (SQL Server)(http://msdn.microsoft.com/en-us/library/ms190202.aspx)
  2. Prerequisites, Restrictions, and Recommendations for AlwaysOn Availability Groups (SQL Server) (http://msdn.microsoft.com/library/ff878487(v=sql.110).aspx#SystemReqsForAOAG)
  3. SQL Server 2012 AlwaysOn High Availability and Disaster Recovery Design Patterns (http://sqlcat.com/sqlcat/b/msdnmirror/archive/2011/12/22/sql-server-2012-alwayson-high-availability-and-disaster-recovery-design-patterns.aspx)
  4. Prepare a Mirror Database for Mirroring (SQL Server) (http://msdn.microsoft.com/en-us/library/ms189053.aspx)
  5. AlwaysOn Failover Cluster Instances (SQL Server) (http://msdn.microsoft.com/en-us/library/ms189134.aspx) 

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.