SQL Server: Transaction Log is Full

SQL Server: Transaction Log is Full



If the transaction log is full, users cannot update the databases and you cannot fully restore the database in the event of a system failure.  You must clear the transaction log either by performing a full database backup and saving the data, or by truncating the transaction log.

Recovery Model

The error says that there is no space available in the drive where Transaction Log file is kept. This is very common issue in SQL server if you do not have property backup policy or recovery model set to the database. If you are not taking TL backup regularly, you must change the recovery model to simple so that the TL size will not increase drastically. You may check this link.

For more information: http://www.karaszi.com/SQLServer/info_dont_shrink.asp

Additional Resources

Here are some more articles that will help you:

  1. Truncating the Transaction Log: http://msdn.microsoft.com/en-us/library/aa174538(SQL.80).aspx
  2. How to truncate transaction log file via sql statement: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3591435&SiteID=1
  3. Truncate and shrink the transaction log: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=66239


This content originated from Madhu and Dannal in this Forum thread.

See Also

Leave a Comment
  • Please add 2 and 1 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
  • Ed Price - MSFT edited Original. Comment: Added Reference

Page 1 of 1 (1 items)
Wikis - Comment List
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
  • Ed Price - MSFT edited Original. Comment: Added Reference

Page 1 of 1 (1 items)