Shrink Database

• joemai

  Hall of Fame

  Points: 3496

  More actions

  February 10, 2004 at 2:53 pm

  #160742

  Hi All, Does it make any harms for my production database if I shink it couple time a week? Please advice.  Thanks Josh Hua

• February 13, 2004 at 8:00 am

  This was removed by the editor as SPAM

• Larry C

  SSCommitted

  Points: 1543

  More actions

  February 16, 2004 at 8:00 am

  #494190

  Are you sure you really want to shrink the database? If you shrink the database then add quite a bit more data later, then SQL Server will need to expand the database again and that takes resources to do it.

• ericp37

  SSChasing Mays

  Points: 631

  More actions

  February 17, 2004 at 8:29 am

  #494373

  Then again I think that there valid reasons for shrinking a database....

  • The backups wont havet to walk empty pages
  • the space can be used by other databases.....or even the transaction log of this database. 

  It all depends on the volitility of the data, the limitation on disk space and the time needed to do backups vs adding new pages in production.