Is there a size limit of MDF database file? Is there any job that can split large database backup file into several smaller files Is there something like DBCC SQLPERF(LOGSPACE) that will show be a list of the databases and how much free space in each? is trace 3604 automatically ...
I reckon reclaiming space after dropping huge table would take much time to release space. Keeping this in mind and also since user said other tables were small I suggested scripting out and I agree its not best of the way but fits here...