Home > IT Blogs > SQL Server with Mr. Denny/

SQL Server with Mr. Denny:

sp_delete_backuphistory

1
June 1, 2009  1:00 PM

Clean up the backup history



Posted by: Denny Cherry
Backup & recovery, Database Administration, sp_delete_backuphistory

Something that most people don't release needs a little TLC in SQL Server is the backup history. Every time a database is backed up records are written about it.  Over time this can add up to a lot of useless data floating around the SQL Server in the msdb database. If you like to use the UI...

  Bookmark and Share     2 Comments     RSS Feed     Email a friend

1