Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002

    Unanswered: shrinkdatabase in sql 2000 vs sql 2005

    what is the difference in shrinkdatabase between sql 2000 and sql 2005. i am just doing a plain shrink, no reorg. it runs very fast in 2000 and runs forever in 2005.

  2. #2
    Join Date
    Feb 2003
    according to BOL - shrink operation can get blocked by other pending transactions. in that case error is written in errorlog. check it.
    also shrinking is not a great idea as it increases fragmentations causing a performance hit unless u have specific reason like deleting a big table etc.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts