OS: Windows 2000 Advance Server
DB: SQL 7 Enterprise Version
I'm facing some weird problem, my goal was to clean old database records and free some space to the operating system, this is what append:
After delete the records from the database, execute again the sp_spaceused, the Data for one table was 1.2Gb and the unused space was about 4Gb.
I've export all the records (with DTS) to another table, delete the original and renamed the new, which reduce the unused space to Kbs. Everything look fine...
After some hours the of activity i execute again the sp_spaceused and the reservation parameter was about 6Gb to that table! The unused parameter looked fine.
How can i free that alocated space? Is it normal for this kind of behavior?