FileGroups Propiedad
Representa una colección de objetos FileGroup. Cada objeto FileGroup representa un grupo de archivos definido en la base de datos.
Espacio de nombres: Microsoft.SqlServer.Management.Smo
Ensamblado: Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Sintaxis
'Declaración
<SfcObjectAttribute(SfcContainerRelationship.ChildContainer, SfcContainerCardinality.OneToAny, GetType(FileGroup))> _
Public ReadOnly Property FileGroups As FileGroupCollection
Get
'Uso
Dim instance As Database
Dim value As FileGroupCollection
value = instance.FileGroups
[SfcObjectAttribute(SfcContainerRelationship.ChildContainer, SfcContainerCardinality.OneToAny, typeof(FileGroup))]
public FileGroupCollection FileGroups { get; }
[SfcObjectAttribute(SfcContainerRelationship::ChildContainer, SfcContainerCardinality::OneToAny,
typeof(FileGroup))]
public:
property FileGroupCollection^ FileGroups {
FileGroupCollection^ get ();
}
[<SfcObjectAttribute(SfcContainerRelationship.ChildContainer, SfcContainerCardinality.OneToAny,
typeof(FileGroup))>]
member FileGroups : FileGroupCollection
function get FileGroups () : FileGroupCollection
Valor de la propiedad
Tipo: Microsoft.SqlServer.Management.Smo. . :: . .FileGroupCollection
Objeto FileGroupCollection que representa todos los grupos de archivos definidos en la base de datos.
Comentarios
Specific file groups can be referenced by using this collection by specifying the name of the file group. To add a new file group to the collection, call the file group constructor FileGroup.
Ejemplos
VB
'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Reference the AdventureWorks2008R2 database.
Dim db As Database
db = srv.Databases("AdventureWorks2008R2")
'Display all the log files in the database.
Dim lf As LogFile
For Each lf In db.LogFiles
Console.WriteLine(lf.Name)
Next
PowerShell
$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2008R2")
Foreach ($lf in $db.LogFiles)
{
Write-Host $lf.Name
}