Post reply

Shrink Database

  • 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

  • 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.

  • 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.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply