---
title: "Get-VBRSQLDatabaseRestoreInterval (obsolete)"
description: "This cmdlet shows date and time of the first and the last available restore point for a selected database. This is reference information that helps you to select an available restore point."
canonical: "https://helpcenter.veeam.com/docs/vbr/powershell/get-vbrsqldatabaserestoreinterval.html"
breadcrumb: "Veeam PowerShell Reference > Veeam PowerShell Reference > Obsolete Cmdlets > Get-VBRSQLDatabaseRestoreInterval (obsolete)"
dateModified: "2026-08-19"
---

# Get-VBRSQLDatabaseRestoreInterval (obsolete)

## Short Description

Shows interval of backups available for a selected database.

::: note

This cmdlet is no longer supported, use the [`Get-VESQLDatabaseRestoreInterval`](https://helpcenter.veeam.com/docs/backup/explorers_powershell/get-vesqldatabaserestoreinterval.html?ver=120) cmdlet instead. To learn more about the `Get-VESQLDatabaseRestoreInterval` 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

```
Get-VBRSQLDatabaseRestoreInterval -Database <VBRSQLDatabase>  [<CommonParameters>]
```

## Detailed Description

This cmdlet shows date and time of the first and the last available restore point for a selected database. This is reference information that helps you to select an available restore point.

## 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 for which you want to get the intervals.</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>
</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

[`VBRDatabaseRestoreInterval`](vbrdatabaserestoreinterval.md)

## Examples

::: dropdown
### Example 1. Getting Restore Interval for VM

This example shows how to get the restore interval for the `crm_db` VM.

```
$restorepoint = Get-VBRApplicationRestorePoint -SQL -Name "crm_db"
Get-VBRSQLDatabase -ApplicationRestorePoint $restorepoint[2] | Get-VBRSQLDatabaseRestoreInterval
```

Perform the following steps:

1. Run the [`Get-VBRApplicationRestorePoint`](get-vbrapplicationrestorepoint.md) cmdlet. Provide the `SQL` parameter. Specify the `Name` parameter value. Save the result to the `$restorepoint` variable.

    The `Get-VBRApplicationRestorePoint` cmdlet will return an array of restore points. Mind the ordinal number of the necessary restore point (in our example, it is the third restore point in the array).

2. Run the `Get-VBRSQLDatabase` cmdlet. Set the `$restorepoint[2]` variable as the `ApplicationRestorePoint` parameter value.
3. Pipe the cmdlet output to the `Get-VBRSQLDatabaseRestoreInterval` cmdlet.

:::

::: dropdown
### Example 2. Getting Restore Interval for Specific Database

This example shows how to get the restore interval for the `Locations` database on the `crm_db` VM.

```
$restorepoint = Get-VBRApplicationRestorePoint -SQL -Name "crm_db"
$locations = Get-VBRSQLDatabase -ApplicationRestorePoint $restorepoint[2] -Name "Locations"
Get-VBRSQLDatabaseRestoreInterval -Database $locations
From                                         To
----                                         --
02/11/2014 12:33:39 PM                       10/28/2015 12:33:39 PM
```

Perform the following steps:

1. Run the [`Get-VBRApplicationRestorePoint`](get-vbrapplicationrestorepoint.md) cmdlet. Provide the `SQL` parameter. Specify the `Name` parameter value. Save the result to the `$restorepoint` variable.

    The `Get-VBRApplicationRestorePoint` cmdlet will return an array of restore points. Mind the ordinal number of the necessary restore point (in our example, it is the third restore point in the array).

2. Run the `Get-VBRSQLDatabase` cmdlet. Set the `$restorepoint[2]` variable as the `ApplicationRestorePoint` parameter value. Specify the `Name` parameter value. Save the result to the `$locations` variable.
3. Run the `Get-VBRSQLDatabaseRestoreInterval` cmdlet. Set the `$locations` variable as the `Database` parameter value.

:::

## Related Commands

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