SQL Server – How to Truncate Logs (.LDF) file.

The simple straight forward method to truncate logs in the occasion where you find yourself running out of disk space and do not have additional free space to spare.

Open SQL Studio > Select the database in question > Right click and Select Properties

From the Database Properties Window select Option and change the Recovery model to Simple.

2018-07-16_16-00-02

Select OK

Then Right click the database and select Tasks > Shrink > Files. Change the File Type to Log > Select OK

This will truncate the .ldf file.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s