Resources For IT Professionals

United States (English) Drop down arrow

Drop down arrow

Россия (Pусский)中国（简体中文）Brasil (Português)

Post an article

Wikis - Page Details

First published by Ed Price - MSFT (aMicrosof)
When: 3 Sep 2013 2:32 PM
Last revision by Naomi N (eMicrosoft Partne)
When: 3 Sep 2013 2:58 PM
Revisions: 3
Comments: 1

Options

Subscribe to Article (RSS)

Can You Improve This Article?

Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.

SQL Server: Transaction Log is Full

SQL Server: Transaction Log is Full

Table of Contents

Overview
Recovery Model
Additional Resources
Reference
See Also

Overview

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:

Truncating the Transaction Log: http://msdn.microsoft.com/en-us/library/aa174538(SQL.80).aspx
How to truncate transaction log file via sql statement: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3591435&SiteID=1
How to backup and truncate all log files in a database: http://blogs.msdn.com/mab/archive/2008/01/26/how-to-backup-and-truncate-all-log-files-in-a-database.aspx
Truncate and shrink the transaction log: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=66239

Reference

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

See Also

EAA, Ed Price, en-US, From Forum, has References, has See Also, Has TOC, SQL Server [Edit tags]

Leave a Comment

Please add 2 and 1 and type the answer here:
Post

Wiki - Revision Comment List(Revision Comment)

| |

Comments

Ed Price - MSFT

3 Sep 2013 2:34 PM

Ed Price - MSFT edited Original. Comment: Added Reference
- Edit

Wikis - Comment List

| |

Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.

Comments

Posted by Ed Price - MSFT

on 3 Sep 2013 2:34 PM

Ed Price - MSFT edited Original. Comment: Added Reference
Edit