March 16, 2009 at 9:56 pm
Hi Folks
I have working SQL Server 2005 Active/Passive cluster setup in virtual environment with virtual server 2005 r2. Initially when i designed the environment i haven't forecasted the database growth properly and now i am in trouble relating to disk space. it is in virtual environment and while setting up cluster i have to metion the shared disks and quorum disks. Shared data disk is running out of space and the only option left seems to add new virtual hard disk (vhd).
Now in relation to this i have a question, is it possible to add new virtual hard disk to an existing sql svr cluster. If yes, then can anyone please provide me some reference material which i can follow.
If no 🙁 then what are the alternatives available. The worst case i could think of is to scrap the existing cluster and then rebuild it; which is very time consuming task and i can't afford to bring the systems down for this much time.
March 18, 2009 at 6:14 am
Are your database backups on the server as well? Can you add an external array? I ran into the same situation a few years ago and we added a 2nd array so that I could move the backups and free up some space. I used an MS article on how to add a resource and create a clustered share.
Is this what you're looking for?
March 18, 2009 at 6:34 am
Hi Linda
Are your database backups on the server as well?
no database backups are not on the same server.
Can you add an external array?
i am in a virtual environment so it would be an extra virtual hard disk.
thanks for giving the tip of looking at adding the clustered resource. i'll probably have a look at it tomorrow morning.
March 18, 2009 at 7:36 am
Yes, you can add another virtual disk. I had to build it "outside" the cluster group that SQL was in, then add it in as a cluster group resource. Once its there, SQL can use it. It did take reboot of the passive cluster node for it to find it though.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply