備份及還原資料表 (Transact-SQL)Backup and Restore Tables (Transact-SQL)

適用於: 是SQL Server 否Azure SQL Database 否Azure SQL 資料倉儲 否平行處理資料倉儲 APPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

本節中的主題介紹儲存資料庫備份與還原作業所用的資訊之系統資料表。The topics in this section describe the system tables that store information used by database backup and restore operations.

本節內容In This Section

backupfilebackupfile
針對資料庫的每個資料或記錄檔,各包含一個資料列。Contains one row for each data or log file of a database.

backupfilegroupbackupfilegroup
針對備份時在資料庫中的每個檔案群組,各包含一個資料列。Contains one row for each filegroup in a database at the time of backup.

backupmediafamilybackupmediafamily
針對每個媒體家族,各包含一個資料列。Contains a row for each media family.

backupmediasetbackupmediaset
每個備份組各含一個資料列。Contains one row for each backup media set.

backupsetbackupset
每個備份組各含一個資料列。Contains a row for each backup set.

logmarkhistorylogmarkhistory
針對已認可的每個標示交易,各包含一個資料列。Contains one row for each marked transaction that has been committed.

restorefilerestorefile
針對每個還原的檔案,各包含一個資料列。Contains one row for each restored file. 其中包括檔案群組名稱間接還原的檔案。These include files restored indirectly by filegroup name.

restorefilegrouprestorefilegroup
針對每個還原的檔案群組,各包含一個資料列。Contains one row for each restored filegroup.

restorehistoryrestorehistory
每項還原作業都有一個資料列。Contains one row for each restore operation.

suspect_pagessuspect_pages
針對每個失敗並出現 824 錯誤 (限制為 1,000 個資料列) 的頁面,各包含一個資料列。Contains one row per page that failed with an 824 error (with a limit of 1,000 rows).

sysopentapessysopentapes
針對目前開啟的每個磁帶裝置,各包含一個資料列。Contains one row for each currently open tape device.