Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2003
    Posts
    176

    Unanswered: truncating log file

    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.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Oh lord.....

    What's your Recovery model?

    Simple?

    Full?

    When was the last time you did a backup?

    And change the auto grow feature and disable it....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Dec 2003
    Posts
    22
    You need to do a full backup, and then do a log backup right after that. Then you can shrink the log.

  4. #4
    Join Date
    Jan 2004
    Location
    Atlanta
    Posts
    18

    log problems

    if you're going to truncate the log, you can just set the recovery model to SIMPLE, then you won't run into this issue again. Only reason you need the FULL recovery model is if you're taking transaction log backups at intervals thru out the day.

    Nick

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •