Start a conversation

How can I shrink the transaction log file (.ldf)

Before this make sure there are free entries by setting the recovery model to simple or backing up the log. 
Enterprise Manager:
Right click on the database, All tasks, Shrink database, Files, Select log file, 
Click OK.
t-sql
dbcc shrinkfile ([db_log_name]) Here [db_log_name] is the logical name of the log file as found from 
sp_helpdb or the table sysfiles
Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Senior Engineer Jessie

  2. Posted
  3. Updated

Comments