filegroups

filegroups

 英

  • 网络文件组;理解文件组;档案群组

例句

If the name does not match one of the current files or filegroups, an error occurs.

如果名称任何当前文件文件名称相同出现错误

To create a database, you have to determine the name of the database, its owner, its size, and the files and filegroups used to store it.

若要创建数据库必须确定数据库名称所有者大小以及存储数据库文件文件

As you develop your index design strategy, you should consider the placement of the indexes on the filegroups associated with the database.

开发索引设计策略应该考虑数据库相关联文件放置索引

The files in the default filegroup must be large enough to hold any new objects not allocated to other filegroups.

默认文件文件必须足够能够容纳分配其他文件所有对象

A partial backup resembles a full database backup, but a partial backup does not contain all the filegroups.

部分备份完整数据库备份类似但是部分备份包含所有文件

A partition scheme is then created that specifies the filegroups to hold each one of the four partitions.

然后创建一个分区方案其中指定拥有四个分区一个分区文件

Differential partial backup -- This backup only records data that has changed in the filegroups since the preceding partial backup.

差异部分备份——差异部分备份记录一次部分备份以来文件发生更改数据

The most recent full backup of all the data in a database or in a subset of the files or filegroups of a database.

数据库文件文件子集所有数据最新完整备份

A restore of only a part of a database that consists of its primary filegroup and, perhaps, one or more secondary filegroups.

一种还原一部分数据库包括文件可能包括一个多个辅助文件还原

This illustration shows each of the four filegroups being backed up one at a time.

显示共有四个文件一次备份其中一个

If the GUID from the backup does not match any of the current files or filegroups, an error occurs.

如果备份GUID任何当前文件文件GUID相同出现错误

Do not put the transaction log file or files on the same physical disk that has the other files and filegroups.

请勿事务日志文件置于其中其他文件文件物理磁盘

Page restores can be performed on any database, regardless of the number of filegroups.

可以任何数据库执行页面还原不管文件多少

Transaction log files are never part of any filegroups.

事务日志文件不能属于任何文件

The Subscriber instance must already contain the filegroups on which the partitioned tables will be placed.

订阅服务器实例必须已经包含将要放置分区文件

However, read-only secondary filegroups and read-only databases can be placed on a file system using NTFS file compression.

但是辅助文件数据库可以放置使用NTFS文件压缩文件系统

When multiple filegroups are used, the files in a database can be backed up and restored individually.

使用多个文件可以分别备份还原数据库文件

Attempts to revert a database containing either of these types of filegroups fail.

尝试恢复包含下列任意一种文件数据库失败

Database objects and files can be grouped together in filegroups for allocation and administration purposes.

便于分配管理可以数据库对象文件一起分成文件

You can add data files and filegroups to a database to improve database performance and enhance your backup and restore strategies.

可以数据文件文件添加数据库提高数据库性能改善备份还原策略

Only read-only databases and read-only secondary filegroups can be put on an NTFS compressed file system.

只有数据库次要文件可以保存NTFS压缩文件系统

Creates a scheme in the current database that maps the partitions of a partitioned table or index to filegroups.

当前数据库创建一个分区分区索引分区映射文件方案

Additionally, files and filegroups enable data placement, because a table can be created in a specific filegroup.

另外文件文件允许数据布局因为可以特定文件创建

Specifies the names of the filegroups to hold the partitions specified by partition_function_name.

指定用来持有partition_function_name指定分区文件名称

Therefore, you should create the files or filegroups on as many different local physical disks as you can.

因此尽可能不同本地物理磁盘创建文件文件

Specifies the partition scheme that defines the filegroups onto which the partitions of a partitioned index will be mapped.

指定分区方案方案定义分区索引分区映射文件

During a file restore, the filegroups that contain the files are automatically offline for the duration of the restore.

文件还原过程包含相应文件文件还原过程自动变为离线状态

Replicates filegroups associated with a partitioned table or index.

复制分区分区索引相关联文件

During an offline restore, the database catalog is not accessible, including the current list of filegroups.

离线还原过程数据库目录不可访问包括当前文件列表

A database is considered to be online whenever the primary filegroup is online, even if one or more of its secondary filegroups are offline.

只要文件处于在线状态数据库视为在线即使一个多个辅助文件处于离线状态

The partial restore sequence restores the primary filegroup and, optionally, some of the secondary filegroups.

同时部分还原顺序段落还原需要遵循其他规则

You can use catalog views, system functions, and system stored procedures to return information about databases, files, and filegroups.

可以使用目录视图系统函数系统存储过程返回有关数据库文件文件信息

Partitions created by the partition function are mapped to the filegroups specified in the partition scheme.

分区函数创建分区映射分区方案指定文件

The offline filegroups, however, can be restored later by a file restore.

不过对于离线文件可以以后通过文件还原进行还原

To view the current state of a filegroup, use the sys. Filegroups catalog view.

若要查看文件当前状态使用sys.filegroups目录视图

Specifies the logical names of the files or filegroups to include in a database backup.

指定数据库备份包含文件文件逻辑名称

Provides recommendations and guidelines for designing multiple files and filegroups.

提供设计多个文件文件建议指导原则

Then, plan accordingly by adding more disk space, if required, and creating and adding more files or filegroups to the database.

然后根据计划添加更多磁盘空间如果需要数据库创建添加更多文件文件

For more information, see "To restore files and filegroups to a new location, " later in this topic.

有关详细信息参阅主题后面文件文件还原位置”。

Under the simple recovery model, file backups are essentially restricted to read-only secondary filegroups.

但是对于简单模型数据库而言文件备份文件备份实质上限于辅助文件

热门查询