Articolo
04/01/2012

Metodo EnumDetachedLogFiles

Enumera un elenco di file di log scollegati.

Spazio dei nomi Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Sintassi

'Dichiarazione
Public Function EnumDetachedLogFiles ( _
    mdfName As String _
) As StringCollection
'Utilizzo
Dim instance As Server
Dim mdfName As String
Dim returnValue As StringCollection

returnValue = instance.EnumDetachedLogFiles(mdfName)

public StringCollection EnumDetachedLogFiles(
    string mdfName
)

public:
StringCollection^ EnumDetachedLogFiles(
    String^ mdfName
)

member EnumDetachedLogFiles : 
        mdfName:string -> StringCollection

public function EnumDetachedLogFiles(
    mdfName : String
) : StringCollection

Parametri

mdfName
Tipo: System. . :: . .String
Valore String che specifica il nome file per il quale limitare i risultati.

Valore restituito

Tipo: System.Collections.Specialized. . :: . .StringCollection
Valore dell'oggetto di sistema StringCollection che contiene un elenco di nomi file di log scollegati.

Osservazioni

Use this method to obtain the names of all the detached log (.ldf) files on the instance of SQL Server.

Esempi

Server srv = new Server("(local)");
StringCollection sc = srv.EnumDetachedLogFiles("C:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.MSSQLSERVER\\MSSQL\\DATA\\DetachedDatabase_log.LDF");
foreach (String s in sc)
{
   Console.WriteLine(s);
}

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")

$sc = $srv.EnumDetachedLogFiles("C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\DetachedDatabase_log.LDF)

Foreach ($s in $sc)
{
   Write-Host $s
}