 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / General / Setup / May 2005adding disk to a clustered sql server
i am running into an issue, hoping someone can point me in the right direction. i have a active/passive sql server cluster when it was built we gave it 24 gigs of san storage, but now we the db is growing we need more space. i had thought that i could just add more as i needed it, but it seems that the dynamic disk option isn't available on the cluster. is there a way to add disk to the cluster without taking an outage? It is possible under very specific circumstances on Windows 2003 to expand cluster disks. It depends on how your SAN vendor presents expanded LUNS to the OS. How to extend the partition of a cluster shared disk http://support.microsoft.com/default.aspx?scid=kb;en-us;304736 If you cannot do this, you will have to create a new LUN, present it to the host OS on all node(this will likely take a reboot on each node), and create a cluster disk resource. You then can put the disk in the SQL resource group. You must make the SQL service dependant on the disk resource or you cannot write SQL data files to the new clustered disk. Unfortunately, you will have to take the SQL Service offline to change the dependency. These may help: http://support.microsoft.com/default.aspx?scid=kb;en-us;295732 http://support.microsoft.com/default.aspx?scid=kb;en-us;254321 http://support.microsoft.com/default.aspx?scid=kb;en-us;835185 Geoff N. Hiten Microsoft SQL Server MVP >i am running into an issue, hoping someone can point me in the right >direction. [quoted text clipped - 8 lines] > > is there a way to add disk to the cluster without taking an outage? arrghh... thanks for the info Geoff, is it just me...this seems like a big limitation in the whole high availabilty idea. do you happen to know the reason for this not being a standard fearture in a cluster? > It is possible under very specific circumstances on Windows 2003 to expand > cluster disks. It depends on how your SAN vendor presents expanded LUNS to [quoted text clipped - 30 lines] > > > > is there a way to add disk to the cluster without taking an outage? It has to do with the whole clustering architecture. The dependency list is how the cluster knows how to failover and recover when a resource goes offline. Clustering is a good tool for handling unplanned outages. You still have to do some planned maintenance which will cause unavoidable downtime even with a cluster. Geoff N. Hiten Microsoft SQL Server MVP > arrghh... > thanks for the info Geoff, [quoted text clipped - 47 lines] >> > >> > is there a way to add disk to the cluster without taking an outage? Hi We are using EMC's and Veritas Volume Manager for the disks. We can add and remove LUNS dynamically on our clusters. It all depends on how much money and engineering effort you spend on the equipment. Regards -------------------------------- Mike Epprecht, Microsoft SQL Server MVP Zurich, Switzerland IM: mike@epprecht.net MVP Program: http://www.microsoft.com/mvp Blog: http://www.msmvps.com/epprecht/ > arrghh... > thanks for the info Geoff, [quoted text clipped - 47 lines] >> > >> > is there a way to add disk to the cluster without taking an outage? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.