This is an archive version of the document. To get the most up-to-date information, see the current version.

Get-VESQLDatabaseRestoreInterval

In this article

    Short Description

    Returns details on available restore period for backed-up Microsoft SQL databases.

    Applies to Veeam Backup & Replication

    Product Edition: Community, Standard, Enterprise, Enterprise Plus

    Syntax

    Get-VESQLDatabaseRestoreInterval [-Database] <VESQLDatabase>  [<CommonParameters>]

    Detailed Description

    This cmdlet returns details on available restore period for backed-up Microsoft SQL databases.

    Parameters

    Parameter

    Description

    Type

    Required

    Position

    Accept Pipeline Input

    Accept Wildcard Characters

    Database

    Specifies a backed-up Microsoft SQL database. The cmdlet will return details on an available restore period for the specified database.

    Accepts the VESQLDatabase object. To get this object, run the Get-VESQLDatabase cmdlet.

    True

    0

    True (ByValue)

    False

    <CommonParameters>

    This cmdlet supports Microsoft PowerShell common parameters. For more information on common parameters, see the About CommonParameters section of Microsoft Docs.

    Return Type

    The cmdlet returns the VESQLDatabaseRestoreInterval object that contains details on available restore period for backed-up Microsoft SQL databases.

    Examples

    Getting Details on Available Restore Period for Backed-up Microsoft SQL Databases

    This example shows how to get details on an available restore period for a backed-up Microsoft SQL database.

    $session = Get-VESQLRestoreSession

    $database = Get-VESQLDatabase -Session $session[0] -Name "SQLDatabase"

    Get-VESQLDatabaseRestoreInterval -Database $database

    You must perform the following steps:

    1. Run the Get-VESQLRestoreSession cmdlet. Save the result to the $session variable.
    2. Run the Get-VESQLDatabase cmdlet. Set the $session variable as the Session parameter value. Specify the Name parameter value. Save the result to the $database variable.
    3. Run the Get-VESQLDatabaseRestoreInterval cmdlet. Set the $database variable as the Database parameter value.

    Related Commands