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)
Syntax
public void SqlRestore(
Server srv
)
public:
void SqlRestore(
Server^ srv
)
member SqlRestore :
srv:Server -> unit
Public Sub SqlRestore (
srv As Server
)
Parameters
srv
Type: Microsoft.SqlServer.Management.Smo.ServerA Server object that represents the instance of SQL Server that is targeted by the restore operation.
Remarks
The Database property and one or more Devices containing database information must be declared before this method can be called successfully.
Examples
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)
See Also
Restore Class
Microsoft.SqlServer.Management.Smo Namespace
RESTORE (Transact-SQL)
Back Up and Restore of SQL Server Databases
Return to top