Backup and Restore Tables

The topics in this section describe the system tables that store information used by database backup and restore operations.

In This Section

backupfile (Transact-SQL)	Contains one row for each data or log file of a database.
backupfilegroup (Transact-SQL)	Contains one row for each filegroup in a database at the time of backup.
backupmediafamily (Transact-SQL)	Contains a row for each media family.
backupmediaset (Transact-SQL)	Contains one row for each backup media set.
backupset (Transact-SQL)	Contains a row for each backup set.
logmarkhistory (Transact-SQL)	Contains one row for each marked transaction that has been committed.
restorefile (Transact-SQL)	Contains one row for each restored file. These include files restored indirectly by filegroup name.
restorefilegroup (Transact-SQL)	Contains one row for each restored filegroup.
restorehistory (Transact-SQL)	Contains one row for each restore operation.
suspect_pages (Transact-SQL)	Contains one row per page that failed with an 824 error (with a limit of 1,000 rows).
sysopentapes (Transact-SQL)	Contains one row for each currently open tape device.