SQL Server Failover Cluster Installation -3

Hi,

I will continue to tell SQL Server Failover Cluster Installation in this post.

ActivePassiveCluster

 

Read previous article with following link.

SQL Server Failover Cluster Installation -2

 

You should added to the node according to the criticality of the application in the Failover Cluster architecture . In SQL Server 2008 Enterprise R2, up to a maximum of 16 nodes can be reached, this number is up to 64 in SQL Server 2012. Again, the number of nodes to be added depends entirely on the criticality of the application.

As a result, every node added means a server and the resources allocated to it. The cost increases as the number of Node increases, but High Availability increases in the face because the presence of the alternate node of each server will increase our high availability of service .

In the previous article, we have installed SQL Server Cluster on one of the two separate servers that have Windows Cluster installation. Now we are adding the same Cluster a node. The steps will be as follows.

 

1. In setup files, we run setup.exe as below on Second server.

1

 

2

 

2. In this step, click OK button to go on.

3

3. In this step, enter Product Key and click Next button.

4

4. In this step, click OK button to go on.

5

4. In this step, click Install button to start installation.6

5. In this step, the necessary parameters of system and Networks are checked on Windows Cluster as shown in the picture below. If there is a problem, it will not continue or installation will be problematic. As seen below, there is no problem except for some trivial warnings because there is no problem in our establishment. Click Next button and continue.

 

7

6. In this step, the Node Configuration of the Cluster is performed. Instance Name, Node Name and Cluster Network Name values are entered. We can give the active and passive Node the name we want, but we have to enter the Cluster Name which is preset of the Cluster Name. Click Next and continue.

8

7. In this step, Account of Instance will be the same as the previous Node.

9

8. In this step, click Next button to go on.

10

9. In this step, click Next button to go on.

11

10. In this step, click Install button to go on.

12

14

As shown below, we have successfully completed Cluster a Node.

15

 

 

Do you want to learn Microsoft SQL Server DBA Tutorials for Beginners, then read the following articles.

https://ittutorial.org/sql-server-tutorials-microsoft-database-for-beginners/

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

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