The FileGroups collection contains FileGroup objects referencing the filegroups of a Microsoft® SQL Server™ database.
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:
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)
Note 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.
Add Method | Refresh Method |
Item Method | Remove Method (Collections) |
ItemByID Method |