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 |
|---|---|---|---|---|---|
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, |
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.
Related Commands