When dealing with MS SQL (not MY SQL) I’ve seen this error message before, but found little help on it out there. Keep in mind, I’m not a db guru by ANY sort of the imagination:

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

Cheers,
Chuck

Feel free to email me or post a reply.
Email: c h u c k (at) g o f i x i t (dot) c o m
_____________________________________________
Comments on this web site are moderated, so feel free to post - just don’t sweat it when it takes me a few hours to approve

Copyright gofixit.com 2005 - 2009

I’m on vacation this week. I am on a Royal Caribbean cruise. Currently, we are in St. Lucia - a beautiful island that I’m going to put on the list to come back and visit. I’ve stayed in touch with the outside world for the mostpart, thanks to RC Internet (the online wifi connection within the cruise ship). I’m getting a connection speed of 200 kbps down and 92kbps up - not bad. I can’t wait to get back and see what’s happening in the online world. Until then, going offline..

Chuck

Feel free to email me or post a reply.
Email: c h u c k (at) g o f i x i t (dot) c o m
_____________________________________________
Comments on this web site are moderated, so feel free to post - just don’t sweat it when it takes me a few hours to approve

Copyright gofixit.com 2005 - 2009