sp_iqbackupdetails procedure

Function

Shows all the dbfiles included in a particular backup.

Syntax

sp_iqbackupdetails  backup_id 

Parameters

backup_id Specifies the backup operation transaction identifier.

NoteYou can obtain the backup_id value from the SYSIQBACKUPHISTORY table. Run the following query: select * from sysiqbackuphistory

Permissions

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

Description

sp_iqbackupdetails returns the following:

Table 7-2: sp_iqbackupdetails 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."

depends_on_id

Identifier for previous backup that the backup depends on.

dbspace_id

Identifier for the dbspace being backed up.

dbspace_name

Name of the dbspace from SYSIQBACKUPHISTORYDETAIL. If dbspace name matches the dbspace name in SYSDBSPACE for a given dbspace_id. Otherwise “null.”

dbspace_rwstatus

“ReadWrite” or “Read Only.”

dbspace_createid

Dbspace creation transaction identifier.

dbspace_alterid

Alter DBSPACE read-write mode transaction identifier.

dbspace_online

Status. Values are “Online” or “Offline.”

dbspace_size

Size of dbspace, in KB, at time of backup.

dbspace_backup_size

Size of data, in KB, backed up in the dbspace.

dbfile_id

Identifier for the dbfile being backed up

dbfile_name

The logical file name, if it was not renamed after the backup operation. If renamed, “null.”

dbfile_rwstatus

“ReadWrite” or “Read Only”.

dbfile_createid

Dbfile creation transaction identifier.

dbfile_alterid

Alter DBSPACE alter FILE read-write mode transaction identifier

dbfile_size in MB

Size of the dbfile, in KB.

dbfile_backup_size

Size of the dbfile backup, in KB.

dbfile_path

The dbfile path from SYSBACKUPDETAIL, if it matches the physical file path (“file_name”) in SYSDBFILE for a given dbspace_id and the dbfile_id. Otherwise “null.”

Example

Sample output from sp_iqbackupdetails:

backup_id   backup_time             backup_type   selective_type   depends_on_id   
      883   2008-09-23 13:58:49.0   Full          All inclusive                0

dbspace_id   dbspace_name   dbspace_rwstatus   dbspace_createid
         0   system         ReadWrite                         0

dbspace_alterid   dbspace_online dbspace_size dbspace_backup_size dbfile_id
              0                0         2884                2884         0

dbfile_name dbfile_rwstatus dbfile_createid dbfile_alterid dbfile_size
     system        ReadWrite                 0               0       2884
dbfile_backup_size dbfile_path  
             2884  C:\\Documents and Settings\\All Users\\SybaseIQ\\demo\\iqdemo.db 

              

See also

“SYSIQBACKUPHISTORY system view”