SQL Server Performance

TX logs still growing though

Discussion in 'Performance Tuning for DBAs' started by pohlsch77, Dec 10, 2004.

  1. pohlsch77 New Member

    Forgot to mention that my TX logs are still growing out of control and I have to do the DBCC SHRINKFILE command to free disk space after these have grown past the limit. I have to run this command at least once a week. How can I keep these files from growing so much? I am sure these are elementary questions to the more skilled in SQL than I am. Thanks for any help
  2. thomas New Member

    Is your db in simple recovery mode? If it's in full recovery mode you need also to regularly back it up to keep it down in size. There are umpteen threads in this forum about exactly the same topic, why don't you do some searching?

    Tom Pullen
    DBA, Oxfam GB
  3. satya Moderator

    Yes, it will save your typing before asking the question.

    BTW how often you backup the transaction logs?
    If you deploy SIMPLE recovery model then ensure the database backups are performed regularly in order to recliam the restore if any issue occurs.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page