Home Forums SQL Server 2008 SQL Server 2008 Administration Shrink of data file - DBCC SHRINKFILE - taking a long time and not completing - stuck at 99% completion RE: Shrink of data file - DBCC SHRINKFILE - taking a long time and not completing - stuck at 99% completion

  • October 13, 2012 at 2:26 pm

    #1548914

    Marios Philippopoulos (10/13/2012)

    I found out that this data file contains data from a text column.

    Could this be the reason I am having trouble shrinking the file?

    Yes it is. The structure of LOB trees means that it takes much longer than 'normal' to move the pages around when you shrink.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass