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 增加文件或文件组备份的灵活性,对于包含具有不同更新特征的数据的大型数据库也很有用。