Post reply

shrinkdatabase taking looooong time

  • October 10, 2010 at 2:01 am

    #1234667

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

  • February 20, 2016 at 9:02 am

    #1859968

    Great!

    Thanks!

  • July 31, 2018 at 8:37 am

    #1999686

    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 17 (of 17 total)

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