|
Subject:
|
Transaction Log Error
|
|
Posted By:
|
hugh@kmcnetwork.com
|
Post Date:
|
5/28/2008 12:36:21 PM
|
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.
|
|
Reply By:
|
jemacc
|
Reply Date:
|
6/4/2008 9:26:34 PM
|
Have you backup the database? are your backups failing? What mode you need your on; simple, Bulk-Logged or Full?
Jaime E. Maccou
|
|
