Database maintenance is an activity designed to keep a database running smoothly. A number of different systems can be used to build and maintain databases, with one popular example being MYSQL. The maintenance of databases is generally performed by people who are comfortable and familiar with the database system and the specifics of the particular database, although some maintenance tasks can be performed by people who do not have experience.
Databases are used to maintain a library of information in a well organized, accessible format. They usually are not static, however, because changes are constantly being made as material is added, removed, and moved around. People may also change parameters within the database, decide to use different indexing systems, and so forth. Over time, this can cause the database to start to malfunction. Database maintenance is used to keep the database clean and well organized so that it will not lose functionality.
One important aspect of maintaining a database is simply backing up the data so that, if anything happens, there will be another copy available. Some databasing systems actually do this automatically, sending a backup to another location every day, every week, or within any other set period of time. Backups are usually not enough, however.
Creating a Backup and Restore Strategy.
Re-building indexes and Removing index fragmentation
Doing Database consistency Checks.
Managing the size of the data.
Managing the Log files