# Clearing Backup History

You can remove all the entries in the `MV_BACKUP_HISTORY` table in the `information_schema` database by running `CLEAR BACKUP_HISTORY;`.

`information_schema.MV_BACKUP_HISTORY` is populated only when the `BACKUP DATABASE` command is run to create a database backup.

**Selectively Delete Rows from `information_schema.MV_BACKUP_HISTORY`**

To clean up individual rows specific to a particular backup use:

```sql
CLEAR BACKUP_HISTORY backup_id = <id>;
```

or

```sql
CLEAR BACKUP_HISTORY <success/failure>;
```

Success/failure are listed in the `STATUS` column of the `MV_BACKUP_HISTORY` table.

***

Modified at: May 5, 2023

Source: [/db/v9.1/manage-data/back-up-and-restore-data/types-of-backups/clearing-backup-history/](https://docs.singlestore.com/db/v9.1/manage-data/back-up-and-restore-data/types-of-backups/clearing-backup-history/)

(An index of the documentation is available at /llms.txt)