Results 1 to 3 of 3

Thread: growing tran log file

  1. 05-16-2006, 10:06 AM #1
    jannat
    jannat is offline Registered User
    Join Date
    Oct 2002
    Location
    queens
    Posts
    139

    growing tran log file

    I have a database of 22 gb in sql 2000, my database option is set to full recovery mode, the problem i'm having is the tran log is growing too fast, this morning it was 24 gb, more than the database size. Can anyone help how I can keep it in a managable size?

    Thanks in advance!!
    Reply With Quote Reply With Quote
  2. 05-16-2006, 10:16 AM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    take tranlog backup often. every 30 mins atleast
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 05-16-2006, 10:26 AM #3
    jannat
    jannat is offline Registered User
    Join Date
    Oct 2002
    Location
    queens
    Posts
    139
    ok, thanks, i will try that.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules