Posted by Erland Sommarskog on 04/16/07 22:14

eighthman11 (rdshultz@nooter.com) writes:
> We received a error message "Log File to Database is Full. Backup the
> transaction log to free up space."

I addition to Greg's post, ask yourself if you need up-to-the-point
recovery in case of a failure, or you are content with restoring the
last backup. In the latter case, say

ALTER DATABASE db SET RECOVERY SIMPLE

also run DBCC SHRINKFILE to reduve the log file to reasonble size.

Note: if you are not the DBA on the server, leave it to the DBA to do this.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: What is better to use?
• Prev in forum: Re: Strange error on linked server - cannot open default database
• Thread view: Re: Tranaction log error- can someone tell me if this error was my fault

[Reply to this message]