Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Manufacturing Execution System 2023 R2

TABLE OF CONTENTS

Create an SQL database maintenance backup plan

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
  • Last UpdatedJan 21, 2025
  • 2 minute read

Following is the procedure for creating a database maintenance plan for an example system that includes System Platform, Historian, MES, and BI Gateway databases.

Create an SQL database maintenance backup plan

  1. Make sure the SQL Server Agent is running.

    SQL Server Object Explorer panel with the running SQL Server Agent node selected.

  2. Create a new Maintenance Plan and name it Backup.

    SQL Server Object Explorer panel showing the open New Maintenance Plan dialog displayed after its selection from the Maintenance Plan folder shortcut menu.

  3. Add sub-plans for each scheduled period. In this case:

    • Weekly

    • Daily

    • Hourly

      SQL Server Object Explorer maintenance plan design dialog showing weekly daily and hourly subplans.

  4. Set the Schedule for each subplan.

    SQL Server Object Explorer example weekly backup job schedule dialog describing frequency and scheduling details for the job.

    SQL Server Object Explorer example daily backup job schedule dialog describing frequency and scheduling details for the job.

    SQL Server Object Explorer example hourly backup job schedule dialog describing frequency and scheduling details for the job.

  5. For each subplan, add the maintenance plan tasks from the Toolbox window as suggested below.

    • Weekly: Back Up Database Task of type Full, followed by a Maintenance Cleanup Task that deletes the backups that preceded the full backup by a specified time period.

      SQL Server Object Explorer toolbox maintenance plan task window showing recommended weekly tasks including full database backup and clean up tasks.

    • Daily: Back Up Database Task of type Differential, followed by a Maintenance Cleanup Task that deletes the backups that preceded the differential backup by a specified time period.

    • Hourly: Back Up Database Task of type Differential.

  6. Specify the databases to be included in the full database backup tasks as follows:

    • Database Server, Weekly: Galaxy repository databases, Work Tasks repository databases

    • Database Server, Daily: MES database, Work Tasks Farm database, Historian (Runtime) database

    • Report Server, Weekly: main, msdb, ReportServer, BI Gateway database

  7. Specify the databases to be included in the Differential Database Backup as follows:

    • Database Server, Hourly: MES database, Historian (Runtime) database

Related Links
TitleResults for “How to create a CRG?”Also Available in