Transaction log too big

galench · #1 10-02-2003, 02:40 PM

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.

MAK · #2 10-02-2003, 03:32 PM

1. you have to take tranlog backup often.

2. do a checkpoint on that database often and shrink the log during off hours.

ITellUWrong · #3 10-17-2003, 05:29 PM

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