Previous Backups

Views, utilities, and procedures return details about previous backups.

To query SYSIQBACKUPHISTORY and return details about previous backups, enter:

select * from sysiqbackuphistory

In these results, each row represents a successful backup operation:

   bu_id bu_time                 type selective_type virtual_type dependson_id cmd                      creator  version 
-------- ----------------------- ---- -------------- ------------ ------------ ------------------------ -------- -------
  312372 2013-07-15 09:13:54.000    0              0            0            0 backup database to ...   DBA            8

SYSIQBACKUPHISTORY is a system view that stores details about previous backup operations. See Reference: Building Blocks, Tables, and Procedures > System Tables and Views > System Views > Alphabetical List of System Views > SYSIQBACKUPHISTORY System View.

db_backupheader Utility

Reads the first backup archive, returns backup statistics and definitions.

Syntax:

db_backupheader [ path ] backup_file

Execute db_backupheader from the command line. Output includes backup statistics, database definitions, dbspace and dbfile specifics.

sp_iqbackupsummary Procedure

Summarizes backup operations.

Syntax:

sp_iqbackupsummary [ timestamp or backup_id ]

Results are similar to:

backup_id backup_time            backup_type  selective_type virtual_type depends_on_id creator backup_size user_comment backup_command 
--------- ---------------------  ------------ -------------- ------------ ------------- ------- ----------- ------------ -------------------
   312372 2013-07-15 09:13:54.0  Full         All inclusive  Non virtual              0 DBA           50800 (NULL)       backup database to ...

See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of System Stored Procedures > sp_iqbackupsummary Procedure .

sp_iqbackupdetails Procedure

Summarizes operations performed by a particular backup.

Syntax:

 sp_iqbackupdetails 'backup_id'

Results are similar to:

backup_id backup_time             backup_type  selective_type  depends_on_id dbspace_id dbspace_name   dbspace_rwstatus  dbspace_createid   ...
--------- ----------- ---------- ------------- --------------  ------------- ---------- ------- ------ ----------------- -----------------  ...
   312372 2013-07-15 09:13:54.0   Full         All inclusive               0          0 system         ReadWrite                        0   ...
   312372 2013-07-15 09:13:54.0   Full         All inclusive               0      16384 IQ_SYSTEM_MAIN ReadWrite                        0   ...
   312372 2013-07-15 09:13:54.0   Full         All inclusive               0      16387 iq_main        ReadWrite                        6   ...

This example omits some columns that appear in the output. See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of System Stored Procedures > sp_iqbackupdetails Procedure.

sp_iqrestoreaction Procedure

Identifies actions required to restore the database to a consistent state for a given date.

Syntax:

sp_iqrestoreaction 'timestamp'

Results are similar to:

sequence_number    backup_id backup_archive_list  backup_time           virtual_type  restore_dbspace restore_dbfile backup_comment                                                                                                                                                                                                                                              
--------------- ------------ -------------------- --------------------- ------------- --------------- -------------- --------------------------
              1        1192  c:\\\\temp\\\\b1     2008-09-23 14:47:40.0  Non virtual
              2        1201  c:\\\\temp\\\\b2.inc 2008-09-23 14:47:40.0  Non virtual
              3        1208  c:\\\\temp\\\\b3.inc 2008-09-23 14:47:40.0  Non virtual

See Reference: Building Blocks, Tables, and Procedures > System Procedures > Alphabetical List of System Stored Procedures > sp_iqrestoreaction Procedure.