White Papers > Developing a Backup Strategy White Paper > Developing a Backup Strategy > Offline Full Backups

Offline Full Backups

An offline backup involves shutting down the database server before starting the backup and then restarting the database after the backup is complete.

As the database is shut down during the backup process, neither online users nor background processes can access the database for the duration of the backup. You must therefore schedule sufficient time to perform the backup and ensure that the periods when the database is unavailable are acceptable to users.

Use the JADE Database utility to perform offline backups. This ensures that the database is in the correct state and that all necessary database files are backed up. The database files can be optionally verified while being read (which we recommend) and the backup files compressed while being written.

When a file backup completes, the MD5 checksum is automatically recomputed and compared with the value calculated when writing the file.

If you move database backups across media (for example, from disk to disk or tape to disk), it is essential that you verify the resulting files. Use the JADE Database utility verifyChecksums function to recalculate and compare the file checksums with those that were originally written to the backupinfo file.

We cannot stress enough the importance of validating the content of the files written.

It is possible that the operational window of time you have during which you would like to be able to perform an offline backup is too small, due to the size of the database. If so, you will need to perform online backups or to implement a warm standby server or SDE‑based strategy.