This is an archive version of the document. To get the most up-to-date information, see the current version.Set-VESQLIRDatabase
Short Description
Modifies switchover settings for a specified Microsoft SQL Server database.
Applies to
Veeam Backup & Replication
Product Edition: Enterprise, Enterprise Plus, Veeam Universal License
Syntax
Set-VESQLIRDatabase [-Database] <VESQLIRDatabase> [-SwitchOverOptions] <VESQLIRSwitchOverOptions> [<CommonParameters>] |
Detailed Description
This cmdlet allows you to modify the switchover settings for a specified Microsoft SQL Server database.
|
You can not modify the switchover option that starts the switchover immediately after database files are copied and synchronized. |
Parameters
Parameter | Description | Type | Required | Position | Accept Pipeline Input |
|---|---|---|---|---|---|
Database | Specifies a published Microsoft SQL Server database within an instant recovery session. | Accepts the VESQLIRDatabase object. To get this object, run the Get-VESQLIRDatabase cmdlet. | True | 0 | True (ByValue) |
SwitchOverOptions | Specified a new switchover option for the specified Microsoft SQL Server database. | Accepts the VESQLIRSwitchOverOptions object. To create this object, run the New-VESQLIRSwitchOverOptions cmdlet. | True | 1 | True (ByValue) |
<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. Setting Scheduled Switchover for Microsoft SQL Server Database
This example shows how to set the scheduled switchover for the fiscal database. The switchover will be performed on fiscal 2020-12-4 at 13:00:00.
$time = Get-Date -Date "2020-12-4 13:00:00" $TimeUtc = $time.ToUniversalTime() $ScheduledSwitch = New-VESQLIRSwitchOverOptions -Scheduled -SwitchingTimeUtc $TimeUtc $IRDatabase = Get-VESQLIRDatabase -DatabaseName "fiscal" Set-VESQLIRDatabase -Database $IRDatabase -SwitchOverOptions $ScheduledSwitch |
Perform the following steps:
- Run the Get-Date cmdlet and specify the date and time when the switchover must be performed. Save the result to the $time variable.
- Use the ToUniversalTime() method to convert the date and time to the UTC format.
- Run the New-VESQLIRSwitchoverOptions cmdlet. Specify the Scheduled parameter and specify the SwitchingTimeUtc parameter value. Save the result to the $ScheduledSwitch variable.
- Run the Get-VESQLIRDatabase cmdlet. Specify the DatabaseName parameter value. Save the result to the $IRDatabase variable.
- Run the Set-VESQLIRDatabase cmdlet. Specify the following options:
- Set the $IRDatabase as the Database parameter value.
- Set the $ScheduledSwitch as the SwitchOverOptions parameter value.
Related Commands
