Metodo Restore.ReadMediaHeader

Articolo
04/26/2013

Reads the media header and returns the media header values.

Spazio dei nomi Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.SmoExtended (in Microsoft.SqlServer.SmoExtended.dll)

Sintassi

'Dichiarazione
Public Function ReadMediaHeader ( _
    srv As Server _
) As DataTable
'Utilizzo
Dim instance As Restore 
Dim srv As Server 
Dim returnValue As DataTable 

returnValue = instance.ReadMediaHeader(srv)

public DataTable ReadMediaHeader(
    Server srv
)

public:
DataTable^ ReadMediaHeader(
    Server^ srv
)

member ReadMediaHeader : 
        srv:Server -> DataTable

public function ReadMediaHeader(
    srv : Server
) : DataTable

Parametri

srv
Tipo: Microsoft.SqlServer.Management.Smo.Server
A Server object that represents the instance of SQL Server that provides access to the targeted media.

Valore restituito

Tipo: System.Data.DataTable
A DataTable object that specifies the media header data.

Esempi

The following code example demonstrates how to back up file for the AdventureWorks2012 database and read the header values of the backup media.

Dim srv As Server = New Server()
Dim res As Restore = New Restore()
Dim backup As Backup = New Backup()
Dim dt As DataTable

backup.Devices.AddDevice("C:\AdventureWorks2012Backup.bak", DeviceType.File)
backup.Database = "AdventureWorks2012"
backup.Action = BackupActionType.Database
backup.Initialize = True
backup.SqlBackup(srv)

res.Devices.AddDevice("C:\AdventureWorks2012Backup.BAK", DeviceType.File)
dt = res.ReadMediaHeader(srv)

For Each r As DataRow In dt.Rows
   For Each c As DataColumn In dt.Columns
      Console.WriteLine(c.ToString + " = " + r(c).ToString())
   Next
Next

PowerShell

$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")
$res = new-object Microsoft.SqlServer.Management.Smo.Restore
$backup = new-object Microsoft.SqlServer.Management.Smo.Backup

$backup.Devices.AddDevice("C:\AdventureWorks2012Backup.bak", [Microsoft.SqlServer.Management.Smo.DeviceType]::File)
$backup.Database = "AdventureWorks2012"
$backup.Action = [Microsoft.SqlServer.Management.Smo.BackupActionType]::Database
$backup.Initialize = $TRUE
$backup.SqlBackup($srv)

$res.Devices.AddDevice("C:\AdventureWorks2012Backup.bak", [Microsoft.SqlServer.Management.Smo.DeviceType]::File)
$dt = $res.ReadMediaHeader($srv)

foreach($r in $dt.Rows)
{
   foreach ($c in $dt.Columns)
   {
      Write-Host $c "=" $r[$c]
   }
}