Ongoing database maintenance is extremely important for the health of your InterAction system, especially as users add more information to the database. Failing to adequately maintain the database can result in poor performance and user frustration.
Consult your specific database platform documentation for recommended maintenance tasks.
To perform these tasks, you must have access to the database system administrator account. You also need access to the InterAction Administrator application.
See Database Disaster Recovery for more information.
Summary of Database Maintenance Tasks
| Task | Frequency | For more information, see the following .... |
|---|---|---|
| Back up the database |
Twice a day (for instance, 12 AM and 12 PM). This should be scheduled to run automatically. |
Documentation for your database platform |
| Back up the transaction logs | At least four times a day (for instance, 10 AM, 2 PM, 4 PM, and 6 PM). This should be scheduled to run automatically. | Documentation for your database platform |
| Test that the backups are operating normally | Quarterly | Documentation for your database platform |
| Update the database indexes | Varies depending on the average number of changes. See “Updating Database Indexes and Statistics” below. | The InterAction Support Center Web site for resources |
| Update the database statistics | Varies depending on the average number of changes. See “Updating Database Indexes and Statistics” below. | The InterAction Support Center Web site for resources |
Updating Database Indexes and Statistics
How frequently you need to update the database indexes and statistics depends on how frequently users edit and add data to the system. This may vary at different times in your organization - for example, you may need to run these scripts frequently immediately after the rollout when users are adding new data and performing imports. Later, as the amount of new information levels off, you can do these tasks less frequently.
As a general rule, you should update the indexes and statistics every time the data changes by 10%. Use the tools included with your database platform to track the rate of data changes.