sp_delete_database_backuphistory (Transact-SQL)
Applies to:
SQL Server
Deletes information about the specified database from the backup and restore history tables.
Transact-SQL syntax conventions
Syntax
sp_delete_database_backuphistory [ @database_name = ] N'database_name'
[ ; ]
Arguments
[ @database_name = ] N'database_name'
Specifies the name of the database involved in backup and restore operations. @database_name is sysname, with no default.
Return code values
0
(success) or 1
(failure).
Result set
None.
Remarks
sp_delete_database_backuphistory
must be run from the msdb
database.
This stored procedure affects the following tables:
- backupfile
- backupfilegroup
- backupmediafamily
- backupmediaset
- backupset
- restorefile
- restorefilegroup
- restorehistory
Permissions
This stored procedure is owned by the db_owner role. You can grant EXECUTE
permissions for any user, but these permissions may be overridden during a SQL Server upgrade.
Examples
The following example deletes all entries for the AdventureWorks2022
database in the backup-and-restore history tables.
USE msdb;
GO
EXEC sp_delete_database_backuphistory
@database_name = 'AdventureWorks2022';