Post reply

Difference between shrinking and truncating the logs

  • December 27, 2008 at 5:17 am

    #195380

    Hi,

    What is the difference between shrinking and truncating logs and how do they effect the backup and restoration's.

    Thanks

    Chandra Mohan N

    [font="Verdana"]Thanks
    Chandra Mohan[/font]

  • December 27, 2008 at 6:35 am

    #918014

    Hi,

    Your question has already been discussed, refer this link:

    http://www.sqlservercentral.com/Forums/Topic533052-146-1.aspx

  • December 27, 2008 at 8:58 am

    #918023

    truncating the log will remove any inactive entries but not reduce the actual physical file size.

    shrinking the log will reduce the physical file size,

    but it's worth noting you cannot shrink a log beyond the portion of the file that may conatin any active transactions. Check BOL for an overview of how transaction logs are designed and work

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • December 27, 2008 at 9:09 am

    #918030

    Not that you shouldn't be shrinking the log regularly. It should have enough space, without physical growth, to hold all entries between log backups.

Viewing 4 posts - 1 through 3 (of 3 total)

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