Deletes information about the specified database from the backup and restore history tables.
Transact-SQL Syntax Conventions
sp_delete_database_backuphistory [ @database_name = ] 'database_name'
Specifies the name of the database involved in backup and restore operations. database_name is sysname, with no default.
0 (success) or 1 (failure)
None
sp_delete_database_backuphistory must be run from the msdb database.
This stored procedure affects the following tables:
Requires membership in the sysadmin fixed server role.
The following example deletes all entries for the AdventureWorks database in the backup-and-restore history tables.
AdventureWorks
USE msdb; GO EXEC sp_delete_database_backuphistory 'AdventureWorks';
15 September 2007
5 December 2005