sp_iqbackupsummary procedure

Function

Summarizes backup operations performed.

Syntax

sp_iqbackupsummarytimestamp or backup_id ]

Parameters

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.

Permissions

DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.

Description

sp_iqbackupsummary returns the following:

Table 7-3: sp_iqbackupsummary columns

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)

Example

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'