Compact SQL Server using DBCC ShrinkDatabase question
Posted on 2009-03-30
I have a database that has multiple tables with each table having large amounts of data being inserted into it periodically, and very rarely do we ever delete a record in these tables.
This database has grown quite large, andI have noticed that all of my tables have large amounts of reserved and unallocated disk space. For instance, one table has1.7 gigs of reserved space, 478 mb of data and 1.14 gigs of unallocated space.
My question is would DBCC ShrinkDataBase (DatabaseName, TruncateOnly) be the best option to shrink the reserved and unallocated disk space? If not, what would you recomend? Thanks in advance for your respones!