Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Restore.SqlRestore Method (Server)

 

Applies To: SQL Server 2016 Preview

Performs a restore operation on the specified server.

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

public void SqlRestore(
	Server srv
)

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.

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

Legacy Code Example

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)
Return to top
Show:
© 2015 Microsoft