Results 1 to 3 of 3

Thread: Transaction log too big

  1. 10-02-2003, 01:40 PM #1
    galench
    galench is offline Registered User
    Join Date
    May 2003
    Posts
    2

    Transaction log too big

    Hi,

    I have a problem with my SQL2000 database right now. Because our SQL was hosting GPS data for a gateway, it has lots of transactions. The SQL data files are getting much bigger especially the transaction log file. Right now I even don't have enough space to backup the database.

    I tried to shrink the database and seems didn't help too much. And then I tried to shrink the file to specific size, but after shrinking the log file still stay the same size. Also i notice the option to empty the file was disabled in my SQL.

    Just wondering is there any way I can truncate the transaction log file or empty it.

    Thanks a lot.
    Reply With Quote Reply With Quote
  2. 10-02-2003, 02:32 PM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    1. you have to take tranlog backup often.

    2. do a checkpoint on that database often and shrink the log during off hours.
    Reply With Quote Reply With Quote
  3. 10-17-2003, 04:29 PM #3
    ITellUWrong
    ITellUWrong is offline Registered User
    Join Date
    Oct 2003
    Location
    Moon
    Posts
    1
    Also, I understand that when you detach and re-attach a database, the transaction log can be re-set to a smaller size.
    I am sure that it has grown larger than you want it in MB. this will do
    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