filegroups

美 　英

• 網(wǎng)絡(luò)文件組；理解文件組；檔案群組

例句

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

如果該名稱與任何當(dāng)前文件或文件組的名稱都不相同，將出現(xiàn)錯(cuò)誤。

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.

若要創(chuàng)建數(shù)據(jù)庫(kù)，必須確定數(shù)據(jù)庫(kù)的名稱、所有者、大小以及存儲(chǔ)該數(shù)據(jù)庫(kù)的文件和文件組。

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

開發(fā)索引設(shè)計(jì)策略時(shí)，應(yīng)該考慮在與數(shù)據(jù)庫(kù)相關(guān)聯(lián)的文件組上放置索引。

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

默認(rèn)文件組中的文件必須足夠大，能夠容納未分配給其他文件組的所有新對(duì)象。

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

部分備份與完整數(shù)據(jù)庫(kù)備份類似，但是部分備份不包含所有文件組。

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

然后創(chuàng)建一個(gè)分區(qū)方案，在其中指定擁有這四個(gè)分區(qū)中每一個(gè)分區(qū)的文件組。

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

差異化部分備份——差異化部分備份僅記錄自上一次部分備份以來(lái)文件組中發(fā)生更改的數(shù)據(jù)區(qū)。

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

數(shù)據(jù)庫(kù)或其文件或文件組的子集中所有數(shù)據(jù)的最新完整備份。

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

一種只還原一部分數(shù)據(jù)庫(kù)（包括其主文件組，可能還包括一個(gè)或多個(gè)輔助文件組）的還原。

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

此圖顯示共有四個(gè)文件組，一次備份其中的一個(gè)。

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

如果備份中的GUID與任何當(dāng)前文件或文件組的GUID都不相同，將出現(xiàn)錯(cuò)誤。

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

請(qǐng)勿將事務(wù)日志文件置于其中已有其他文件和文件組的物理磁盤上。

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

可以對(duì)任何數(shù)據(jù)庫(kù)執(zhí)行頁(yè)面還原，而不管文件組數(shù)為多少。

Transaction log files are never part of any filegroups.

事務(wù)日志文件不能屬于任何文件組。

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

訂閱服務(wù)器實(shí)例必須已經(jīng)包含將要放置已分區(qū)表的文件組。

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

但是，只讀輔助文件組和只讀數(shù)據(jù)庫(kù)可以放置在使用NTFS文件壓縮的文件系統(tǒng)中。

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

當(dāng)使用多個(gè)文件組時(shí)，可以分別備份和還原數(shù)據(jù)庫(kù)中的文件。

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

嘗試恢復(fù)包含下列任意一種文件組的數(shù)據(jù)庫(kù)將失敗。

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

為便于分配和管理，可以將數(shù)據(jù)庫(kù)對(duì)象和文件一起分成文件組。

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

可以將數(shù)據(jù)文件和文件組添加到數(shù)據(jù)庫(kù)，以提高數(shù)據(jù)庫(kù)性能并改善備份和還原策略。

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

只有只讀數(shù)據(jù)庫(kù)和只讀次要文件組可以保存在NTFS壓縮文件系統(tǒng)中。

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

在當(dāng)前數(shù)據(jù)庫(kù)中創(chuàng)建一個(gè)將已分區(qū)表或已分區(qū)索引的分區(qū)映射到文件組的方案。

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

另外，文件和文件組還允許數(shù)據(jù)布局，因?yàn)?/c>可以在特定的文件組中創(chuàng)建表。

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

指定用來(lái)持有由partition_function_name指定的分區(qū)的文件組的名稱。

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

因此，應(yīng)盡可能的在不同的本地物理磁盤上創(chuàng)建文件或文件組。

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

指定分區(qū)方案，該方案定義要將已分區(qū)索引的分區(qū)映射到的文件組。

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

在文件還原過(guò)程中，包含相應(yīng)文件的文件組在還原過(guò)程中自動(dòng)變?yōu)?/c>離線狀態(tài)。

Replicates filegroups associated with a partitioned table or index.

復(fù)制與已分區(qū)表或已分區(qū)索引相關(guān)聯(lián)的文件組。

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

離線還原過(guò)程中，數(shù)據(jù)庫(kù)目錄不可訪問(wèn)，包括當(dāng)前的文件組列表。

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

只要主文件組處于在線狀態(tài)，就將數(shù)據(jù)庫(kù)視為在線，即使有一個(gè)或多個(gè)輔助文件組處于離線狀態(tài)。

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

同時(shí)，部分還原順序和段落還原還需要遵循其他規(guī)則。

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

可以使用目錄視圖、系統(tǒng)函數(shù)和系統(tǒng)存儲(chǔ)過(guò)程返回有關(guān)數(shù)據(jù)庫(kù)、文件和文件組的信息。

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

分區(qū)函數(shù)所創(chuàng)建的分區(qū)將映射到在分區(qū)方案中指定的文件組。

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

不過(guò)，對(duì)于離線文件組，可以在以后通過(guò)文件還原進(jìn)行還原。

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

若要查看文件組的當(dāng)前狀態(tài)，請(qǐng)使用sys.filegroups目錄視圖。

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

指定數(shù)據(jù)庫(kù)備份要包含的文件或文件組的邏輯名稱。

Provides recommendations and guidelines for designing multiple files and filegroups.

提供設(shè)計(jì)多個(gè)文件和文件組的建議和指導(dǎo)原則。

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

然后，根據(jù)計(jì)劃添加更多的磁盤空間，如果需要，在數(shù)據(jù)庫(kù)中創(chuàng)建并添加更多的文件或文件組。

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

有關(guān)詳細(xì)信息，請(qǐng)參閱本主題中后面的“將文件和文件組還原到新位置”。

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

但是，對(duì)于簡(jiǎn)單模型數(shù)據(jù)庫(kù)而言，文件備份和文件組備份實(shí)質(zhì)上局限于只讀輔助文件組。