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
dbcc shrinkfile (db_name_log,0)

Make sure you choose the database that you want to shrink

No comments: