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.