Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185

    Unanswered: Log file is too big

    I have a database with 200 MB data file size and 120 GB transaction log file.I wonder why?This database is a part of the Data warehouse project and cubes are reffering to it.
    Is there any advantage of keeping such a big log file?

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    Are you truncating the log?

    If you have the recovery plan set to full and don't baskup the log then it will just keep growing.
    It will also not shrink unless you tell it to - so if you had a long running transaction in the past it would grow and stay there.

    Set the recovery model to simple to keep the tr log small if you don't want to recover transactions.

    Look at dbcc shrinkfile to shrink the log.
    a detach, delete log file and attach single file will do the same thing.

  3. #3
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185

    Recovery mode is Full

    Recovery mode has been set to full and the back-up plan is to take the full dump every night.But doesn't that truncate the Inactive part of the Log??

Posting Permissions

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