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
Collapse the table of content
Expand the table of content
Expand Minimize

sp_delete_database_backuphistory (Transact-SQL)

Updated: 15 September 2007

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

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 AdventureWorks database in the backup-and-restore history tables.

USE msdb;
EXEC sp_delete_database_backuphistory 'AdventureWorks';

Release History

15 September 2007

Changed content:
  • Corrected syntax to use @database_name (instead of the incorrect term @db_nm).

5 December 2005

New content:
  • Added the Remarks section.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft