Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rwsjbs
Starting Member
17 Posts |
 Posted - 2010-04-18 : 17:24:07
|
| Thank you for looking at my post.I have deleted roughly 30% of the records in a database. I was hoping this would reduce the size of the database and the backup. Before making the detetes the backup size was 1.1 GB and after the deletes it is still over 1 GB.Do I need to run some sort of utility to have SQL delete the blank records to reduce the size of the database? Is there any utility I could run within the SQL 2000 Enterprise Manager (I'm not to knowledgeable on custom scripts).Any help would be appreciated.Thank you,Richard Scott |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-04-18 : 17:37:30
|
| Deleting records will not reduce the size of the database. Only a Shrink will reduce the size of the database, however there are downsides to shrink and you should not shrink the database unless you're sure that the free space won't be used in a reasonable amount of time.See - [url]http://sqlinthewild.co.za/index.php/2007/09/08/shrinking-databases/[/url] Backups are different. Backups will only backup up allocated extents. I would guess that the deletes left lots of extents with free space. Try rebuilding the clustered index of each table that you deleted from, that should help the backup size, providing that the 30% of records you deleted really did correspond to 30% of the size--Gail ShawSQL Server MVP |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Deleted records but database is still same size