badrhino
asked on
Compact SQL Server using DBCC ShrinkDatabase question
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!
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
RiteshShah:
Thanks!!!
Thanks!!!
ASKER