Results 1 to 6 of 6

Thread: Transaction Log File Issue

  1. #1
    Join Date
    Sep 2006
    Location
    East Coast Of America
    Posts
    15

    Transaction Log File Issue

    I have one SQL Server holding couple databases. And a maintenance job running every night to backup the log files.
    The command like :
    BACKUP LOG DB_1 WITH TRUNCATE_ONLY
    The server have kept sending error messages those days.
    It said the Log file is full. Actually, noone is using those databases.
    I need help!

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Did you check db's log usage? What's db recovery model?

  3. #3
    Join Date
    Sep 2006
    Location
    East Coast Of America
    Posts
    15
    The recovery mode for the DB is "FULL".

  4. #4
    Join Date
    Sep 2006
    Location
    East Coast Of America
    Posts
    15
    The job also contains DBCC DBREINDEX and UPDATE STATISTICS for each table within the DB. Is that could be the reason making tran log grow?

  5. #5
    Join Date
    Sep 2002
    Posts
    5,938
    Yes, building index generates logs. By the way, you should do regular log backup for point of time recovery and to truncate log.

  6. #6
    Join Date
    Sep 2006
    Location
    East Coast Of America
    Posts
    15
    Thank you for the advices.

Posting Permissions

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