Database

Database maintenance.

Database maintenance is a recurrent issue, and there are multiple approaches in maintaining a database. This document addresses the following areas of database maintenance:

Data and log file management
Index fragmentation
Statistics
Corruption detection
Backups.

Remember

A database that does not have an effective maintenance plan can develop problems in one or more areas, which can lead to poor application performance or even downtime and data loss.