| How to delete old data from msdb |
|
|
|
|
Every time we do a backup or restore process, it will have an entry in the MSDB system database. Hence the MSDB will grow eventually & it will make the backup check queries slow. The tables it will be referring to are BackupFile To avoid this situation we have to schedule we have to schedule maintenance plan to purge old data from MSDB. Also we can manually delete the old data using the following system stored procedures. sp_delete_backuphistory Syntax Exec sp_delete_backuphistory '05/05/09' The above query will delete all backup,restore entries prior to date 05/05/09.
This above query will delete the entire backup restore entries history for pubs database.
Comments (45)
Powered by !JoomlaComment 4.0 beta2
|


