Compartilhar via


Método Restore.SqlRestore

Performs a restore operation on the specified server.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.SmoExtended (em Microsoft.SqlServer.SmoExtended.dll)

Sintaxe

'Declaração
Public Sub SqlRestore ( _
    srv As Server _
)
'Uso
Dim instance As Restore 
Dim srv As Server

instance.SqlRestore(srv)
public void SqlRestore(
    Server srv
)
public:
void SqlRestore(
    Server^ srv
)
member SqlRestore : 
        srv:Server -> unit
public function SqlRestore(
    srv : Server
)

Parâmetros

Comentários

The Database property and one or more Devices containing database information must be declared before this method can be called successfully.

Exemplos

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

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.SqlRestore(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.SqlRestore($srv)

Consulte também

Referência

Restore Classe

Namespace Microsoft.SqlServer.Management.Smo

Outros recursos

RESTORE (Transact-SQL)

Fazer backup e restaurar bancos de dados do SQL Server