May 28, 2004 at 9:31 am
I am getting the following error, would you please help me.
The log file for database '<DB NAME>' is full. Back up the transaction log for the databse to free up some log space.
Thanks.
May 28, 2004 at 11:11 am
If you do a search of this site (especially the backup forum) you will find a lot of information about this message. The question you asked is asked just about every day.
Are you doing backups at all?
How important is your data?
Can you afford to lose some data?
If you can afford to lose data, you can set the database Recovery Mode to SIMPLE.
If you can't afford to lose data, the database should be set to FULL recovery mode; you should be backing up the database and the transaction log files on a regular basis.
That's what you should be doing....but now to solve your immediate problem.
1. Do a FULL backup
2. Run BACKUP LOG dbname WITH TRUNCATE_ONLY
3. Run DBCC SHRINKFILE logfilename
4. Do a FULL backup
Refer to the Books OnLine for more information on these commands.
-SQLBill
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply