---
title: "Switch-VESQLIRDatabase"
description: "Performs switchover of a Microsoft SQL Server database published within an instant recovery session. Product: Veeam Backup & Replication Product Edition: Enterprise, Enterprise Plus, Veeam Universal License This cmdlet performs a manual switchover of"
canonical: "https://helpcenter.veeam.com/docs/vbr/explorers_powershell/switch-vesqlirdatabase.html"
breadcrumb: "Veeam Explorers PowerShell Reference > Veeam Explorers PowerShell Reference > Veeam Explorer for Microsoft SQL Server > Switch-VESQLIRDatabase"
dateModified: "2026-08-20"
---

# Switch-VESQLIRDatabase

## Short Description
Performs switchover of a Microsoft SQL Server database published within an instant recovery session.

**Product**: Veeam Backup & Replication

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

## Syntax
```
Switch-VESQLIRDatabase [-Database] <VESQLIRDatabase> [<CommonParameters>]
```

## Detailed Description
This cmdlet performs a manual switchover of a Microsoft SQL Server database published within an instant recovery session. You can perform a switchover after all database files are copied to the target server and the cache file is synchronized. For more information on the switchover options, see the [Switchover](https://helpcenter.veeam.com/docs/vbr/userguide/vesql_switchover.html?ver=13) section of the Veeam Explorers User Guide.

Run the [`New-VESQLIRSwitchOverOptions`](new-vesqlirswitchoveroptions.md) cmdlet to define the switchover option settings.

## 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">Database</span></p>
        </td>
        <td>
          <p>Specifies a Microsoft SQL Server database. The cmdlet will switchover this database.</p><p>Accepts the <a href="vesqlirdatabase.md"><code>VESQLIRDatabase</code></a> object. To get this object, run the <a href="get-vesqlirdatabase.md"><code>Get-VESQLIRDatabase</code></a> cmdlet.</p>
        </td>
        <td style="width:10%;">
          <p><a href="vesqlirdatabase.md"><code>VESQLIRDatabase</code></a></p>
        </td>
        <td style="width:10%;">
          <p>True</p>
        </td>
        <td style="width:10%;">
          <p>0</p>
        </td>
        <td style="width:10%;">
          <p>True (ByValue)</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 Learn.

## Examples

::: example
### Starting Manual Switchover of Published Microsoft SQL Server Database

This example shows how to perform a manual switchover of the `fiscal` database.

```
$IRDatabase = Get-VESQLIRDatabase -DatabaseName "fiscal"
Switch-VESQLIRDatabase -Database $IRDatabase
```

Perform the following steps:

1. Run the [`Get-VESQLIRDatabase`](get-vesqlirdatabase.md) cmdlet. Specify the `DatabaseName` parameter value. Save the result to the `$IRDatabase` variable.
2. Run the `Switch-VESQLIRDatabase` cmdlet. Set the `$IRDatabase` variable as the `Database` parameter value.

:::

## Related Commands

[`Get-VESQLIRDatabase`](get-vesqlirdatabase.md)