, i know we can set database file usage per drive level on the server level. But there are many times when a vendor created db, they have multiple data files mdf/ndf and have them set to limits. So i was wondering can we get even more granular. I want to be able to drill down to the database and select a particular file group and say ignore this drive, it has met its capacity and even though its 100% filled data is no longer being written there. And the reason behind that is there can be multiple data files on the same drive, so ignore the drive won't work if there is an active data file. see screen shot attached.