Under the simple recovery model , file and filegroup backups are available only for read - only filegroups 在简单恢复模式下,文件和文件组备份只适用于只读文件组。
For a backup to a tape backup device , the blocksize option to affect the performance of the backup operation 在简单恢复模式下,只允许对只读文件组执行文件组备份。
This lets you do filegroup backup - and - restore operations of full - text catalogs independent of the data and log files 这样便可以独立于数据和日志文件执行文件组备份以及还原全文目录的操作。
Under the simple recovery model , file backups are essentially restricted to read - only secondary filegroups 但是,对于简单模型数据库而言,文件备份和文件组备份实质上局限于只读辅助文件组。
Cover one or more files or filegroups , and are relevant only for databases that contain multiple filegroups 在sql server 2005中,文件备份和文件组备份不再局限于完整模式数据库或大容量日志模式数据库。
For simple model databases , however , file and filegroup backups are essentially limited to read - only secondary filegroups 但是,对于简单模型数据库而言,文件备份和文件组备份实质上局限于只读辅助文件组。
To restore file and filegroup backups of full - text catalogs , specify the file or filegroup clause in the restore command 若要还原全文目录的文件备份和文件组备份,请在restore命令中指定file或filegroup子句。
With move can also be specified to restore to an alternate location differential backups as well as backups of full - text catalog files or filegroups 还可以指定with move ,以便将差异备份以及全文目录文件或文件组备份还原到替代位置。
The increased flexibility of file or filegroup backups is also useful for large databases that contain data that has varying update characteristics 增加文件或文件组备份的灵活性,对于包含具有不同更新特征的数据的大型数据库也很有用。