.png)
Backup and Restore Tables
The topics in this section describe the system tables that store information used by database backup and restore operations.
|
Contains one row for each data or log file of a database. | |
|
Contains one row for each filegroup in a database at the time of backup. | |
|
Contains a row for each media family. | |
|
Contains one row for each backup media set. | |
|
Contains a row for each backup set. | |
|
Contains one row for each marked transaction that has been committed. | |
|
Contains one row for each restored file. These include files restored indirectly by filegroup name. | |
|
Contains one row for each restored filegroup. | |
|
Contains one row for each restore operation. | |
|
Contains one row per page that failed with an 824 error (with a limit of 1,000 rows). | |
|
Contains one row for each currently open tape device. |
