Database Maintenance Plan

Introduction

This topic describes how to make database maintenance on SQL/MySQL.

Table Of Content

Maintenance operations on the database can be done in two different ways:

1.By creating a job policy of type "Maintenance Plan" which will trigger the execution of the built-in maintenance plan (preferred method).

2.By manually installing and scheduling a maintenance plan for each TSS installed. The maintenance plan vary following the target database engine:

•Microsoft SQL Server

•MySQL