Backing up, repairing, and rebuilding databases
If you continually delete obsolete data to keep the database clean, also perform periodic database maintenance tasks to improve performance.
Shutting down databases for UNIX
Shut down a database before backing it up, repairing it, or restoring it from backup.
Backing up databases nightly
Back up your databases. Backups help queries run more quickly and updates the database statistics.
Repairing database indexes for all tables weekly
To reduce fragmentation, repair database indexes weekly for all tables.
Rebuilding databases monthly
To reduce fragmentation of the databases, rebuild the database monthly by packing and unpacking it.
Feedback