I am attempting to empty a database file

Data has been shifted from a database file by using the emptyfile shrink command and then rebuilding/reorganising all heaps and indexes so that the data is pushed to the other files in the filegroup.

The amount of lob data in the file group is approx 1GB, acccording to dm_db_partition_stats and yet according to the SpaceUsed file property, we are still using 40GB of the file that I am trying to empty.

What could be using up all this data?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.