Administrator's Reference

QUERY BACKUPSET (Query a Backup Set)

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

node_name
Specifies the name of the client node whose data is contained in the backup set to be displayed. The node name you specify can contain wildcard characters. You can specify more than one node name by separating the names with commas and no intervening spaces.

backup_set_name
Specifies the name of the backup set whose information is to be displayed. The backup set name you specify can contain wildcard characters. You can specify more than one backup set name by separating the names with commas and no intervening spaces.

BEGINDate
Specifies the beginning date of the range in which the backup set to be displayed must have been created. This parameter is optional. You can use this parameter with the BEGINTIME parameter to specify a range for the date and time. If you specify a begin date without a begin time, the time will be at 12:00 a.m. (midnight) on the date you specify.

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.

BEGINTime
Specifies the beginning time of the range in which the backup set to be displayed must have been created. This parameter is optional. You can use this parameter with the BEGINDATE parameter to specify a range for the date and time. If you specify a begin time without a begin date, the date will be the current date at the time you specify.

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.

ENDDate
Specifies the ending date of the range in which the backup set to be displayed must have been created. This parameter is optional. You can use this parameter with the ENDTIME parameter to specify an ending date and time. If you specify an end date without an end time, the time will be at 11:59:59 p.m. on the specified end date.

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.

ENDTime
Specifies the ending time of the range in which the backup set to be displayed must have been created. This parameter is optional. You can use this parameter with the ENDDATE parameter to specify a date and time. If you specify an end time without an end date, the date will be the current date at the time you specify.

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.

WHERERETention
Specifies the retention period, specified in days, that must be associated with the backup sets to be displayed. The values are:

days
Specifies that backup sets that are retained this number of days are displayed.

NOLimit
Specifies that backup sets that are retained indefinitely are displayed.

WHEREDESCription
Specifies the description that must be associated with the backup set to be displayed. The description you specify can contain wildcard characters. This parameter is optional.

WHEREDEVice
Specifies the name of the device class that must be associated with the backup set to be displayed. You can use wildcard characters to specify a device class name. This parameter is optional.

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.

Command:
query backupset jane pers_data*

Output:
 
+--------------------------------------------------------------------------------+
|        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:

Node Name
Specifies the name of the client node whose data is contained in the backup set.

Backup Set Name
Specifies the name of the backup set.

Date/Time
Specifies the date and time the backup set was created.

Retention Period
Specifies the number of days that the backup set is retained on the server.

Device Class Name
Specifies the name of the device class for which the volumes containing the backup set is assigned.

Description
Specifies the description associated with the backup set.

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.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]