Tiada Hari Tanpa Pendidikan
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
Share to Twitter
Share to Facebook
Share to Pinterest
Post a Comment
Post Comments (Atom)