Hello everyone and thanks for your help in advance. I am encountering an error with a SQL Server 2000 database. When trying to write through a web application, I receive the error Transaction Log is full. In looking at the database,the transaction log (LDF) file is nearly 4 times that of the MDF file. Because of this, I am running out of disk space. I have read some articles regarding this topic, but can't seem to find one definitive source as to how to rectifify this problem (for example, do I need to TRUNCATE the log or does backing up the databse fix this issue?). I currently have the database allowing unrestricted growth to the transaction log, but don't know the ramifications of selecting a smaller size. Or do I simply need to add more disk space? Any help on this topic would be greatly appreciated. Thanks.

Have you backup the database? are your backups failing? What mode you need your on; simple, Bulk-Logged or Full?


Jaime E. Maccou