Knowledgebase
How can I shrink the transaction log file (.ldf)
Posted by Sean Syed on 21 February 2013 07:15 PM
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
(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).