Server.EnumAvailableMedia 方法 (MediaTypes)

项目
07/14/2013

Enumerates a list of media that is visible to the instance of SQL Server on the local area network and limited to the type of media specified.

命名空间： Microsoft.SqlServer.Management.Smo
程序集： Microsoft.SqlServer.Smo（在 Microsoft.SqlServer.Smo.dll 中）

语法

声明
Public Function EnumAvailableMedia ( _
    media As MediaTypes _
) As DataTable
用法
Dim instance As Server 
Dim media As MediaTypes 
Dim returnValue As DataTable 

returnValue = instance.EnumAvailableMedia(media)

public DataTable EnumAvailableMedia(
    MediaTypes media
)

public:
DataTable^ EnumAvailableMedia(
    MediaTypes media
)

member EnumAvailableMedia : 
        media:MediaTypes -> DataTable

public function EnumAvailableMedia(
    media : MediaTypes
) : DataTable

参数

media
类型：Microsoft.SqlServer.Management.Smo.MediaTypes
A MediaTypes object value that specifies the type of media to which the results are limited.

返回值

类型：System.Data.DataTable
A DataTable object value that contains the available media information. The table describes the different columns of the returned DataTable.

Column	Data type	Description
Name	String	The name of the drive.
LowFree	Int32	The low order double word of available media resource.
HighFree	Int32	The high order double word of available media resource
MediaTypes	Int32	The media type. See MediaTypes.

示例

Server srv = new Server("(local)");

DataTable d = srv.EnumAvailableMedia(MediaTypes.All);
foreach (DataRow r in d.Rows)
{
   Console.WriteLine("============================================");
   foreach(DataColumn c in d.Columns)
   {
      Console.WriteLine(c.ColumnName + " = " + r[c].ToString());
   }
}

PowerShell

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

$d = new-object System.Data.Datatable
$d = $srv.EnumAvailableMedia([Microsoft.SqlServer.Management.Smo.MediaTypes]::All)

Foreach ($r in $d.Rows)
{
   Write-Host "============================================"
   Foreach ($c in $d.Columns)
   {
      Write-Host $c.ColumnName "=" $r[$c]
   }
}