I will continue to tell SQL Server Failover Cluster Installation in this post.
Read previous article with following link.
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.
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.
Do you want to learn Microsoft SQL Server DBA Tutorials for Beginners, then read the following articles.
2,167 views last month, 10 views today