Post reply

truncationg logs

  • September 16, 2004 at 1:03 pm

    #59423

    I have a Database of size 200 MB and my transactio log is 13GB(very high).So can I truncate the log file by taking a fresh full backup?

    Thanks.

  • September 16, 2004 at 8:39 pm

    #523440

    First back up by issuing

    BACKUP LOG {db_name}

    WITH NO_LOG

    Then

    DBCC SHRINKFILE (MYDB_Log, 100)

    where MYDB_Log is the logical log file name

    and 100 is the target size in MB.

  • September 17, 2004 at 7:49 am

    #523491

    I always use BACKUP LOG DataBaseName WITH TRUNCATE_ONLY

    Seems to work great for me.

    Shalom!,

    Michael Lee

  • September 17, 2004 at 10:20 am

    #523535

    Just backing up won't shrink the transaction log file.  It will eliminate the entries, but not change the file allocation.  Use the DBCC command, as shown above.

    So long, and thanks for all the fish,

    Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3

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

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