I have clustered instance with two (2) data drives on it. Drive J has around 50 databases on it and drive K has about 15. One of the system administrators was trying to increase the size on K by 20 GB and he instead increased it by 200. Now he needs to take the accidental 180 GB back but the drive will need to come offline briefly. Is it possible to take the K drive offline, along with the databases on it, without taking the whole instance down?
I believe it's possible but I'm concerned about the SQL service cluster resource's dependence on the drive in question. Since the drive is setup as a dependence, would I need to remove the dependence first, then take the drive offline without affecting the SQL Server service status?