Clearing Backup History
You can remove all the entries in the MV_
table in the information_
database by running CLEAR BACKUP_
.
information_
is populated only when the BACKUP DATABASE
command is run to create a database backup.
Selectively Delete Rows from information_
To clean up individual rows specific to a particular backup use:
CLEAR BACKUP_HISTORY backup_id = <id>;
or
CLEAR BACKUP_HISTORY <success/failure>;
Success/failure are listed in the STATUS
column of the MV_
table.
Last modified: May 5, 2023