This article is half-done without your Comment! *** Please share your thoughts via Comment ***
For the Database Administrator, Database Backup and Restore are common and routine activities.
In this post, I am sharing an important list of SQL Server System tables for finding the information related to Backup and Restore.
The MSDB stores all the information about the backup and restore.
backupfile:
Stores information about the all backed up data file and log file.
1 |
SELECT *FROM msdb.dbo.backupfile |
backupfilegroup:
Stores information about the all backed up filegroup.
1 |
SELECT *FROM msdb.dbo.backupfilegroup |
backupmediafamily:
Stores information about the each media family.
1 |
SELECT *FROM msdb.dbo.backupmediafamily |
backupmediaset:
Stores information about the each backup media set.
1 |
SELECT *FROM msdb.dbo.backupmediaset |
backupset:
Stores information about the set of backup.
1 |
SELECT *FROM msdb.dbo.backupset |
restorefile:
Stores information about the each restore file.
1 |
SELECT *FROM msdb.dbo.restorefile |
restorefilegroup:
Stores information about the each file group.
1 |
SELECT *FROM msdb.dbo.restorefilegroup |
restorehistory:
Stores information about the each restore operation.
1 |
SELECT *FROM msdb.dbo.restorehistory |