Notitie
Voor toegang tot deze pagina is autorisatie vereist. U kunt proberen u aan te melden of de directory te wijzigen.
Voor toegang tot deze pagina is autorisatie vereist. U kunt proberen de mappen te wijzigen.
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
You can grant EXECUTE permissions on this procedure, but these permissions might 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
EXECUTE sp_delete_database_backuphistory @database_name = 'AdventureWorks2022';