Restore-VESQLIRDatabase
Short Description
Performs instant restore of backed-up Microsoft SQL Server databases.
Applies to
Veeam Backup & Replication
Product Edition: Enterprise, Enterprise Plus, Veeam Universal License
Syntax
Restore-VESQLIRDatabase [-Database] <VESQLDatabase> -SwitchOverOptions <VESQLIRSwitchOverOptions> [-DatabaseName <string>] [-ServerName <string>] [-InstanceName <string>] [-Port <int>] [-SqlCredentials <pscredential>] [-UseSQLAuthentication] [-GuestCredentials <pscredential>] [-ToPointInTimeUtc <datetime>] [-TargetFolder <string>] [-File <VESQLDatabaseFile[]>] [-TargetPath <string[]>] [-Force] [<CommonParameters>] |
Detailed Description
This cmdlet performs instant restore of backed-up Microsoft SQL Server databases. You can restore databases to the original location or to another location. For details, see the Instant Recovery section of the Veeam Explorers Guide.
Parameters
Parameter | Description | Type | Required | Position | Accept Pipeline Input |
---|---|---|---|---|---|
Database | Specifies a Microsoft SQL Server database. The cmdlet will restore this database. | Accepts the VESQLDatabase object. To get this object, run the Get-VESQLDatabase cmdlet. | True | 0 | True (ByValue) |
SwitchOverOptions | Specifies a switchover option: automated, manual or scheduled. | Accepts the VESQLIRSwitchOverOption object. To get this object, run the New-VESQLIRSwitchOverOptions cmdlet. | True | Named | True (ByValue) |
DatabaseName | For restore to another location. Specifies a name for the restored SQL Server database. The cmdlet will restore the database with the specified name. | String | False | Named | False |
ServerName | For restore to another location. Specifies a name of a target SQL Server server. The cmdlet will restore the database to the specified target server. | String | False | Named | False |
InstanceName | For restore to another location. Specifies a name of a target SQL Server instance. The cmdlet will restore an SQL Server database to the specified target instance. | String | False | Named | False |
Port | Specifies a port number that will be used to connect to the target SQL Server. | Int32 | False | Named | False |
SqlCredentials | Specifies SQL Server credentials to authenticate against a target SQL Server. Note: If you do not specify SQL Server credentials, the cmdlet will use current account credentials. If these credentials do not work, the cmdlet will use credentials specified in the backup job. | Accepts the PSCredential object. To get this object, run the Get-Credential cmdlet. | False | Named | False |
UseSQLAuthentication | Defines that the cmdlet will use the SQL Server authentication to connect to the target SQL Server instance. Note: If you omit this parameter, the cmdlet will use credentials specified in the SqlCredentials parameter to connect to both the SQL Server and to the guest OS. | SwitchParameter | False | Named | False |
GuestCredentials | Specifies credentials to authenticate against the target SQL Server. If these credentials do not work, the cmdlet will use credentials, specified in the backup job. Note: If you omit this parameter, the cmdlet will use credentials specified in the SqlCredentials parameter or current account credentials to connect to both the SQL Server and to the guest OS. | Accepts the PSCredential object. To get this object, run the Get-Credential cmdlet. | False | Named | False |
ToPointInTime | Specifies the point in time within a restore interval of an SQL Server database. The cmdlet will restore the database to the state of the specified point in time. | Datetime | False | Named | False |
TargetFolder | For restore of SQL Server database files to specific location. Specifies the folder. The cmdlet will restore all database files to that folder. Note: This parameter is not available if you use the TargetPath parameter. | String | False | Named | False |
File | Specifies an array of file names for Microsoft SQL Server databases. | Accepts the VESQLDatabaseFile[] object. To get this object, run the Get-VESQLDatabaseFile cmdlet. | False | Named | False |
TargetPath | Specifies a target path array. The cmdlet restores SQL Server database files to locations, specified in the target path array. Note:
| String[] | False | Named | False |
Force | Defines that the cmdlet will overwrite an existing SQL Server database with a database from a backup. Note: The cmdlet will show no prompt before executing the command. | SwitchParameter | False | Named | False |
<CommonParameters>
This cmdlet supports Microsoft PowerShell common parameters. For more information on common parameters, see the About Common Parameters section of Microsoft Docs.
Examples
Example 1. Performing Instant Restore of Microsoft SQL Server Databases to Original Location and Configuring Scheduled Switchover
This example shows how to perform instant recovery of the SQLDatabase database to the original location using the switchover option. The cmdlet will perform the switchover at 13:00:00 on 2020-11-24.
Perform the following steps:
The Get-VESQLRestoreSession cmdlet will return an array of restore sessions. Mind the ordinal number of the necessary restore session. In our example, it is the first restore session in the array.
|
Example 2. Performing Instant Recovery of Microsoft SQL Server Databases to Specific Folder and Switching Over Manually
This example shows how to restore the SQLDatabase01 database files to the latest restore point with the following settings:
Perform the following steps:
The Get-VESQLRestoreSession cmdlet will return an array of restore sessions. Mind the ordinal number of the necessary restore session. In our example, it is the first restore session in the array.
|
Related Commands