Use file and filegroup backups and transaction log backups . these allow for only those files that contain the relevant data , instead of the whole database , to be backed up or restored 使用文件和文件组备份以及事务日志备份,使得可以只备份或还原那些包含相关数据的文件,而不用备份整个数据库。
Contains information about differential bases , how differential backups work , and how to create the various types of data and differential backups : database backups , partial and differential partial backups , and file and filegroup backups 包含有关创建各种类型的数据备份和差异备份(数据库备份、部分备份和部分差异备份以及文件备份和文件组备份)的信息。
Norecovery is useful when failing over to a secondary database or when saving the tail of the log before a restore operation . to perform a best - effort log backup that skips log truncation and then take the database into the restoring state atomically , use the no truncate and norecovery options together 在完整恢复模式或大容量日志恢复模式下,使用文件和文件组备份恢复数据库时,还需要从一个或多个日志备份(使用backup log创建)中还原事务日志。