Create a restore job

You can create a restore job to execute a restore operation. This job will insert records from an archive file into the MES restore database.

Before starting a restore job, the MES restore database must already exist. It is not created as part of the restore operation. To create an MES restore database, from the post-Install Configurator application:

• Create the restore database using the MES DB Setup component.

• Specify the restore database connection string using the MES DB/MW Communication component.

For more information about these MES components in the post-install Configurator application, see the MES Installation Guide or online help.

Before creating a restore job, make sure that an archive file is available from a previously executed archive job.

Note: You can only perform a Restore from an archive that was created with the version of MES that you are currently running. Restores using an archive from a previous version of MES are not supported and might fail.

Create a restore job

1. Do one of the following:

   • Press the Ctrl+N keys.

   • Right-click in the tab and on the context menu click New.

   • On the ribbon, go to the Home tab and click New.

   A new database job record is added.

2. In the new job's Properties window, complete the following settings:

   Name

   The unique name for the job.

   Description

   A description for the job.

   Type

   Select Restore.

   Details icon

   Click the Details icon and do the following:

   • In the Available Archives list, select the archived dataset zip file from the Database Maintenance folder where the archived data will be restored from.

   • Select the Abort when inserting duplicate check box if you want to abort the restore process when duplicate data is inserted in the restore database.

     Note: Make sure that you do not restore to the original MES database as it will have serious performance implications.

     Date Filter

     Do any one of the following:

   • Click Relative and then specify the number of days to select the data for restoring the records. If the number of days defined is 30, it will restore the data older than 30 days from the current date.

   • Click Absolute and then specify the From and To date to select the data for restoring the records.

3. Save the changes.

You can modify the properties of an existing restore job in the Properties window.