Groom and backup synchronization
By default, the system synchronizes your GROOM TABLE request with the most recent backup set to avoid reclaiming rows that are not yet captured by incremental backups. In other words, GROOM TABLE does not remove any data that has been deleted or is outdated but which has not been saved in a backup.
- Run a full backup.
- Delete data B.
- Run an incremental backup, which captures data B marked as deleted.
- Delete D.
- Run GROOM TABLE, which removes B but not D, because D was not captured in the last backup.
If you maintain two backup sets for a database and you do not want the GROOM TABLE command to use the default backup set, you can use the backupset option to specify another backup set. Run the backup history report to learn the ID of the backup set you want to specify.