---
title: "New-VESQLIRSwitchOverOptions"
description: "Defines the switchover option that you can apply to the instant recovery session of a Microsoft SQL Server database. Product: Veeam Backup & Replication Product Edition: Enterprise, Enterprise Plus, Veeam Universal License This cmdlet provides th"
canonical: "https://helpcenter.veeam.com/docs/vbr/explorers_powershell/new-vesqlirswitchoveroptions.html"
breadcrumb: "Veeam Explorers PowerShell Reference > Veeam Explorers PowerShell Reference > Veeam Explorer for Microsoft SQL Server > New-VESQLIRSwitchOverOptions"
dateModified: "2026-08-18"
---

# New-VESQLIRSwitchOverOptions

## Short Description
Defines the switchover option that you can apply to the instant recovery session of a Microsoft SQL Server database.

**Product**: Veeam Backup & Replication

**Product Edition**: Enterprise, Enterprise Plus, Veeam Universal License

## Syntax

This cmdlet provides the following parameter sets:

<ul class="syntax-sets">
  <li>
    <p><code>AutoSwitch</code></p>

```
New-VESQLIRSwitchOverOptions [-Auto] [<CommonParameters>]
```
  </li>
  <li>
    <p><code>ManualSwitch</code></p>

```
New-VESQLIRSwitchOverOptions [-Manual] [<CommonParameters>]
```
  </li>
  <li>
    <p><code>ScheduledSwitch</code></p>

```
New-VESQLIRSwitchOverOptions [-Scheduled] -SwitchingTimeUtc <DateTime> [<CommonParameters>]
```
  </li>
</ul>

## Detailed Description
This cmdlet creates the [`VESQLIRSwitchOverOptions`](vesqlirswitchoveroptions.md) object that defines a switchover option that you can apply to the instant recovery session of Microsoft SQL Server databases. You can use this option to create a switchover option and define a schedule for a scheduled switchover.

## Parameters

<table style="width:100%;" class="Blue_Table">
      <tr style="vertical-align:top">
        <th style="width:20%;">
          <p>Parameter</p>
        </th>
        <th style="width:20%;">
          <p>Description</p>
        </th>
        <th style="width:20%;">
          <p>Type</p>
        </th>
        <th style="width:10%;">
          <p>Required</p>
        </th>
        <th style="width:10%;">
          <p>Position</p>
        </th>
        <th style="width:10%;">
          <p>Accept Pipeline Input</p>
        </th>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">Auto</span></p>
        </td>
        <td>
          <p>Defines that the switchover will be performed in the <code>Auto</code> mode. This option starts switchover immediately after database files are copied and synchronized.</p>
        </td>
        <td style="width:10%;">
          <p><code>SwitchParameter</code></p>
        </td>
        <td style="width:10%;">
          <p>True</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">Manual</span></p>
        </td>
        <td>
          <p>Defines that the switchover will be performed manually at a later time, using the <code>Switch-VESQLIRDatabase</code> cmdlet.</p>
        </td>
        <td style="width:10%;">
          <p><code>SwitchParameter</code></p>
        </td>
        <td style="width:10%;">
          <p>True</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">Scheduled</span></p>
        </td>
        <td>
          <p>Defines that the switchover will be performed in the <code>Scheduled</code> mode. Switchover will be performed at the specified date and time.</p>
        </td>
        <td style="width:10%;">
          <p><code>SwitchParameter</code></p>
        </td>
        <td style="width:10%;">
          <p>True</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">SwitchingTimeUtc</span></p>
        </td>
        <td>
          <p>For the scheduled switchover option.</p><p>Specifies the date and time in UTC when the switchover must be started.</p>
        </td>
        <td style="width:10%;">
          <p><code>DateTime</code></p>
        </td>
        <td style="width:10%;">
          <p>True</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
    </table>

`<CommonParameters>`

This cmdlet supports Microsoft PowerShell common parameters. For more information on common parameters, see the [About Common Parameters](http://go.microsoft.com/fwlink/p/?LinkID=113216) section of Microsoft Docs.

## Output Object
The cmdlet returns the [`VESQLIRSwitchOverOptions`](vesqlirswitchoveroptions.md) object that contains a switchover option with the defined schedule.

## Examples

::: example
### Example 1. Creating Scheduled Switchover Option

This example shows how to define a scheduled switchover option. The switchover schedule is set to `2026-11-24 13:00:00`.

```
$time = Get-Date -Date "2026-11-24 13:00:00"
$TimeUtc = $time.ToUniversalTime()
$ScheduledSwitch = New-VESQLIRSwitchOverOptions -Scheduled -SwitchingTimeUtc $TimeUtc
```

Perform the following steps:

1. Run the [`Get-Date`](https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/get-date?view=powershell-7.6) cmdlet and specify the date and time when the switchover must be performed. Save the result to the `$time` variable.
2. Convert the scheduled time to the UTC format using the `ToUniversalTime()` method. Save the result to the `$TimeUtc` variable.
3. Run the `New-VESQLIRSwitchOverOptions` cmdlet. Provide the `Scheduled` parameter. Set the `$TimeUtc` variable as the `SwitchingTimeUtc` parameter value.

:::

::: example
### Example 2. Defining Automatic Switchover Option

This command defines the auto switchover option. The switchover will run immediately after database files are copied and synchronized.

```
$AutomaticSwitch = New-VESQLIRSwitchOverOptions -Auto
```

:::

::: example
### Example 3. Defining Manual Switchover Option

This command defines a manual switchover option. The switchover will start after you initiate this process manually with the [`Switch-VESQLIRDatabase`](switch-vesqlirdatabase.md) cmdlet.

```
$ManualSwitch = New-VESQLIRSwitchOverOptions -Manual
```

:::

## Related Commands

- [`Set-VESQLIRDatabase`](set-vesqlirdatabase.md)
- [`Restore-VESQLIRDatabase`](restore-vesqlirdatabase.md)
- [`Switch-VESQLIRDatabase`](switch-vesqlirdatabase.md)