Home Forums SQL Server 2016 SQL Server 2016 - Administration dbcc shrinkfile() RE: dbcc shrinkfile()

  • March 23, 2017 at 6:07 pm

    #1934674

    Sue_H - Thursday, March 23, 2017 4:14 PM

    alex.sqldba - Thursday, March 23, 2017 3:55 PM

    Genius Sue. Genius! Or I am a fool.
    or Both.

    Ha - only a fool if you think I'm genius. 🙂
    As Bill said, it will just be the same size if you kill it. But in most respects it really doesn't matter as you just don't want something like that running for a long time - it does start causing problems with locking, blocking, lots of I/O, logging, etc.

    Sue

    Yeah, I get you what you mean -- we manage about 15-20 hours downtime over a weekend but not enough to shrink it that much plus we also need the space back! I will try nibbling away at it, perhaps in a loop... so worst case when I stop the loop i'll lose the last iteration.