Manage the History Database

You can manage your History data by archiving and purging the data.

Archive the History Database

Use the AVEVA Recipe Management History Archiving utility to archive the current History database and replace it with a new History database with current date extension. The new database will act as the operational or active database, and the old database will act as an archived database. Before running the utility, make sure that the user is an administrator.

The utility also provides information related to the history database(s) that are used by active Formula/Recipes.

NOTE: Archiving of the database is allowed only once in a day. If you try to archive more than once, an error message will appear.

To archive the History database

1. Open the AVEVA Recipe Management Archive Utility. The AVEVA Recipe Management History Archive Utility dialog box appears.

2. The Database section of the utility displays the following:

   • Current History Database (To Archive): Displays the current operational database that the user want to archive.

   • New History Database (Operational): Displays the new History database name which will become the current operational database.

3. In the SQL Administrator Login (Create Database) section of the utility, you can configure one of the following:

   • Click Windows Authentication to use the interactive user’s account.

   • Click SQL Server Authentication and specify the User Name and the Password. This connection information is used only for completing the configuration and is not stored.

   NOTE: The user specified in SQL Administrator Login (Create Database) area must have SQL DB creator rights to create the new History DB and appropriate privileges to modify the AVEVA Recipe Management database.

4. Click Create Archive. A confirmation dialog box appears.

   NOTE: In the case, the current History database is in use by the active Formula/Recipes, a warning message will appear. You should not remove any archived databases from the system that are listed in this warning.

5. Click OK. The current History database will be archived, and the AVEVA Recipe Management History database appended with current date such as, RecMngrPlusHistoryDB_20190315 will be created which will act as the new History database.

   NOTE: After archiving, make sure to create a new SSRS report folder and point its data source to the current operational History database. See the SSRS Reports section for more details.

Purge the History Database

Purging the data deletes the historical data from the operational History database permanently, thereby increasing the available disk space in the computer where the database resides. The default value for “History Auto Purge” is 28 days which can be configured as per your requirement using the System Configuration menu. If you plan on using the archive feature, you would typically disable the Auto Purge feature by setting this value to 0. For more information, refer to the Configuring History Auto Purge Settings topic.