Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Server.EnumAvailableMedia Method (MediaTypes)

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.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
public DataTable EnumAvailableMedia(
	MediaTypes media
)

Parameters

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

Return Value

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

C#

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]
   }
}
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.