Creating an Automated Solution

A Maintenance Plan allows you to create an automated backup and schedule the backup to occur as frequently as your organizational needs dictate. Maintenance Plans allow you to define your back up options as well as which databases and transaction logs to include.

If you have not already done so, you should change your Database Recovery Model to FULL before continuing. For additional information, refer to Preparing Your Database.

Creating a Maintenance Plan

You can automate a database maintenance plan for the SQL Server instances associated with Ivanti Endpoint Security.

Prerequisites:

Prior to creating a Maintenance Plan you must upgrade your database server to Microsoft SQL Server 2008 Standard or Microsoft SQL Server 2008 Enterprise, install SSIS (SQL Server Integration Services), and set the SQL Server Agent startup type to Automatic.

To create a maintenance Plan:

Open the Microsoft SQL Server Management Studio.
Log into your database server.
In the directory tree, expand Server Name\SQL Instance > Databases.
Right-click on the Maintenance Plans folder.
Select Maintenance Plan Wizard.
The SQL Server Maintenance Plan Wizard opens.
Click Next.
The Select a Target Server page opens.
Define the maintenance plan Name, Description [optional], target Server, and Authentication method.
Click Next.
The Select Maintenance Tasks page opens.
Select the following maintenance tasks:
- Check Database Integrity
- Clean Up History [optional]
- Back Up Database (Full)
- Back Up Database (Transaction Log)
Click Next.
The Select Maintenance Task Order page opens.
Set the tasks to execute in the following order:
- Check Database Integrity
- Back Up Database (Full)
- Back Up Database (Transaction Log)
- Clean Up History [optional]
Click Next.
The Define Database Check Integrity Task page opens.
Click the Database drop-down.
1. Select the These databases option.
2. Select the PLUS database.
  Tip: You may choose all databases that require a database maintenance plan from the drop- down list.
3. Click OK.
Ensure that the Include indexes option is selected.
Click Next.
The Define Back Up Database (Full) Task page opens.
Click the Database drop-down.
Define your Back up Destination settings.

Select either the Disk or Tape option.
Select to Create a backup file for every database.
Select to Create a sub-directory for each database.
Define your destination Folder.
For performance reasons, it is recommended that you create your database backup in a directory that is not on the same physical drive as your database.
Ensure the Backup file extension is set as .bak for the database backup.
Select Verify backup integrity.
The Define Back Up Database (Transaction Log) Task page opens.

Click Next.
Click the Database drop-down.
1. Select the These databases option.
2. Select the PLUS database.
  Tip: You may choose all databases that require a database maintenance plan from the drop- down list.
3. Click OK.
Define your Back up Destination settings.
1. Select either the Disk or Tape option.
2. Select to Create a backup file for every database.
3. Select to Create a sub-directory for each database.
4. Define your destination Folder.
  For performance reasons, it is recommended that you create your database backup in a directory that is not on the same physical drive as your database.
5. Ensure the Backup file extension is set as .bak for the database backup.
6. Select Verify backup integrity.
  The Define Back Up Database (Transaction Log) Task page opens.
Click Next.
If the Clean Up History option was selected, the Define Cleanup History Task page opens. Otherwise the Select Plan Properties page will open.
If the Clean Up History option was selected, define the Cleanup History Task options.
1. Ensure that Backup and restore history is selected.
2. Ensure that SQL Server Agent job history is selected.
3. Ensure that Maintenance plan history is selected.
4. Define the Remove historical data older than setting as appropriate for your organization.
5. Click Next.
  The Select Plan Properties page opens.
[Optional] Click Change to open the New Job Schedule page and define the maintenance plan schedule.
1. Enter a Name for the schedule.
2. Select a Schedule type.
3. Ensure that Enabled is selected.
4. Define the Occurrence frequency (Daily, Weekly, or Monthly) and options.
5. Define the Daily frequency.
6. Define the Duration.
7. Click OK.
  The changes are saved and the New Job Schedule page closes.
Click Next.
The Select Report Options page opens.
Set your desired reporting options.
Click Next.
The Complete the Wizard page opens.
Click Finish to complete the wizard.
Repeat steps 13 through 27 for the following databases:

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⁽¹⁾	Microsoft SQL Server Reporting Services
ReportServerTempDB (1)	Microsoft SQL Server Reporting Services
SafeGuard⁽²⁾	powered by Sophos^®
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. 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 now establish a backup procedure which will archive all of your backup files and the contents of the UpdateStorage directory on a regular basis. This can be done through the use of any file backup utility.