• Charles Kincaid (4/30/2015)


    SQL server is a bit vulnerable during a shrink operation. ... If something goes bad during the shrink then a restore is likely to be needed.

    Not really. No more than in large table operations like index rebuilds. Shrink is a fully logged operations (with lots of small transactions) and if anything causes the shrink to fail or it's stopped, if can roll back to the beginning of it's last transaction.

    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