Home Forums SQL Server 2005 Administering Please Help!!! Running DBCC SHRINKFILE. It took long long time. RE: Please Help!!! Running DBCC SHRINKFILE. It took long long time.

  • I've found that shrinkfile can sometimes "hang", if I can I switch the database model to simple before shrinking the file(s)  I realise that sometimes this isn't possible but it works !

    You could also try issuing a checkpoint before the shrink.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/