Compartilhar via


Método Server.EnumAvailableMedia (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 (em Microsoft.SqlServer.Smo.dll)

Sintaxe

'Declaração
Public Function EnumAvailableMedia ( _
    media As MediaTypes _
) As DataTable
'Uso
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

Parâmetros

Valor de retorno

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

Exemplos

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]
   }
}

Consulte também

Referência

Server Classe

Sobrecarregado EnumAvailableMedia

Namespace Microsoft.SqlServer.Management.Smo

Outros recursos

Chamando métodos

Gerenciando servidores