About database maintenance

ACT! Premium Web 2005 Server

About database maintenance

The administrator of a database can perform preventative and corrective maintenance to safeguard data. This becomes extremely important in multi-user environments or when many changes are made to the database.

Preventative maintenance, such as re-indexing data, removing obsolete data, and checking for duplicate records enables your database to run efficiently and improves performance. Some maintenance tasks require all users to sign off so the database can be locked, but those can be scheduled for off-peak hours or even overnight.

Backing up your database and personal files enables you to recover quickly from unexpected system failures by restoring the backup files.

How do I...?

Check and repair database

Scan for duplicate records

Copying or moving a contact record

Lock the database

Back up the system database

Back up personal files

Related topics

About restoring databases

Tips for maintaining your database