In this article, we’ll see the how the backup-and-restore meta-data tables store the information in the MSDB database.
- How do you delete six months old data to reduce the size of the backup and restore history tables?
- How do you get the Backup History for a specific database including the size, location, and LSN?
- How do you create and restore a marked transaction?
- How do you find the RESTORE HISTORY of the database?
- How do you list the last 30 days restore history at the instance level?
- How do you measure the database backup or database restore operation progress?
- How do you measure the database growth using backup size?
- How do you define or estimate the storage required for database backup?
- How do you get most recent database backup time for each database?
- How do you get recent database backup time for each database using PowerShell?
- How do you get recent database backup time for each database across multiple servers using PowerShell?
- How do you find the backup history with duration and compressed backup size columns?
Continue reading…