Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Backup and Restore Tables (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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

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.

Community Additions

ADD
Show:
© 2015 Microsoft