shrinkdatabase taking looooong time

  • MANU-J.

    SSC-Dedicated

    Points: 31126

    Michelle's script will work for you too. Increments depend on the disk hardware that server has. For fast subsystems 5GB increment also works too fine so it depends..

  • d-i-m-on

    Old Hand

    Points: 301

    Great!

    Thanks!

  • ryan0585

    Newbie

    Points: 9

    If shrinking the db is your thing, you can get an idea of the % complete using the following:

    SELECT percent_complete, * FROM sys.dm_exec_requests WHERE command = 'DbccFilesCompact'

    Wish there was a status bar or something so you could see how things are progressing, but that'll let you get an idea of how far you are along.

Viewing 3 posts - 16 through 18 (of 18 total)

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