{"id":6669,"date":"2019-03-15T13:55:11","date_gmt":"2019-03-15T13:55:11","guid":{"rendered":"https:\/\/ittutorial.org\/?p=6669"},"modified":"2019-11-28T06:59:45","modified_gmt":"2019-11-28T06:59:45","slug":"sql-server-failover-cluster-installation-4","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/sql-server-failover-cluster-installation-4\/","title":{"rendered":"SQL Server Failover Cluster Installation -4"},"content":{"rendered":"<p>Hi,<\/p>\n<p>I will continue to tell\u00a0SQL Server Failover Cluster Installation in this post.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3099\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/windows-failover-clustering.jpg\" alt=\"\" width=\"640\" height=\"480\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/windows-failover-clustering.jpg 640w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/windows-failover-clustering-300x225.jpg 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/p>\n<p><!--more--><\/p>\n\n<p>Read previous article with following link.<\/p>\n<p>&nbsp;<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"vRitvbrdtx\"><p><a href=\"https:\/\/ittutorial.org\/sql-server-failover-cluster-installation-3\/\">SQL Server Failover Cluster Installation -3<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;SQL Server Failover Cluster Installation -3&#8221; &#8212; IT Tutorial\" src=\"https:\/\/ittutorial.org\/sql-server-failover-cluster-installation-3\/embed\/#?secret=fK9mfLoXFx#?secret=vRitvbrdtx\" data-secret=\"vRitvbrdtx\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p>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&#8217;s connection string. The application will access and service our database in every way.<\/p>\n<p>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.<\/p>\n<p>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.<\/p>\n\n<p>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.<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/161.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3129\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/161.png\" alt=\"16\" width=\"614\" height=\"448\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/161.png 1017w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/161-300x219.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/161-768x561.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n\n<p>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.<\/p>\n<p>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.<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/171.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3131\" src=\"http:\/\/salihdeveci.files.wordpress.com\/2013\/04\/171.png\" alt=\"17\" width=\"614\" height=\"445\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/171.png 1019w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/171-300x218.png 300w, https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/171-768x558.png 768w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n\n<h4><span style=\"color: #ff0000;\">Do you want to learn Microsoft SQL Server DBA Tutorials for Beginners, then read the following articles.<\/span><\/h4>\n<p><a href=\"https:\/\/ittutorial.org\/sql-server-tutorials-microsoft-database-for-beginners\/\">https:\/\/ittutorial.org\/sql-server-tutorials-microsoft-database-for-beginners\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi, I will continue to tell\u00a0SQL Server Failover Cluster Installation in this post.<\/p>\n","protected":false},"author":1,"featured_media":3099,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[2227],"tags":[615,2497,617,717,1031,1515,2498,1577,1583,1624,2496,1646,2495,1647],"class_list":["post-6669","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-sql-server-2","tag-failover-cluster","tag-failover-cluster-sql-server-installation","tag-failover-clustering","tag-high-availability","tag-mehmet-salih-deveci","tag-salih-deveci","tag-sql-failover-cluster-installation","tag-sql-server","tag-sql-server-2008","tag-sql-server-cluster","tag-sql-server-cluster-installation","tag-sql-server-failover-cluster","tag-sql-server-failover-cluster-installation","tag-sql-server-high-availability"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2013\/04\/windows-failover-clustering.jpg","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/6669","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=6669"}],"version-history":[{"count":4,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/6669\/revisions"}],"predecessor-version":[{"id":12947,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/6669\/revisions\/12947"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/3099"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=6669"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=6669"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=6669"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}