Using the Supplied Online Backup Dialog

The Backup Database dialog, provided by the backup service contained in the database administration framework, enables runtime databases to be backed up while the database remains active for both read and write access. Alternatively, you can change the database mode so that the database is locked for write access.

To use the Backup Database dialog

  1. In the Backup Directory text box, specify the path of the destination directory in which your database files are to be backed up, as shown in the following example of the backup directory on the c: drive of your database server workstation.

    c:\jade\backup

    You must specify a directory that is valid on the server. If it does not exist, it is created.

    Alternatively, click the adjacent browse button (indicated by the … points of ellipsis symbol) to display the common Browse for Folder dialog that enables the selection of the backup directory in which the backed up database files will be located.

  2. In the Backup Mode group box, select the Quiesced - Read Only option button if you want a quiesced read-only backup operation. When you select this option, the database is placed in a quiescent state by first allowing current active transactions to complete, flushing modified buffers from cache to the stable database.

    In this state, physical database files contain all committed updates to the database and the files are opened in read-only mode with shared read access, allowing external backup processes to safely copy database files. In a quiescent backup, updating transactions are not permitted and attempts to execute database transactions raise a database exception. When a backup is performed in a quiescent state, the physical database files are guaranteed to contain all database updates and a quiesced backup does not require backup recovery.

    By default, the Online - Updating Allowed option is selected, indicating that updates are allowed during the backup process. When restoring a database backed up fully online (that is, the database was available for both read and write access at the time of the backup), the restoration process requires the recovery of backed up transaction recovery journals. A backup recovery is required after restoring files that were fully backed up online by using this default option.

  3. Check the Compress Files check box if database files are to be compressed as they are backed up. By default, database files are not compressed.

  4. Check the Overwrite Existing Files check box to allow any existing files in the specified destination backup directory to be overwritten as the database is backed up. By default, existing files are not overwritten.

  5. Click the OK button. Alternatively, click the Cancel button to abandon your selections.

A fast backup is performed if files are neither verified nor compressed. In a fast file backup, database files are backed up in a similar fashion to a standard file copy, using large buffers and asynchronous I/O to speed up the copy process. The fast backup mode bypasses the database access-routines and cache management, and does not verify data as it is backed up.

You must set the help file that you require (for example, the JADE.pdf file or your own help file) in the Help File text box in the Application sheet of the Define Application dialog.

If no errors are detected, the backup proceeds.

For details about using this same dialog to backup your JADE development environment database, see "Backing Up Your JADE Development Environment", in Chapter 3 of the JADE Database Administration Guide.