Server.EnumDetachedDatabaseFiles 方法

發行項
07/13/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
}