Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Performs a restore operation asynchronously.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.SmoExtended (in Microsoft.SqlServer.SmoExtended.dll)
Syntax
'Declaration
Public Sub SqlRestoreAsync ( _
srv As Server _
)
'Usage
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
)
Parameters
- srv
Type: Microsoft.SqlServer.Management.Smo.Server
A Server object that represents the instance of SQL Server that is targeted by the restore operation.
Examples
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)
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace