Post reply

Truncate or shrink log while a delete is running

  • May 7, 2015 at 9:10 am

    #296714

    SQL Server 2005

    Ran a 'Delete from' on a table which is a fully logged operation.

    is there a way to truncate or shrink the log WHILE the delete is running?

    Log is filling up my drive

  • May 7, 2015 at 12:03 pm

    #1796333

    No.

    The log can only be made reusable once the transaction completes. You can try to shrink it, but since there will be no free space the shrink will have no effect.

    You should be able to add a second log file somewhere else. Just remember to remove it once the delete has finished

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply