Shrink Database

  • Hi All,

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

    Josh Hua

  • This was removed by the editor as SPAM

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

  • 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