EnumDetachedDatabaseFiles 方法

枚举已分离的数据库文件的列表。

命名空间:  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

参数

返回值

类型:System.Collections.Specialized. . :: . .StringCollection
一个 StringCollection 系统对象值,该值包含分离的数据库文件名的列表。

注释

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

示例

C#

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
}