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

Get-VBRSQLDatabase

In this article

    Short Description

    Returns Microsoft SQL Server databases in restore point.

    Applies to

    Platform: VMware, Hyper-V

    Product Edition: Standard, Enterprise, Enterprise Plus

    Syntax

    Get-VBRSQLDatabase -ApplicationRestorePoint <VBRApplicationRestorePoint> [-Name <string[]>]  [<CommonParameters>]

    Related Commands

    Get-VBRApplicationRestorePoint

    Return Type

    VBRSQLDatabase

    Detailed Description

    This cmdlet returns Microsoft SQL Server databases in a selected restore point.

    Parameters

    Parameter

    Description

    Required

    Position

    Accept
    Pipeline
    Input

    Accept
    Wildcard
    Characters

    Application
    Restore
    Point

    Specifies the restore point from which you want to get the databases.

    Accepts VBRApplicationRestorePoint.

    True

    Named

    True (by Value
    FromPipeline, ValueFromPipeline
    ByPropertyName)

    False

    Name

    Filters the databases in the restore point by database name.

    False

    Named

    False

    True

    <CommonParameters>

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

    Example

    This example shows how to get the last restore point of the "Locations" database on the "crm_db" VM.

    PS C:\PS> $crmdb = Get-VBRApplicationRestorePoint -SQL -Name "crm_db"

    PS C:\PS> $locations = Get-VBRSQLDatabase -ApplicationRestorePoint $crmdb[0] -Name "Locations"