"Log file for database is full, back up transaction log for the database to free up log space" error message.
Posted on 2004-08-11
Hello, I'm a relative newbie to this since the SQL database person at my work is out for an extended period of time. Recently, on of the applications we use stopped working and returned the error I had in the title. After doing some research on-line I kind of know what's going on here, but I really have no idea what to actually do once I get into the Enterprise manager. I don't want to mess this up. Basically I want to the transaction logs to be backed up automatically so they get truncated (this is what happens after each log backup correct?) and this error never appears again. Right now the transaction log is set to Automatically grow, with Unrestricted file growth and the Recovery model is set to Full. There's no maintenance plan set for this database either. The only backup I'm aware that occurs on this is a tape backup that occurs nightly that backups all the databases on this server.
So how do I get rid of this error message and how do I make it where it doesn't occur again? This is for SQL 7.0. Thank you for any help given.