Topic 9.3.1-Data Archival, Purge, and Restore Overview
Overview
You can use the new Archive, Purge, and Restore feature introduced in MES 4.0 and the Database Maintenance Utility to archive, purge, and restore the MES database. This section allows you to create, run, delete, modify, and view the Archive, Purge, and Restore (APR) jobs.
Using the Archive, Purge, and Restore Functions
The following example uses a 2008 Server machine with SQL Server 2008 and the Wonderware MES Software/Operations. The database being restored is called MESDB; however, your database name will differ.
Configuration Prerequisites
Before using these features, you must configure the Archive parameters. To configure the Archive parameters:
Step:1 Start the Wonderware MES Client and click the General Parameters tab.
Step:2 Click Archive.
The Archive section has three parameters. You will use the default settings for the Archive query window size (hours) and Archive root directory path parameters. You can change the settings later if necessary.
The Archive query window size (hours) parameter controls the span of individual recordsets retrieved during the archive, purge, and restore operations. Basically, this parameter will change the number of records retrieved at one time from the tables to be archived. This parameter can be varied to influence the speed of the archive, purge, or restore operations. This will potentially increase or decrease the impact of these operations on other database operations within the system.
Step:3 In the Archive server host field, enter the server name where the Archive database is located. In this example, the TSVM2008 server is used.
Step:4 Expand the Data Entry field.
Step:5 In the Archive database name field, enter the name of the database where you will restore the data after it was archived. In this example, the MESDB database is used
Step:6 In the Archive database server name field, enter the server name where the Archive database is going to reside. In this example, TSVM2008 is used.
Step:7 For the Day to archive data parameter, use the default Daily setting.
Set Up the Database Connection
Next set up the database connection string to point to the correct database for restoring the data to the restore database, MESDB.
Open and log on to the Database Connection Editor.
Step:2 Click the Restore tab.
Step:3 In the Server Name field, enter the name of the Archive database server.
Step:4 In the Database Name field, enter the target restore database.
Step:5 Test the connection and save.
Step:6 Restart the middleware.
