shrinkdatabase taking looooong time

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

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

• d-i-m-on

  Old Hand

  Points: 355

  More actions

  February 20, 2016 at 9:02 am

  #1859968

  Great!

  Thanks!

• ryan0585

  Newbie

  Points: 9

  More actions

  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.