Get-VBRSQLDatabaseRestoreInterval (obsolete)

In this article

    Short Description

    Shows interval of backups available for a selected database.

    Note

    This cmdlet is no longer supported, use the Get-VESQLDatabaseRestoreInterval cmdlet instead. To learn more about the Get-VESQLDatabaseRestoreInterval cmdlet, see the Veeam Explorers PowerShell Reference.

    Applies to

    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

    Parameter

    Description

    Required

    Position

    Accept
    Pipeline
    Input

    Accept
    Wildcard
    Characters

    Database

    Specifies the database for which you want to get the intervals.

    Accepts VBRSQLDatabase type.

    True

    Named

    True (ByValue,
    ByProperty
    Name)

    False

    <CommonParameters>

    This cmdlet supports Microsoft PowerShell common parameters. For more information about common parameters, see http://go.microsoft.com/fwlink/p/?LinkID=113216.

    Return Type

    VBRDatabaseRestoreInterval

    Example 1

    This command gets the restore interval for the "crm_db" VM.

    $restorepoint = Get-VBRApplicationRestorePoint -SQL -Name "crm_db"

    Get-VBRSQLDatabase -ApplicationRestorePoint $restorepoint[2] | Get-VBRSQLDatabaseRestoreInterval

    Example 2

    This command gets 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

    Related Commands

    Get-VBRSQLDatabase