Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
EnumDetachedDatabaseFiles Method
Collapse the table of content
Expand the table of content

Server.EnumDetachedDatabaseFiles Method

Enumerates a list of detached database files.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

public StringCollection EnumDetachedDatabaseFiles(
	string mdfName
)

Parameters

mdfName
Type: String
A String value that specifies the file name for which to limit the results.

Return Value

Type: 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. 

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
}

Community Additions

ADD
Show:
© 2015 Microsoft