MS SQL 2005 DBCC SHRINKDATABASE
Posted on 2008-06-19
I deleted a massive amount of data (6GB) from the database last night due to someone backing up massive tables in a production environment. I noticed this from the size of the backup increasing by 6GB. After I truncated and dropped the tables, I performed a DBCC SHRINKDATABASE. The new backup is 13GB, which is the expected size without the unnecessary deleted tables.
My question is, why has the size of the backup decreased, but the size of the MDF file is still 19GB?
I performed - DBCC SHRINKDATABASE ('DBNAME',TRUNCATEONLY)
Thanks in advance!