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...

1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: