Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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
EXEC sp_delete_database_backuphistory
@database_name = 'AdventureWorks2022';