Restore.SqlRestoreAsync 方法

Performs a restore operation asynchronously.

命名空間：  Microsoft.SqlServer.Management.Smo
組件：  Microsoft.SqlServer.SmoExtended (在 Microsoft.SqlServer.SmoExtended.dll 中)

語法

'宣告
Public Sub SqlRestoreAsync ( _
    srv As Server _
)
'用途
Dim instance As Restore 
Dim srv As Server

instance.SqlRestoreAsync(srv)

public void SqlRestoreAsync(
    Server srv
)

public:
void SqlRestoreAsync(
    Server^ srv
)

member SqlRestoreAsync : 
        srv:Server -> unit

public function SqlRestoreAsync(
    srv : Server
)

參數

• srv
  型別：Microsoft.SqlServer.Management.Smo.Server
  A Server object that represents the instance of SQL Server that is targeted by the restore operation.

範例

The following code example demonstrates how to back up and restore a database asynchronously.

VB

Dim srv As Server = New Server("(local)")
Dim res As Restore = New Restore()
Dim backup As Backup = New Backup()

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

res.Devices.AddDevice("C:\AdventureWorks2012Backup.bak", DeviceType.File)
res.Database = "AdventureWorks2012"
res.NoRecovery = true
res.SqlRestoreAsync(srv)

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)
$srv.Databases["AdventureWorks2012"].Drop()

$res.Devices.AddDevice("C:\AdventureWorks2012Backup.bak", [Microsoft.SqlServer.Management.Smo.DeviceType]::File)
$res.Database = "AdventureWorks2012"
$res.NoRecovery = $TRUE
$res.SqlRestoreAsync($srv)

請參閱

參考

Restore 類別

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

RESTORE (Transact-SQL)

SQL Server 資料庫的備份與還原