Backup and Restore Tables (Transact-SQL)

In This Section

• backupfile
  Contains one row for each data or log file of a database.

• backupfilegroup
  Contains one row for each filegroup in a database at the time of backup.

• backupmediafamily
  Contains a row for each media family.

• backupmediaset
  Contains one row for each backup media set.

• backupset
  Contains a row for each backup set.

• logmarkhistory
  Contains one row for each marked transaction that has been committed.

• restorefile
  Contains one row for each restored file. These include files restored indirectly by filegroup name.

• restorefilegroup
  Contains one row for each restored filegroup.

• restorehistory
  Contains one row for each restore operation.

• suspect_pages
  Contains one row per page that failed with an 824 error (with a limit of 1,000 rows).

• sysopentapes
  Contains one row for each currently open tape device.