Deleting backup and restore history

Usually, backup and restore history will be available in the MSDB database(Microsoft Database). It's advisable to cleanup the database after archiving the databases.

 

Scenario: Considering, am having daily backups and after two years the database will be archived. In that case, the backup and restore information which is happened before two years need not be maintained and we can go for cleanup. In that case, we are using the below command to cleanup the database. You need to specify the exact dates. So that, data before that dates will be cleaned up.

 

USE msdb

EXEC sp_delete_backuphistory '1/31/2011'

Ebook Download
View all
Learn
View all