Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2004
    Posts
    1

    Unanswered: What should I do with the huge log file

    Hi all,
    I found my database log file is 26GB and the database file is just about 280MB. We are doing full backup everyday. However, my sql server seems running very slow now and please advise:

    1. How can I decrease/truncate my log file?
    2. Would the huge size of the log file be the reasons slowing up my sql server?
    3. Would anyone give me direction knowing more on the transaction log?
    Thank you and appreciated!

  2. #2
    Join Date
    Feb 2004
    Posts
    492
    1. From EM rightclick the database, choose 'All' and 'Shrink database'. If it doesnt help, see BOL for "DBCC SHRINKDATABASE" and "BACKUP LOG".

    2. Perhaps if your disk capacity is limited, the os might have difficulty finding free space. If various large transactions are rollbacked, that could have an affect on performance.

    3. My guess is that you refer to what's inside the transaction log and how did it become so big. I know there are some tools that allow you to see what' inside, don't remeber the url though. Perhaps the sql-profiler can help you more as to find out what transactions grow the log.

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by Kaiowas
    I know there are some tools that allow you to see what' inside, don't remeber the url though.
    http://www.lumigent.com

    -PatP

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I think three was more along the lines of...

    http://www.microsoft.com/sql/techinf...2000/books.asp
    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.

  5. #5
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Are you running full recovery mode or simple recovery mode. If you are in full mode, try doing a transaction log backup, then shrink the tran log.

    Also, look at this thread: http://groups.google.com/groups?hl=e...p03%26rnum%3D1

    I've had a lot of success with a proc written by Andrew Zanevsky, both for SQL 7 and SQL 2000. Do a google search and see what you find.

Posting Permissions

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