Maintaining database integrity

One of the most important responsibilities of a database administrator is to maintain the integrity of the database and prevent it from becoming corrupted.

Derby must be able to sync to disk. Some machine, disk, or operating system settings can prevent a proper sync and cause unrecoverable database corruption in the event of a power failure, system crash, or software crash. To avoid database corruption, you can do the following:

Many corruption issues can arise from improper backups or restores. Back up your database in a way that prevents it from becoming corrupted:

After you perform a backup, check the consistency of the database. See Checking database consistency for details.

See Backing up and restoring databases for more information.

Related concepts
Checking database consistency
Backing up and restoring databases
Importing and exporting data
Replicating databases
Logging on a separate device
Obtaining locking information
Reclaiming unused space