How To: Create a Database Backup within Protect and Patch for Windows Servers

Version 7

    Symptoms

     

    This document explains how to perform a backup of your database with Shavlik Protect or Ivanti Patch for Windows Servers.

     

    Scenario


    You can use Shavlik Protect or Ivanti Patch for Windows Servers to perform a backup of the database thanks to the built-in Database Maintenance Tool.

     

    In Protect 9.2, go to Tools > Operations > Database Maintenance. In Patch for Windows Servers 9.3, go to Tools > Options > Database Maintenance.

     

     

    When you have accessed this window, at the bottom you will find the different options available in the SQL Server section.

    You need to select Backup database and transaction log, then you choose the path where you want to store your backups.

    The location could be local (on the same machine as Protect) or could be a UNC path (the account performing the backup needs access to that location).

     

    Lastly, you have to press Run now and the task will run in the background. You can follow the operation by going to View > Event History :

     

    Once it has completed, your backup will be created in the folder you chose earlier. Your backup will have the naming convention as :

    Name of the DB - Backup - Timestamp, here is an example :

     

     

    The account used to access the database and run the operation is the account set in the Database Setup Tool in the Services section. You can specifiy an account or leave it to match the account being used to connect to the database in the upper section.

     

    The account needs db_owner rights to perform the backup.

     

    Affected Product(s)

     

    Shavlik Protect 9.2

    Ivanti Patch for Windows Server 9.3