Rockwell Automation Energy Management Accelerator Toolkit Quick Start - Manual (Page 201)

Rockwell Automation Publication IASIMP-QS016C-EN-P - October 2014 201
FactoryTalk EnergyMetrix Software and PowerMonitor Device Maintenance Chapter 10
Set Up Database Maintenance
FactoryTalk EnergyMetrix software connects to the Microsoft SQL database named EMMA to store configuration
parameters and logged data. It is a system requirement to back up and shrink the EMMA database on a regular schedule.
Backups create a record of the database so it may be restored in case of database corruption or a system crash. Regularly
scheduled database backup and shrink operations control the growth of the SQL transaction log.
Many FactoryTalk EnergyMetrix software users maintain established backup and archiving procedures for business
databases. FactoryTalk EnergyMetrix software does not have any unusual database maintenance requirements, so
established IT database procedures will generally meet the backup needs. Rockwell Automation recommends a daily
scheduled backup and shrink of the EMMA database.
If your site does not have established database administration routines, the following steps are suggested to provide a basic
level of database management. Also, refer to Microsoft SQL Server documentation for database backup, shrink, and restore
procedures.
Follow these steps to set up a database maintenance plan in Microsoft SQL Server 2005.
1. Access the FactoryTalk EnergyMetrix server and log in as an administrator.
2. Open Microsoft SQL Server Management Studio.
3. Connect to the local server by using Windows
authentication.
4. Open the Management folder in the tree, and select
Maintenance Plans.
5. Right-click the Maintenance Plans folder and choose New
Maintenance Plan.
6. Type in a name for the plan and click OK.