How To Shrink A Database Log File

Version 6

    Purpose

     

    The purpose of this document is to provide the process for shrinking a database transaction log file.  

     

    In order to shrink the Shavlik Protect database log file, please ensure SQL Server Management Studio is installed. You may install it by selecting the link corresponding with your Microsoft SQL Server version below:

     

        •    SQL Server 2005 Express

        •    SQL Server 2008 Express

        •    SQL Server 2008 R2 Express

        •    SQL Server 2012 Express

     

    Symptoms

     

    There are instances where the SQL server database transaction log file can grow exponentially causing the SQL Server's hard drive to become low on space.

     

    Resolution

     

      We recommend performing database maintenance using the Database Maintenance Operations built into to Protect. 

     

    1. Open Microsoft SQL Server Management Studio.


    2. Connect to the appropriate SQL Server Instance and login with the appropriate credentials. This is [hostname]\SQLEXPRESS by default and uses Windows Authentication.

    1.png

     

    3. Expand the ‘Databases’ portion on the left hand side of the screen.

     

    4. Right click on the ‘Protect’ or 'ShavlikScans' database. Select ‘Properties'.

     

    2.png


    5.Within the new window navigate to 'Options' and change the 'Recovery Model' to 'Simple' and click 'OK'.

     

    3.png

     

    6. Right click on the ‘Protect’ or 'ShavlikScans' database, navigate to Tasks>Shrink>Files

     

    4.png

     

    7. In the new window within the 'File type:' dropdown box select 'Log' and click 'OK'.

     

    5.png

     

    8. Once the 'Shrink File' window disappears the process is complete and your log file should be a fraction of the size it was when this operation began.

     

    Affected Product(s)

     

    Shavlik Protect 9.x