How To: Shrink a Database

Version 8

    Purpose

     

    This document will outline the process of shinking the Shavlik Protect or Ivanti Patch for Windows Servers database.

     

    Note: In order to shrink Shavlik Protect or Ivanti Patch for Windows Servers database, please ensure SQL Server Management Studio is installed. You can download and install the latest version from here.

     

     

    Steps

     

    1. Open Microsoft SQL Server Management Studio.
    2. Connect to the appropriate SQL Server Instance and login with the appropriate credentials. This is either [hostname] for full SQL instances or  [hostname]\SQLEXPRESS for SQL Express instances. Default authentication will be Windows Authentication.

         3. Expand the ‘Databases’ portion on the left hand side of the screen by clicking the '+' sign.

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

     

     

    1. Within the Database Properties window, select 'Options' on the left hand side of the screen.

     

     

    1. Within this screen set the 'Recovery model' option to 'Simple'.

    1. Click 'Ok'.
    2. Right click on the ‘Protect’ database. Select 'Tasks' then 'Shrink' and select 'Database' from the submenu.

     

    1. Within the new window, click 'OK'.
    2. The window will close when the database shrink process has been completed.