![]() |
![]() |
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 168. 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. |