Home Forums SQL Server 2008 SQL Server 2008 Administration Faster way to release the Unused Space back to Disk RE: Faster way to release the Unused Space back to Disk

  • December 21, 2012 at 1:35 am

    #1570782

    crazy4sql (12/21/2012)

    why dont you change your recovery model to "bulk logged" while your ETLs are scheduled?

    Not going to affect the size or usage of the data file in any way.

    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