There are many geodatabase maintenance tasks that need to be performed on a regular basis. Most of the tasks are standard maintenance for all database management systems (DBMS), such as database backup and database statistics generation. Other maintenance, such as compressing and synchronizing a geodatabase replica, is a geodatabase-specific maintenance. All maintenance tasks help protect the database and maintain its existing performance levels.
The following are some of the Geodatabase maintenance tasks:
- Database backup and recovery-the data stored in the Geodatabase must be protected from loss or corruption. For this purpose, the database administrator creates a backup, a recurring copy, or a snapshot of the database. The database administrator must also be able to use these backups to recover data in the event of a hardware failure or data corruption.
- UPDATE STATISTICS-when data and components in a geodatabase change, table and index statistics become obsolete. This is a problem because the database uses statistics to process queries from users or client applications. Therefore, database statistics must be updated regularly.
- Update Raster Catalog Footprints-If you make changes to the raster catalog outside of ArcGIS, you must update the catalog footprints. To learn how to do this, see Update your Geodatabase (geodatabase) Raster catalog footprints.
- Compress versioned geodatabases-When you perform an edit operation on a versioned geodatabase, the number of States and rows in the delta tables increases, which degrades database performance. Compacting a geodatabase removes states that a version no longer references, and moves rows from the delta tables to the base table.
- Synchronizing replicated data with the parent Geodatabase-if you have a field worker or branch office that uses a geodatabase replica in your site, you need to move the data into and out of the primary database and manage the replicas.
- Upgrading Geodatabases-To use the new features, you need to periodically upgrade the software by installing a newer version or by installing a patch pack or patch. Upgrade the geodatabase after the software upgrade.
What type of maintenance does a geodatabase require?
