SYSCS_UTIL.SYSCS_DELETE_BACKUP

The SYSCS_UTIL.SYSCS_DELETE_BACKUP system procedure deletes a backup that you previously created using either the SYSCS_UTIL.SYSCS_SCHEDULE_DAILY_BACKUP system procedures.

Syntax

SYSCS_UTIL.SYSCS_DELETE_BACKUP( BIGINT backupId );

backupId

Specifies the ID of the backup job you want to delete.

To find the jobId you want to cancel, see the Backing Up and Restoring topic.

Results

This procedure does not return a result.

Execute Privileges

If authentication and SQL authorization are both enabled, only the database owner has execute privileges on this function by default. The database owner can grant access to other users.

Example

If necessary, you can first query the SYS.SYSBACKUP system table to find the BACKUP_ID of the job you want to delete; entries in that table include timestamp information.

And then delete that job:

splice> SELECT * FROM SYS.SYSBACKUP;
BACKUP_ID  |BEGIN_TIMESTAMP           |END_TIMESTAMP            |STATUS  |FILESYSTEM                                     |SCOPE |INCR&|INCREMENTAL_PARENT_&|BACKUP_ITEM
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
40975      |2015-11-25 09:32:53.04    |2015-11-25 09:33:09.081  |S       |/Users/me/Documents/splicemachine/dbBackups    |D     |false|-1                  |93

1 row selected

splice> CALL SYSCS_UTIL.SYSCS_DELETE_BACKUP(40975);
Statement executed.

See Also