Back Up a Database
Before you can back up a database, the
installation containing the database must be connected in the Instance Explorer (see
Connect to an Actian Database Instance). You must also be connected as the installation owner.
You can back up a system or user database the following ways:
• From the context menu of a Database node: DBA Utilities, Back Up
• On the main menu ribbon when a Database node is selected in the Instance Explorer:
Database, Database, Back Up (see
Database Tab)
For more information about backing up, see the ckpdb command in the Ingres Command Reference Guide.
To back up a selected database
1. Initiate the Back Up command in one of the ways explained previously.
2. On the General page, select the backup target for the database.
• If you selected Entire database: Specify the journaling status for this backup.
• If you selected Selected tables in a database: Click Tables and select the tables to include in the backup, then click OK.
3. Specify whether you want to destroy previous backups and journal files.
4. Choose whether you want the backup reported verbosely.
6. Specify whether to wait for the database to become inactive before starting the backup.
7. Set whether you want the database to be locked exclusively for the backup.
8. (For multi-location databases) Specify the number of parallel backups.
9. Specify the time to wait for active sessions to cease before abandoning the backup.
10. Click OK to start the backup.
The Progress indicator displays a spinner while the backup is being performed.
When the backup completes, output is displayed in the Output Log page of the dialog. A successful backup is indicated by the final line of output:
date/time CPP: Completed checkpoint of database: database_name
11. Click Close.
Last modified date: 04/24/2023