The log file for database is full. Back up the transaction log for the database to free up some log space.

When dealing with MS SQL (not MY SQL) I’ve seen this error message before, but found little help on it out there.

The log file for database db_name is full. Back up the transaction log for the database to free up some log space.

Within the MS SQL Query Analyzer, do this:
backup log db_name with truncate_only
go
dbcc shrinkfile (db_name_log,0)
go

If anything, this post will be useful for me in the future when one of my MS SQL databases coughs up the error again

January, 2007 10:13 PM | Blog it | Databases

To add a comment, sign in with your Windows Live ID (if you use Hotmail, Messenger, or Xbox LIVE, you have a Windows Live ID). Sign in

Don't have a Windows Live ID? Sign up

The trackback URL for this entry is:

http://deepankar.spaces.live.com/blog/cns!55EC2D3346C64489!576.trak

Weblogs that reference this entry