Post reply

Backup Log & Shrink File

  • September 18, 2007 at 2:47 am

    #153834

    Will a full db backup truncate & release unused space from the transaction log? If not, do I have to specify these steps within a job seperately?

  • September 18, 2007 at 3:24 am

    #734241

    David,

    a full backup won't do anything with your Tlog.

    You need to backup the transaction log in order to mark parts of the tlog as inactive so that they can be overwritten again. This won't shrink your logfile, but it shouldn't grow so much if you take regular log backups.

    If you really need to truncate the Tlog use BACKUP LOG WITH TRUNCATE_ONLY.

    Markus

    [font="Verdana"]Markus Bohse[/font]

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

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