Use this command to manually delete a backup set before its retention period expires.
When the server creates a backup set, the retention period assigned to the backup set determines how long the backup set remains in the database. When that date passes, the server automatically deletes the backup set when expiration processing runs. However, you can also manually delete the client's backup set from the server before it is scheduled to expire by using the DELETE BACKUPSET command.
If the REQSYSAUTHOUTFILE server option is set to YES (the default), the administrator must have system privilege. If the REQSYSAUTHOUTFILE server option is set to NO, the administrator must have system privilege or policy privilege for the domain to which the client node is assigned.
.-,-------------------. V | >>-DELete BACKUPSET----+-node_name-------+-+--------------------> '-node_group_name-' .-,---------------. V | >----backup_set_name-+--+--------------------+------------------> '-BEGINDate--=--date-' >--+--------------------+--+------------------+-----------------> '-BEGINTime--=--time-' '-ENDDate--=--date-' .-WHEREDATAType--=--ALL-----------. >--+------------------+--+---------------------------------+----> '-ENDTime--=--time-' | .-,---------. | | V | | '-WHEREDATAType--=----+-FILE--+-+-' '-IMAGE-' >--+--------------------------------+---------------------------> '-WHERERETention--=--+-days----+-' '-NOLimit-' >--+----------------------------------+-------------------------> '-WHEREDESCription--=--description-' .-Preview -=--No------. >--+---------------------+------------------------------------->< '-Preview--=--+-No--+-' '-Yes-'
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. |
EOLM (End Of Last Month) | The last day of the previous month. | EOLM |
EOLM-days | The last day of the previous month minus days specified. | EOLM-1 To include files that were active a day before the last day of the previous month. |
BOTM (Beginning Of This Month) | The first day of the current month. | BOTM |
BOTM+days | The first day of the current month, plus days specified. | BOTM+9 To include files that were active on the 10th day of the current month. |
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. |
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. |
EOLM (End Of Last Month) | The last day of the previous month. | EOLM |
EOLM-days | The last day of the previous month minus days specified. | EOLM-1 To include files that were active a day before the last day of the previous month. |
BOTM (Beginning Of This Month) | The first day of the current month. | BOTM |
BOTM+days | The first day of the current month, plus days specified. | BOTM+9 To include files that were active on the 10th day of the current month. |
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 on the specified end date | NOW+02:00 or +02:00. |
NOW-HH:MM or -HH:MM | The current time minus hours and minutes on the specified end date | NOW-02:00 or -02:00. |
delete backupset pers_data.3099
begindate=11/19/1998 begintime=10:30:05
wheredescription="documentation shop"
Command | Description |
---|---|
DEFINE BACKUPSET | Defines a previously generated backup set to a server. |
DEFINE NODEGROUP | Defines a group of nodes. |
DEFINE NODEGROUPMEMBER | Adds a client node to a node group. |
DELETE NODEGROUP | Deletes a node group. |
DELETE NODEGROUPMEMBER | Deletes a client node from a node group. |
GENERATE BACKUPSET | Generates a backup set of a client's data. |
GENERATE BACKUPSETTOC | Generates a table of contents for a backup set. |
QUERY BACKUPSET | Displays backup sets. |
QUERY NODEGROUP | Displays information about node groups. |
QUERY BACKUPSETCONTENTS | Displays contents contained in backup sets. |
UPDATE BACKUPSET | Updates a retention value associated with a backup set. |
UPDATE NODEGROUP | Updates the description of a node group. |