I'm running SQL Server 2008 sp1 (10.0.2734) on Windows 2008. Yesterday morning I tried to remove what I believe to be an unused data file but got an error that said it could ot be removed because the file wasn't empty. I don't show any tables
or indexes using that data file.
I can list all the data files & their corresponding filegroup but none show being in the data file I want to remove.