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

Get-VBRSQLDatabase

On This Page

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

Return Type

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.

True

Named

True (by Value
FromPipeline, ValueFromPipeline
ByPropertyName)

False

Name

Filters the databases in the restore point by database name.

False

Named

False

True

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"