Preparing Your Database

In the event of a disaster, detailed transaction logs are useful when restoring your database. You can control the level of detail that your logs record.

The installation of Ivanti Endpoint Security sets your database to a recovery model of Simple. To use Transaction Logs, and thus increase the quality of your disaster recovery solution, you should change the recovery model to Full.

Changing the Database Recovery Model

Modify the database recovery model to record more robust details about the events leading to a disaster.

Database recovery model edits take place in the SQL Server Management Studio.

  1. Open the Microsoft SQL Server Management Studio.
  2. Log into your database server.
  3. In the directory tree, expand Server Name\SQL Instance > Databases.
  1. Right-click the PLUS database.
  2. Select Properties.
    The Database Properties window opens.
  1. In the Select a Page pane, click Options.
    The Options page opens.
  2. In the Recovery model list, select Full.

    A full database backup backs up the whole database. This includes part of the transaction log so that full database backup can be recovered.

  3. Click OK.
    The changes are saved and the Database Properties window closes.
  4. Repeat the recovery model modification process for the following databases:

    5. Database Name

    Product

    STAT_Guardian

    Ivanti Endpoint Security

    UPCCommon

    Ivanti Endpoint Security

    UPCExtended

    Ivanti Endpoint Security

    PLUS_Reports

    Ivanti Enterprise Reporting Client

    ERS

    Ivanti Enterprise Reporting

    ERS_Staging

    Ivanti Enterprise Reporting

    ReportServer(1)

    Microsoft SQL Server Reporting Services

    ReportServerTempDB(1)

    Microsoft SQL Server Reporting Services

    SafeGuard(2)

    powered by Sophos®
    1. Subscription features available in Microsoft SQL Server Reporting Services can be implemented in Ivanti Enterprise Reporting. By default, the database names are ReportServer and ReportServerTempDB.
    2. Data protection capabilities in is enhanced with a full disk encryption add-on from Sophos. The installation of results in a Safeguard database.

After Completing This Task:

You must create a backup of each database before any Transaction logs will be created.
Refer to Creating a Database Backup to create a one-time backup of your database.