{"id":176,"date":"2012-05-17T17:25:03","date_gmt":"2012-05-17T17:25:03","guid":{"rendered":"http:\/\/www.sqlfreelancer.com\/blog\/?p=176"},"modified":"2014-03-05T17:26:21","modified_gmt":"2014-03-05T17:26:21","slug":"adding-storage-to-sql-server-2008-cluster","status":"publish","type":"post","link":"https:\/\/www.sqlfreelancer.com\/blog\/adding-storage-to-sql-server-2008-cluster\/","title":{"rendered":"Adding Storage to SQL Server 2008 Cluster"},"content":{"rendered":"<p>Adding a new storage device using Windows 2008 Failover Clustering has been simplified enormously since the Windows 2003 and older clustering technology. In this post, I&#8217;ll show you how to add an extra storage device to your configuration. First thing you will need to do is get your SAN administrator to present a new disk to the cluster. Once the new disk is presented, go to Disk Management, and you should see the new disk unallocated. If the disk displays &#8220;Offline&#8221; simply right click and choose Online.<\/p>\n<p><a href=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Cluster-Storage.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-177\" alt=\"SQL Freelancer SQL Server Cluster Storage\" src=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Cluster-Storage.png\" width=\"495\" height=\"312\" srcset=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Cluster-Storage.png 495w, https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Cluster-Storage-300x189.png 300w\" sizes=\"auto, (max-width: 495px) 100vw, 495px\" \/><\/a><br \/>\nNext, right click on the disk and choose &#8220;New Simple Volume&#8221;. Clustering does not support any of the other volume options.<\/p>\n<p><a href=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Cluster-Storage-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-178\" alt=\"SQL Freelancer SQL Server Cluster Storage\" src=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Cluster-Storage-1.png\" width=\"495\" height=\"307\" srcset=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Cluster-Storage-1.png 495w, https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Cluster-Storage-1-300x186.png 300w\" sizes=\"auto, (max-width: 495px) 100vw, 495px\" \/><br \/>\n<\/a>After clicking &#8220;New Simple Volume&#8221; a wizard will appear.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"SimpleVolumeWizard\" src=\"http:\/\/www.mssqltips.com\/tipimages2\/2680_Add%20Storage%20to%20Cluster_clip_image003.png\" width=\"498\" height=\"384\" \/><\/p>\n<p>Click Next and you will see the following page. Choose your volume size and click Next.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"VolumeSize\" src=\"http:\/\/www.mssqltips.com\/tipimages2\/2680_Add%20Storage%20to%20Cluster_clip_image004.png\" width=\"500\" height=\"384\" \/><\/p>\n<p>Choose a drive letter, create a mount point on an existing disk or do not assign a drive letter. In this example, I&#8217;ll give the disk a drive letter of F. Click Next.<\/p>\n<p><a href=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Cluster-Storage-3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-179\" alt=\"SQL Freelancer SQL Server Cluster Storage\" src=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Cluster-Storage-3.png\" width=\"500\" height=\"384\" srcset=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Cluster-Storage-3.png 500w, https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Cluster-Storage-3-300x230.png 300w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/a><br \/>\nOn this screen, you will need to format the volume using NTFS and you can rename the volume to better identify it later on. I will also perform a quick format. Click Next and Finish to format.<\/p>\n<p><a href=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Cluster-Storage-4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-180\" alt=\"SQL Freelancer SQL Server Cluster Storage\" src=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Cluster-Storage-4.png\" width=\"499\" height=\"382\" srcset=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Cluster-Storage-4.png 499w, https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Cluster-Storage-4-300x229.png 300w\" sizes=\"auto, (max-width: 499px) 100vw, 499px\" \/><\/a><br \/>\nThe disk should now be online and allocated.<\/p>\n<p><a href=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Cluster-Storage-5.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-181\" alt=\"SQL Freelancer SQL Server Cluster Storage\" src=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Cluster-Storage-5.png\" width=\"497\" height=\"304\" srcset=\"https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Cluster-Storage-5.png 497w, https:\/\/www.sqlfreelancer.com\/blog\/wp-content\/uploads\/2014\/03\/SQL-Server-Cluster-Storage-5-300x183.png 300w\" sizes=\"auto, (max-width: 497px) 100vw, 497px\" \/><\/a><br \/>\n<a href=\"http:\/\/www.mssqltips.com\/sqlservertip\/2680\/adding-storage-to-sql-server-2008-cluster\/\" target=\"_blank\">Click here to view the rest of this post.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Adding a new storage device using Windows 2008 Failover Clustering has been simplified enormously since the Windows 2003 and older clustering technology. In this post, I&#8217;ll show you how to add an extra storage device to your configuration. First thing you will need to do is get your SAN administrator to present a new disk [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21,100],"tags":[102,7,42],"class_list":["post-176","post","type-post","status-publish","format-standard","hentry","category-clustering","category-high-availability","tag-clustering","tag-high-availability","tag-storage"],"_links":{"self":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/176","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/comments?post=176"}],"version-history":[{"count":2,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/176\/revisions"}],"predecessor-version":[{"id":183,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/posts\/176\/revisions\/183"}],"wp:attachment":[{"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/media?parent=176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/categories?post=176"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlfreelancer.com\/blog\/wp-json\/wp\/v2\/tags?post=176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}