Perry Whittle (7/26/2013)
sql-lover (7/25/2013)
I want to shrink an existing LUN that holds tempdb and I want to do it on the fly, without taking the SQL failover instance down.Not going to possible, the volume can be extended on the fly but not shrunk. There is no diskpart command to shrink a volume.
You could either get a new LUN attached and mounted under the root drive and then move the files to the new drive or you could have the current LUN mirrored to a new LUN which you then attach to the server and then move the db files. You'll need to stop and restart the instance so do this within a maintenance window.
Hmmm...
Maybe I did not explain myself properly?
I actually did additional test on my lab and I was able to. I also found Microsoft documentation confirming it is possible.
I am not talking about shrinking the LUN's size, but shrinking the partition or volume's size inside that LUN, moving it to the left, if I can use that expression. Once done, unassigned or unpartitioned space will be on the right, based on the shrink value that it was previous selected.
I will probably will have to do it on the real Cluster during downtime window and I will confirm.