Proprietà Database.LogFiles
Gets a collection of LogFile objects. Each LogFile object represents a log file defined on the database.
Spazio dei nomi Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Sintassi
'Dichiarazione
<SfcObjectAttribute(SfcContainerRelationship.ChildContainer, SfcContainerCardinality.OneToAny, GetType(LogFile))> _
Public ReadOnly Property LogFiles As LogFileCollection
Get
'Utilizzo
Dim instance As Database
Dim value As LogFileCollection
value = instance.LogFiles
[SfcObjectAttribute(SfcContainerRelationship.ChildContainer, SfcContainerCardinality.OneToAny, typeof(LogFile))]
public LogFileCollection LogFiles { get; }
[SfcObjectAttribute(SfcContainerRelationship::ChildContainer, SfcContainerCardinality::OneToAny,
typeof(LogFile))]
public:
property LogFileCollection^ LogFiles {
LogFileCollection^ get ();
}
[<SfcObjectAttribute(SfcContainerRelationship.ChildContainer, SfcContainerCardinality.OneToAny,
typeof(LogFile))>]
member LogFiles : LogFileCollection
function get LogFiles () : LogFileCollection
Valore proprietà
Tipo: Microsoft.SqlServer.Management.Smo.LogFileCollection
A LogFileCollection object that represents all the log files defined on the database.
Osservazioni
Log files can be referenced by using this collection by specifying the name of the log file. To add a new log file to the collection, call the log file constructor.
Esempi
VB
'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Reference the AdventureWorks2012 database.
Dim db As Database
db = srv.Databases("AdventureWorks2012")
'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("AdventureWorks2012")
Foreach ($lf in $db.LogFiles)
{
Write-Host $lf.Name
}
Vedere anche
Riferimento
Spazio dei nomi Microsoft.SqlServer.Management.Smo
Altre risorse
Utilizzo degli oggetti di database
Utilizzo di filegroup e file per archiviare dati