SQL Server Performance Forum – Threads Archive

The log file for database is full

Hi good day I am developing a system and im using vb6 ans sql server v7.0. I encountered this error today: The log file for database is full. Back up the trasaction log for the databae to free up some space. Please help me solve the problem.. I have no idea what causes the error and i dont know what to do.. thanks in advance..
Nhowelson

If you are not the DBA of the server, then you need to contact the DBA to fix the issue. If you are the DBA, you have a lot to learn. While there are several possible reasons this may happen, the most likely is that the log file has been set not to grow automatically. Another reason may be that the hard drive has run out of space. But first, check to see if the database has it’s transaction log set to not grow. If so, change it so that it can grow. Also, be sure to back up the database daily, as they will truncate the log, keeping it from becoming so large. —————————–
Brad M. McGehee, MVP
Webmaster
SQL-Server-Performance.Com

Also, if you are not doing transaction log backups, which it sounds like you’re not, set the recovery mode on the database to simple. Right-click on the database, go to properties>options>recovery mode. Like Brad said though, you need to at least be doing a backup daily. Lookup BACKUP DATABASE in Books Online. Start&gt<img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />rograms>Microsoft SQL Server>Books Online Derrick Leggett

Also review information from books online about error 9002 which delivers the action to be taken.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>