0 out of 4 rated this helpful - Rate this topic

Backup and Restore Tables (Transact-SQL)

SQL Server 2008 R2

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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions