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.

1. you have to take tranlog backup often.

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

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