I've replaced some drives to our MD3000 with bigger ones. These currently store database files used in a SQL Server 2005 cluster running on Windows Server 2003.
Now, we replaced the smaller hard drives with new bigger ones and let the array get rebuilt. We now have enough free space.
We would like to extend this virtual disk to allow our databases to grow.
I've found this command by googling:
smcli -n MD3000 -c "set virtualdisk [\"Storage\"] addCapacity=400000000000";
My first question is, is this command safe to use while the databse server is running and hosts accessing this virtual disk? Will it keep the data or will it wipe the data off the drive (of course, I'm going to have backups, but I would prefer not have to restore them for downtime reasons).
Then,it won't grow the actual partition for these drives.
I've seen that I can use the diskpart extend command. Again, can it be used while the database server is running or does it need to be turned off?
Thanks.