Cannot delete FOO.mdf from the data_files location as it says its currently in use. But the database using this mdf file has already been dropped. My guess is something corrupt went on during the dropping process.
How do I get this file deleted? I can't even copy the file to a different destination.