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.

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

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

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:

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).
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.