SQL Server Failover Cluster Installation -4

Hi,

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

Read previous article with following link.

 

SQL Server Failover Cluster Installation -3

 

We have completed the Failover Cluster installation in SQL Server. We have a Failover Cluster database that is active and passive. We give Cluster IP to the application’s connection string. The application will access and service our database in every way.

When the server is down, Windows Cluster will automatically move SQL Server Services to the other node and mount the shared disk to the passive node and passive node will be active.

Sometimes the active node can also have a maintenance plan, so administrator can do manually failover. Together with our SQL Server Cluster database, we will provide High Availability for the application that will connect to this database.

After completing the installation, there is a tool called Server Manager on the Server to Manage SQL Server Cluster Systematically. When we open this tool, we can manage the Cluster as follows. From here we can find information about Cluster configuration and manage the Cluster easily.

 

16

In the picture below, we are opening the active node of the Failover Cluster that we have installed. As shown below with arrov, it is seen that Node is Online. Here we can do a manual failover by right-clicking on the Node.

You can mount or diskmount the disks. In brief, as I mentioned above, we can perform all kinds of operations related to Cluster in Server Manager.

 

17

 

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.

2 comments

  1. Definitely consider that which you said. Your favourite justification seemed to be at the net the simplest factor to take into account of. I say to you, I definitely get annoyed while people consider concerns that they plainly do not know about. You managed to hit the nail upon the highest and also defined out the entire thing without having side effect , folks could take a signal. Will probably be back to get more. Thanks

  2. I loved as much as you’ll obtain performed right here. The comic strip is tasteful, your authored material stylish. nevertheless, you command get got an nervousness over that you would like be handing over the following. ill unquestionably come further previously once more as precisely the similar just about a lot often inside case you protect this hike.

Leave a Reply

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