Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Backup and Restore Tables

Backup and Restore Tables

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

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.

Community Additions

ADD
Show:
© 2015 Microsoft