If the transaction log file (.ldf) in Microsoft SharePoint gets too big, it can cause performance issues, eat up valuable disk space and consume resources when you back up. Therefore it’s imperative to periodically maintain the database and to keep the .ldf file under control.

To reduce the .ldf file, you must do two things:

  1. Backup the database
  2. Shrink the .ldf file

Fortunately, SQL Management Studio offers a simple GUI to perform both those tasks. If you don’t have SQL Management Studio, you can get it here.

If you are not sure how big your database’s .ldf file is, SQL Management studio will let you peek as well.

To preview and reduce your SQL database .ldf file, follow these directions:

Open SQL management Studio and use the following location for the server name to connect:

\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query

image

Find your database and right click on it to select its properties. From the left hand pane, select Files.

image

The image above shows a 5GB database with a 49 GB .ldf transaction log!

Click OK to exit the window.

Right click on your database and select Tasks > Backup

image

Make sure the backup type is type Full and enter a destination. Click OK to proceed.

Once the database has finished backing up, right click on it and select Tasks> Shrink > Shrink Files.

image

Select Log as the file type and select Release unused space. Click OK, to proceed. This will truncate the log file.

Leave a comment

Your email address will not be published. Required fields are marked *