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.