Back

Topic

[KB487]How to reduce the database LOG file (.ldf) size

Tags: HDS, MSSqlServer, SQL, SQL Server

System
15 years ago
By RM
Options
Print
Applies to:

PcVue all versions.
Summary:

This article will help you to reduce disk space used by your LOG file when using the HDS and SQL Server 2005 or later.
Details:

  1. Check the database “Recovery Model” mode.
    1. If database Recovery Model option is set to “Full” or “Bulk Logged”, it can mean that a complex backup strategy was implemented.
    2. If it is not the case (no advanced backup), you can set Recovery Model option to “Simple” (you can make it on line, this operation is really fast).
      Pict1
  2. After that you have to physically reduce log file.
    1. Execute a shrink file task on log file (you can make it on line, this operation is fast).
      Pict2
    2. Right click on your database, tasks, Shrink, Files.
      Pict3
    3. Select File Type: Log
    4. Select File name: log file to reduce
    5. Select shrink action: Release unused space
    6. Click OK button

Created on: 12 Aug 2011 Last update: 13 May 2024