---
title: "Start-VBRSQLDatabaseRestore (obsolete)"
description: "This cmdlet starts restore of a selected SQL database."
canonical: "https://helpcenter.veeam.com/docs/vbr/powershell/start-vbrsqldatabaserestore.html"
breadcrumb: "Veeam PowerShell Reference > Veeam PowerShell Reference > Obsolete Cmdlets > Start-VBRSQLDatabaseRestore (obsolete)"
dateModified: "2026-08-19"
---

# Start-VBRSQLDatabaseRestore (obsolete)

## Short Description

Starts Microsoft SQL database restore.

::: note

This cmdlet is no longer supported, use the [`Start-VESQLRestoreSession`](https://helpcenter.veeam.com/docs/backup/explorers_powershell/start-vesqlrestoresession.html?ver=120) cmdlet instead. To learn more about the `Start-VESQLRestoreSession` cmdlet, see the [Veeam Explorers PowerShell Reference](https://helpcenter.veeam.com/docs/backup/explorers_powershell/getting_started.html?ver=120).

:::

**Platform**: VMware, Hyper-V

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

## Syntax

This cmdlet provides two parameter sets.

-   For restoring to the original location:

    ```
    Start-VBRSQLDatabaseRestore -Database <VBRSQLDatabase> [-GuestCredentials <CInternalCredentials>] [-SqlCredentials <CInternalCredentials>] [-ToPointInTime <datetime>] [-Force] [-Wait]  [<CommonParameters>]
    ```

-   For restoring to another location:

    ```
    Start-VBRSQLDatabaseRestore -Database <VBRSQLDatabase> [-ServerName <string>] [-InstanceName <string>] [-DatabaseName <string>] [-GuestCredentials <CInternalCredentials>] [-SqlCredentials <CInternalCredentials>] [-ToPointInTime <datetime>] [-Force] [-Wait]  [<CommonParameters>]
    ```

## Detailed Description

This cmdlet starts restore of a selected SQL database.

## Parameters

<table style="width:100%;" class="Blue_Table">
  <tr style="vertical-align:top">
    <th>
      <p>Parameter</p>
    </th>
    <th>
      <p>Description</p>
    </th>
    <th>
      <p>Type</p>
    </th>
    <th>
      <p>Required</p>
    </th>
    <th>
      <p>Position</p>
    </th>
    <th>
      <p>Accept<br/>Pipeline<br/>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 the database you want to restore.</p>
    </td>
    <td>
      <p>Accepts the <a href="vbrsqldatabase.md" class="T_Filenames">VBRSQLDatabase</a> object. To get this object, run the <a href="get-vbrsqldatabase.md" class="T_Filenames">Get-VBRSQLDatabase</a> cmdlet.</p>
    </td>
    <td>
      <p>True</p>
    </td>
    <td>
      <p>Named</p>
    </td>
    <td>
      <p>True (ByValue,<br/>ByProperty<br/>Name)</p>
    </td>
  </tr>
  <tr style="vertical-align:top">
    <td>
      <p class="Table_Text_Bold"><span class="Table_Text_Bold">ServerName</span></p>
    </td>
    <td>
      <p>Used for restoring to another location.</p>
      <p>Specifies the name of the target server. The database will be restored to that server.</p>
    </td>
    <td>
      <p>String</p>
    </td>
    <td>
      <p>False</p>
    </td>
    <td>
      <p>Named</p>
    </td>
    <td>
      <p>False</p>
    </td>
  </tr>
  <tr style="vertical-align:top">
    <td>
      <p class="Table_Text_Bold"><span class="Table_Text_Bold">InstanceName</span></p>
    </td>
    <td>
      <p>Used for restore to another location.</p>
      <p>Specifies the name of the instance. The database will be restored to that instance.</p>
    </td>
    <td>
      <p>String</p>
    </td>
    <td>
      <p>False</p>
    </td>
    <td>
      <p>Named</p>
    </td>
    <td>
      <p>False</p>
    </td>
  </tr>
  <tr style="vertical-align:top">
    <td>
      <p class="Table_Text_Bold"><span class="Table_Text_Bold">DatabaseName</span></p>
    </td>
    <td>
      <p>Used for restore to another location.</p>
      <p>Specifies the new name of the database. The database will be restored with that name.</p>
    </td>
    <td>
      <p>String</p>
    </td>
    <td>
      <p>False</p>
    </td>
    <td>
      <p>Named</p>
    </td>
    <td>
      <p>False</p>
    </td>
  </tr>
  <tr style="vertical-align:top">
    <td>
      <p class="Table_Text_Bold"><span class="Table_Text_Bold">GuestCredentials</span></p>
    </td>
    <td>
      <p>Specifies the user credentials to authenticate with the target server.</p>
      <p>If not specified, Veeam will use the credentials indicated in the backup job settings.</p>
    </td>
    <td>
      <p>Accepts the <span class="T_Filenames">CInternalCredentials</span> object. To get this object, run the <a href="get-vbrcredentials.md" class="T_Filenames">Get-VBRCredentials</a> cmdlet.</p>
    </td>
    <td>
      <p>False</p>
    </td>
    <td>
      <p>Named</p>
    </td>
    <td>
      <p>False</p>
    </td>
  </tr>
  <tr style="vertical-align:top">
    <td>
      <p class="Table_Text_Bold"><span class="Table_Text_Bold">SqlCredentials</span></p>
    </td>
    <td>
      <p>Specifies the credentials to authenticate with the target SQL instance.</p>
      <p>If not specified, Veeam will use the credentials indicated in the backup job settings.</p>
    </td>
    <td>
      <p>Accepts the <span class="T_Filenames">CInternalCredentials</span> object. To get this object, run the <a href="get-vbrcredentials.md" class="T_Filenames">Get-VBRCredentials</a> cmdlet.</p>
    </td>
    <td>
      <p>False</p>
    </td>
    <td>
      <p>Named</p>
    </td>
    <td>
      <p>False</p>
    </td>
  </tr>
  <tr style="vertical-align:top">
    <td>
      <p class="Table_Text_Bold"><span class="Table_Text_Bold">ToPointInTime</span></p>
    </td>
    <td>
      <p>Used to restore the database to a specific transaction.</p>
      <p>Specifies the time of the transaction.</p>
    </td>
    <td>
      <p>datetime</p>
    </td>
    <td>
      <p>False</p>
    </td>
    <td>
      <p>Named</p>
    </td>
    <td>
      <p>False</p>
    </td>
  </tr>
  <tr style="vertical-align:top">
    <td>
      <p class="Table_Text_Bold"><span class="Table_Text_Bold">Force</span></p>
    </td>
    <td>
      <p>If set, the command will overwrite the existing database with the database from backup. </p>
      <p><span class="T_Controls">Note</span>: the cmdlet will show no prompt.</p>
    </td>
    <td>
      <p>SwitchParameter</p>
    </td>
    <td>
      <p>False</p>
    </td>
    <td>
      <p>Named</p>
    </td>
    <td>
      <p>False</p>
    </td>
  </tr>
  <tr style="vertical-align:top">
    <td>
      <p class="Table_Text_Bold"><span class="Table_Text_Bold">Wait</span></p>
    </td>
    <td>
      <p>Defines that the command waits for the process to complete before accepting more input.</p>
    </td>
    <td>
      <p>SwitchParameter</p>
    </td>
    <td>
      <p>False</p>
    </td>
    <td>
      <p>Named</p>
    </td>
    <td>
      <p>False</p>
    </td>
  </tr>
</table>

`<CommonParameters>`

This cmdlet supports Microsoft PowerShell common parameters. For more information on common parameters, see [ Microsoft Docs](https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.core/about/about_commonparameters?view=powershell-7).

## Output Object

[`VBRSession`](vbrsession.md)

## Examples

### Restoring Microsoft SQL Database to Original Location

This example shows how to restore a database to a selected point in time to the original location.

```
$restorepoint = Get-VBRApplicationRestorePoint -SQL -Name "crm_db"
$locations = Get-VBRSQLDatabase -ApplicationRestorePoint $restorepoint[2] -Name "Locations"
$guestcreds = Get-VBRCredentials -Name "tech\administrator"
$sqlcreds = Get-VBRCredentials -Name "sql_administrator"
Get-VBRSQLDatabaseRestoreInterval -Database $locations
Start-VBRSQLDatabaseRestore -Database $locations -GuestCredentials $guestcreds -SqlCredentials $sqlcreds -ToPointInTime "10/28/2015 12:33:39 PM"
```

1. Get the database you want to restore:

    - Run the [`Get-VBRApplicationRestorePoint`](get-vbrapplicationrestorepoint.md) cmdlet. Provide the `SQL` parameter value. Specify the `Name` parameter value. Save it to the `$restorepoint` variable.
    - Run the [`Get-VBRSQLDatabase`](get-vbrsqldatabase.md) cmdlet. Set the `$restorepoint[2]` variable as the `ApplicationRestorePoint` parameter value. Specify the `Name` parameter value. Save it to the `$locations` variable.

2. Get the credentials to connect to the server and to the database instance:

    - Run the [`Get-VBRCredentials`](get-vbrcredentials.md) cmdlet. Specify the `Name` parameter value. Save it to the `$guestcreds` variable.
    - Run the [`Get-VBRCredentials`](get-vbrcredentials.md) cmdlet. Specify the `Name` parameter value. Save it to the `$sqlcreds` variable.

3. Run the [`Get-VBRSQLDatabaseRestoreInterval`](get-vbrsqldatabaserestoreinterval.md) cmdlet. Set the `$locations` variable as the `Database` parameter value.
4. Run the `Start-VBRSQLDatabaseRestore` cmdlet. Specify the following settings:

    - Set the `$locations` variable as the `Database` parameter value.
    - Set the `$guestcreds` variable as the `GuestCredentials` parameter value.
    - Set the `$sqlcreds` variable as the `SqlCredentials` parameter value.
    - Specify the `ToPointInTime` parameter value.

## Related Commands

- [`Get-VBRSQLDatabase`](get-vbrsqldatabase.md)
- [`Get-VBRCredentials`](get-vbrcredentials.md)