Use this command to display information about one or more backup sets.
Privilege Class
Any administrator can issue this command.
Syntax
.-*----------------. >>-Query BACKUPSET----+------------------+----------------------> | .-,-----------. | | V | | '----node_name---+-' .-*----------------------. >-----+------------------------+---+---------------------+------> | .-,-----------------. | '-BEGINDate--=--date--' | V | | '----backup_set_name---+-' >-----+---------------------+---+-------------------+-----------> '-BEGINTime--=--time--' '-ENDDate--=--date--' >-----+-------------------+-------------------------------------> '-ENDTime--=--time--' >-----+---------------------------------+-----------------------> '-WHERERETention--=--+-days----+--' '-NOLimit-' >-----+-----------------------------------+---------------------> '-WHEREDESCription--=--description--' >-----+------------------------------------+------------------->< '-WHEREDEVice--=--device_class_name--'
Parameters
You can specify the date by using one of the values below:
Value | Description | Example |
---|---|---|
MM/DD/YYYY | A specific date | 09/15/1999 |
TODAY | The current date | TODAY |
TODAY+days or +days | The current date plus days specified. | TODAY +3 or +3. |
TODAY-days or -days | The current date minus days specified. | TODAY -3 or-3. |
You can specify the date by using one of the values below:
Value | Description | Example |
---|---|---|
HH:MM:SS | A specific time | 10:30:08 |
NOW | The current time | NOW |
NOW+HH:MM or +HH:MM | The current time plus hours and minutes specified | NOW+02:00 or +02:00. |
NOW-HH:MM or-HH:MM | The current time minus hours and minutes specified | NOW-02:00 or -02:00. |
You can specify the date by using one of the values below:
Value | Description | Example |
---|---|---|
MM/DD/YYYY | A specific date | 09/15/1999 |
TODAY | The current date | TODAY |
TODAY+days or +days | The current date plus days specified. The maximum number of days you can specify is 9999. | TODAY +3 or +3. |
TODAY-days or -days | The current date minus days specified. | TODAY -3 or -3. |
You can specify the date by using one of the values below:
Value | Description | Example |
---|---|---|
HH:MM:SS | A specific time | 10:30:08 |
NOW | The current time | NOW |
NOW+HH:MM or +HH:MM | The current time plus hours and minutes specified | NOW+02:00 or +02:00. |
NOW-HH:MM or-HH:MM | The current time minus hours and minutes specified | NOW-02:00 or -02:00. |
Examples
Task
Display information for backup sets whose names begin with PERS_DATA*. The backup sets belong to client node JANE and are assigned to the DCFILE device class.
+--------------------------------------------------------------------------------+ | Node Name: JANE | | Backup Set Name: PERS_DATA.3089 | | Date/Time: 06/09/1999 16:17:47 | | Retention Period: 60 | |Device Class Name: DCFILE | | Description: backupset created from /srvr | | | +--------------------------------------------------------------------------------+
where:
Related Commands
Table 155. Commands Related to QUERY BACKUPSET
Command | Description |
---|---|
DEFINE BACKUPSET | Defines a previously generated backup set to a server. |
GENERATE BACKUPSET | Generates a backup set of a client's data. |
DELETE BACKUPSET | Deletes a backup set. |
QUERY BACKUPSETCONTENTS | Displays contents contained in backup sets. |
UPDATE BACKUPSET | Updates a retention value associated with a backup set. |