How can I shrink the transaction log file (.ldf) - Powered by Kayako Help Desk Software

Knowledgebase

(28)Applications (16)DNS (23)Domains (9)Downloads (61)eMail (5)File Transfer Protocol (144)Flash Tutorials (18)General (11)IIS (4)Migrations (30)MSSQL Server (10)MySQL Server (74)Plesk Panel (2)Security and Hack (9)SEO (3)Server Settings (10)Services (3)SSL Certificates (9)Your Account

Knowledgebase

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

Posted by on 23 August 2012 07:35 AM

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

(3 vote(s))

Helpful

Not helpful

Comments (0)

Post a new comment Reply to comment
Post a new comment Reply to comment

CAPTCHA Verification
CAPTCHA Verification

Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).