Restore.SqlRestore 메서드
Performs a restore operation on the specified server.
네임스페이스: Microsoft.SqlServer.Management.Smo
어셈블리: Microsoft.SqlServer.SmoExtended(Microsoft.SqlServer.SmoExtended.dll)
구문
‘선언
Public Sub SqlRestore ( _
srv As Server _
)
‘사용 방법
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
)
매개 변수
- srv
유형: 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.
예
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)
참고 항목
참조
Microsoft.SqlServer.Management.Smo 네임스페이스