다음을 통해 공유

FileGroups Collection

  • 아티클

Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.

The FileGroups collection contains FileGroup objects that reference the filegroups of a Microsoft SQL Server database.

현재 개체를 보여 주는 SQL-DMO 개체 모델

Properties

Count Property

Methods

Add Method

Refresh Method

Item Method

Remove Method (Collections)

ItemByID Method

 

주의

SQL Server filegroups can be used to associate the operating system files used to maintain database data. Filegroups can simplify administrative tasks such as backup and restore operations. By default, a SQL Server database is created on exactly one filegroup called PRIMARY.

With the FileGroups collection, you can:

  • Create a new SQL Server filegroup.
  • Remove a SQL Server filegroup.

When using the Item or Remove method, the FileGroups collection supports member identification using either name or ordinal reference syntax. For example:

Set oFileGroup = oDatabase.FileGroups("PRIMARY")

Or

Set oFileGroup = oDatabase.FileGroups(1)

[!참고] Using the FileGroups collection to create or remove SQL Server database filegroups requires appropriate privilege. The SQL Server login used for SQLServer object connection must be a member of one of the fixed roles sysadmin or diskadmin.