We are on SQL Server 7.0

The transaction log file has become 1.6 GB and still growing and I have very liitle space to accomodate that. How to reduce the file size so that I can have some more free space

Regards,
Srinivas

To avoid file grow in SQL 7:

1. Disable the automatic file grow option in the database properties window. After that you can choose one of the followings:
A. Enable Truncate log on checkpoint option.
B. Enable log backup procedure to truncate the log in job.

Regards,
Keren

Thanks. I did the way you suggested. But I still find that the Transaction log file is allocated 1.6GB. It is not allowing to reduce the size. How to reduce the size of Tr. Log file. I want to allocate say only 200MB. How can I do that. If I click the option Shrink database it is not responding and system is hanging

Regards,
Srinivas

Hi srinivas,

Ap kaise hu. Try backing up your database and transaction logs regularly through SQL maintenance. Preferably database every night and transaction log every hour.

This should free up your transaction log and reduce the size considerably.

Huge transaction log sizes are due to big baan transactions like sequential dumping and re-org. Once the transaction log is backed up, it will free those transactions and start with the fresh transactions.