Restore.ReadMediaHeader 方法
Reads the media header and returns the media header values.
命名空间： Microsoft.SqlServer.Management.Smo
程序集： Microsoft.SqlServer.SmoExtended（在 Microsoft.SqlServer.SmoExtended.dll 中）
语法
声明
Public Function ReadMediaHeader ( _
srv As Server _
) As DataTable
用法
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
参数
- srv
类型：Microsoft.SqlServer.Management.Smo.Server
A Server object that represents the instance of SQL Server that provides access to the targeted media.
返回值
类型：System.Data.DataTable
A DataTable object that specifies the media header data.
示例
The following code example demonstrates how to back up file for the AdventureWorks2012 database and read the header values of the backup media.
VB
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]
}
}
请参阅
参考
Microsoft.SqlServer.Management.Smo 命名空间