For every database backup/Restore,SQl server mantains the track of it's history in msdb database.
Backup related system tables:
msdb..backupmediafamily
msdb..backupfilefroup
msdb..backupfile
msdb..backupmediaset
msdb..logmarkhistory
Restore Database related System tables:
msdb..restorefile
msdb..restorefilegroup
msdb..restorehistory
msdb..suspect_pages
master..sysopentapes
To reduce the number of rows in the restore history table and in other backup and history tables, execute the sp_delete_backuphistory stored procedure.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment