Backup and Restore Tables (Transact-SQL)
Applies to: SQL Server
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.
Geri Bildirim
https://aka.ms/ContentUserFeedback.
Çok yakında: 2024 boyunca, içerik için geri bildirim mekanizması olarak GitHub Sorunları’nı kullanımdan kaldıracak ve yeni bir geri bildirim sistemiyle değiştireceğiz. Daha fazla bilgi için bkz.Gönderin ve geri bildirimi görüntüleyin