Home Forums SQL Server 2008 SQL Server 2008 - General When AutoShrink will occur in SQL server 2008? RE: When AutoShrink will occur in SQL server 2008?

  • December 14, 2012 at 3:09 am

    #1568603

    sanket kokane (12/13/2012)

    GilaMonster (12/13/2012)

    saranya.priyadharshini (12/13/2012)

    How i Can recover Free space?? Highly Suggest me!!

    DBCC ShrinkFile. There's no other way (other than copying the data to a new DB and dropping the old one)

    Let me guess, lots of LOB data? That makes shrink very slow.

    or moving the table(or rebuiding clustered index) to the new filegroup ?

    And then? Shrink the old filegroup? Will still have the problem with lob pages making the shrink slow.

    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