Summarizes backup operations performed.
sp_iqbackupsummary [ timestamp or backup_id ]
timestamp or backup_id Specifies the interval for which to report backup operations. If you specify a timestamp or a backup ID, only those records with backup_time greater than or equal to the time you enter are returned. If you specify no timestamp, the procedure returns all the backup records in ISYSIQBACKUPHISTORY.
DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.
sp_iqbackupsummary returns the following:
Column name |
Description |
|---|---|
backup_id |
Identifier for the backup transaction |
backup_time |
Time of the backup |
backup_type |
Type of backup: “Full,” “Incremental since incremental,” or “Incremental since full” |
selective_type |
Subtype of backup: "All Inclusive", "All RW files in RW dbspaces", "Set of RO dbspace/file" |
virtual_type |
Type of virtual backup: “Non-virtual,” “Decoupled,” or “Encapsulated” |
depends_on_id |
Identifier for backup that the backup depends on |
creator |
Creator of the backup |
backup_size |
Size, in KB, of the backup |
user_comment |
User comment |
backup_command |
The backup statement issued (minus the comment) |
Sample output of sp_iqbackupsummary:
backup_id backup_time backup_type selective_type virtual_type 883 2008-09-23 13:58:49.0 Full All inclusive Non virtual depends_on_id creator backup_size user_comment backup_command 0 DBA 10864 backup database to 'c:\\\\temp\\\\b1'
