Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

sp_delete_database_backuphistory (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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

Applies to: SQL Server (SQL Server 2008 through current version).

Topic link icon Transact-SQL Syntax Conventions

sp_delete_database_backuphistory [ @database_name = ] 'database_name'

[ @database_name= ] database_name

Specifies the name of the database involved in backup and restore operations. database_name is sysname, with no default.

0 (success) or 1 (failure)

sp_delete_database_backuphistory must be run from the msdb database.

This stored procedure affects the following tables:

Requires membership in the sysadmin fixed server role.

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

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

Community Additions

© 2015 Microsoft