Home Forums SQL Server 7,2000 Administration Database size issues RE: Database size issues
Steve Jones - SSC Editor
SSC Guru
Points: 734522
More actions
August 20, 2009 at 8:52 am
#1042180
It doesn't seem like you have a lot of free space in there. 59GB data with 65GB data file. You want to keep free space in your database to allow for changes, reindexing, etc. Shrinking the file fragments the data and slows performance.