Tuesday, July 22

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

Within the MS SQL Query Analyzer, do this:

I encountered the error when try to perform DTS. Here the solution.

backup log db_name with truncate_only
go
dbcc shrinkfile (db_name_log,0)
go

Make sure you choose the database that you want to shrink

No comments: