Blog author:
Jvprabhusanthi | Posted on: 5/10/2012 | Category:
SQL Server Blogs | Views: 679 | Status:
[Member] |
Points: 75
|
Alert Moderator
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'
Cheers,
Venkatesan Prabu .J
Head, KaaShiv InfoTech
http://kaashivinfotech.com/Ebooks.aspx
Found interesting? Add this to: