We have created database backup with the help of the below query.
BACKUP DATABASE ddbname TO "/part1/memsql-data/da_backup
Now we have multiple backup files present in the server and we want to delete a few of them.
I know the query SELECT * FROM information_schema.MV_BACKUP_HISTORY ORDER BY Backup_Id; list available backup file with backup ID.
Can anyone know the query to delete backup with the ID?
Please note we haven’t installed memsql-ops cli.