Share via


Backup and Restore Tables (Transact-SQL)

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

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.