Get-VBRSQLDatabase (obsolete)

Short Description

Returns Microsoft SQL Server databases in restore point.

Note

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

Applies to

Platform: VMware, Hyper-V

Product Edition: Standard, Enterprise, Enterprise Plus, Veeam Universal License

Syntax

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

Detailed Description

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

Parameters

Parameter

Description

Type

Required

Position

Accept
Pipeline
Input

ApplicationRestorePoint

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

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

True

Named

True (ByValue,
ByProperty
Name)

Name

Filters the databases in the restore point by database name.

String[]

False

Named

False

<CommonParameters>

This cmdlet supports Microsoft PowerShell common parameters. For more information on common parameters, see Microsoft Docs.

Output Object

VBRSQLDatabase

Examples

Getting Last Restore Point

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

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

$locations = Get-VBRSQLDatabase -ApplicationRestorePoint $crmdb[0] -Name "Locations"

Perform the following steps:

  1. Run the Get-VBRApplicationRestorePoint cmdlet. Provide the SQL parameter. Specify the Name parameter value. Save the result to the $crmdb 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 first restore point in the array).

  1. Run the Get-VBRSQLDatabase cmdlet. Set the $crmdb[0] variable as the ApplicationRestorePoint parameter value. Specify the Name parameter value. Save the result to the $locations variable.

Related Commands

Get-VBRApplicationRestorePoint