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:

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';