Web Scents
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
go
dbcc shrinkfile (db_name_log,0)
go
Make sure you choose the database that you want to shrink
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment