Метод Server.EnumDetachedDatabaseFiles

Статья
07/14/2013

Enumerates a list of detached database files.

Пространство имен: Microsoft.SqlServer.Management.Smo
Сборка: Microsoft.SqlServer.Smo (в Microsoft.SqlServer.Smo.dll)

Синтаксис

'Декларация
Public Function EnumDetachedDatabaseFiles ( _
    mdfName As String _
) As StringCollection
'Применение
Dim instance As Server 
Dim mdfName As String 
Dim returnValue As StringCollection 

returnValue = instance.EnumDetachedDatabaseFiles(mdfName)

public StringCollection EnumDetachedDatabaseFiles(
    string mdfName
)

public:
StringCollection^ EnumDetachedDatabaseFiles(
    String^ mdfName
)

member EnumDetachedDatabaseFiles : 
        mdfName:string -> StringCollection

public function EnumDetachedDatabaseFiles(
    mdfName : String
) : StringCollection

Параметры

mdfName
Тип: System.String
A String value that specifies the file name for which to limit the results.

Возвращаемое значение

Тип: System.Collections.Specialized.StringCollection
A StringCollection system object value that contains a list of detached database file names.

Замечания

Use this method to obtain the names of all detached database (.mdf and .ndf) files on the instance of SQL Server.

Примеры

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

PowerShell

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

$sc = $srv.EnumDetachedDatabaseFiles("C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\DetachedDatabase.mdf")

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