sp_delete_database_backuphistory (Transact-SQL)

APPLIES TO: yesSQL Server (starting with 2008) noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

Deletes information about the specified database from the backup and restore history tables.

Topic link icon Transact-SQL Syntax Conventions

Syntax

  
sp_delete_database_backuphistory [ @database_name = ] 'database_name'  

Arguments

[ @database_name = ] 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 Sets

None

Remarks

sp_delete_database_backuphistory must be run from the msdb database.

This stored procedure affects the following tables:

Permissions

Requires membership in the sysadmin fixed server role.

Examples

The following example deletes all entries for the AdventureWorks2012 database in the backup-and-restore history tables.

USE msdb;  
GO  
EXEC sp_delete_database_backuphistory @database_name = 'AdventureWorks2012';  
  

See Also

sp_delete_backuphistory (Transact-SQL)
Backup History and Header Information (SQL Server)