部分備份 (SQL Server)Partial Backups (SQL Server)

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

所有 SQL ServerSQL Server 復原模式皆支援部分備份,因此本主題與所有 SQL ServerSQL Server 資料庫都有關。All SQL ServerSQL Server recovery models support partial backups, so this topic is relevant for all SQL ServerSQL Server databases. 但是,部分備份設計為在簡單復原模式下用以改善備份超大型資料庫 (其中包含一個或多個唯讀檔案群組) 時的彈性。However, partial backups are designed for use under the simple recovery model to improve flexibility for backing up very large databases that contain one or more read-only filegroups.

每當您想要排除唯讀檔案群組時,部分備份就十分有用。Partial backups are useful whenever you want to exclude read-only filegroups. 「部分備份」 (Partial backup) 與完整資料庫備份類似,但部分備份不包含所有檔案群組。A partial backup resembles a full database backup, but a partial backup does not contain all the filegroups. 然而,若為讀寫資料庫,則部分備份包含主要檔案群組、每個讀寫檔案群組,以及 (選擇性地) 一個或多個唯讀檔案中的資料。Instead, for a read-write database, a partial backup contains the data in the primary filegroup, every read-write filegroup, and, optionally, one or more read-only files. 唯讀資料庫的部分備份只包含主要檔案群組。A partial backup of a read-only database contains only the primary filegroup.

注意

如果唯讀資料庫在部分備份之後變成可讀寫,可能有不在部分備份中的可讀寫次要檔案群組。If a read-only database is changed to read/write after a partial backup, there might be read/write secondary filegroups that are not in the partial backup. 在此情況下,當您試圖進行差異部分備份時,備份會失敗。In this case, if you try to take a differential partial backup, the backup fails. 您必須先進行另一個部分備份,才可以進行資料庫的差異部分備份。Before you can take a differential partial backup of the database, you must take another partial backup. 新的部分備份會包含每個讀取/寫入次要檔案群組,並且可作為差異部分備份的基底。The new partial backup contains every read/write secondary filegroup and can serve as the base for differential partial backups.

唯讀檔案群組的檔案備份可以結合部分備份。File backups of read-only filegroups can be combined with partial backups. 如需檔案備份的相關資訊,請參閱完整檔案備份 (SQL Server)For information about file backups, see Full File Backups (SQL Server).

部分備份可以當成差異部分備份的 「差異基底」 (Differential base)。A partial backup can serve as the differential base for differential partial backups. 如需詳細資訊,請參閱 差異備份 (SQL Server)For more information, see Differential Backups (SQL Server).

相關工作Related Tasks

注意

SQL Server Management StudioSQL Server Management Studio 或 [維護計畫精靈] 不支援部分備份。Partial backups are not supported by SQL Server Management StudioSQL Server Management Studio or the Maintenance Plan Wizard.

建立部分備份To create a partial backup

在還原順序中使用部分備份To use a partial backup in a restore sequence

另請參閱See Also

備份概觀 (SQL Server) Backup Overview (SQL Server)
檔案還原 (簡單復原模式) File Restores (Simple Recovery Model)
分次還原 (SQL Server)Piecemeal Restores (SQL Server)