Know more about SQL Server MSDB log store for database backups, restores, and recovery: Q& A – Part 3

In this article, we’ll see the how the backup-and-restore meta-data tables store the information in the MSDB database.

1. How do you delete six months old data to reduce the size of the backup and restore history tables?
2. How do you get the Backup History for a specific database including the size, location, and LSN?
3. How do you create and restore a marked transaction?
4. How do you find the RESTORE HISTORY of the database?
5. How do you list the last 30 days restore history at the instance level?
6. How do you measure the database backup or database restore operation progress?
7. How do you measure the database growth using backup size?
8. How do you define or estimate the storage required for database backup?
9. How do you get most recent database backup time for each database?
10. How do you get recent database backup time for each database using PowerShell?
11. How do you get recent database backup time for each database across multiple servers using PowerShell?
12. How do you find the backup history with duration and compressed backup size columns?

Continue reading…

https://www.sqlshack.com/interview-questions-on-sql-server-database-backups-restores-and-recovery-part-iii/