• You can use dbcc shrinkfile passing in the emptyfile parameter, this will empty data from the file to other files in the same file group only. You would then need to remove the file using the ALTER DATABASE command.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉