Método EnumDetachedLogFiles
Enumera uma lista de arquivos de log desanexados.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (em Microsoft.SqlServer.Smo.dll)
Sintaxe
'Declaração
Public Function EnumDetachedLogFiles ( _
mdfName As String _
) As StringCollection
'Uso
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
Parâmetros
- mdfName
Tipo: System. . :: . .String
Um valor String que especifica o nome de arquivo para o qual limitar os resultados.
Valor de retorno
Tipo: System.Collections.Specialized. . :: . .StringCollection
Um valor do objeto de sistema StringCollection que contém uma lista de nomes de arquivo de log desanexado.
Comentários
Use this method to obtain the names of all the detached log (.ldf) files on the instance of SQL Server.
Exemplos
C#
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
}
Consulte também