I am running SQL 6.5 on NT4. I have a database device and database that are both 5GB. The current data space available is within the database is 1GB. I have deleted 50% of the records in the database and have confirmed by the record counts that they are deleted. I was anticipating the data space available to increase by 2GB leaving me with 3GB free, however, I only have 1.5GB free. This doesn't seem to be proportionately correct.
I also noticed that the backup device file size is 50% of the orginial also leading me to believe that the records were purged properly.
Is there a database command I need to run in order to recover the data space within the database? I plan on leaving the device and database sizes at 5GB due to hard drive limitations.
Thank you
I also noticed that the backup device file size is 50% of the orginial also leading me to believe that the records were purged properly.
Is there a database command I need to run in order to recover the data space within the database? I plan on leaving the device and database sizes at 5GB due to hard drive limitations.
Thank you