DELETE BACKUP HISTORY TABLES

The following example deletes all entries that are older than August 20, 1998, 12:00 A.M. in the backup and restore history tables.
Copy Code
USE msdb;
GO
EXEC sp_delete_backuphistory '08/20/98';