Knowledgebase: MSSQL Server
How can I stop the transaction log file (.ldf) from growing
Posted by Sean Syed on 21 February 2013 07:15 PM
If the log file has grown do to being in full recovery mode then set it to simple before going any further. This should immediately stop the log from 
growing.
Enterprise manager:
Right click on the database, properties, Options, set model to simple, OK.
t-sql
sp_dboption [dbname], 'trunc. log on chkpt.', 'true'
(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).