Get-VBRSQLDatabaseRestoreInterval (obsolete)
Shows interval of backups available for a selected database.
Platform: VMware, Hyper-V
Product Edition: Standard, Enterprise, Enterprise Plus, Veeam Universal License
Get-VBRSQLDatabaseRestoreInterval -Database <VBRSQLDatabase> [<CommonParameters>] |
This cmdlet shows date and time of the first and the last available restore point for a selected database. This is reference information that helps you to select an available restore point.
Parameter | Description | Type | Required | Position | Accept
Pipeline
Input |
|---|
Database | Specifies the database for which you want to get the intervals. | Accepts the VBRSQLDatabase object. To get this object, run the Get-VBRSQLDatabase cmdlet. | True | Named | True (ByValue,
ByProperty
Name) |
<CommonParameters>
This cmdlet supports Microsoft PowerShell common parameters. For more information on common parameters, see Microsoft Docs.
VBRDatabaseRestoreInterval
This example shows how to get the restore interval for the crm_db VM. $restorepoint = Get-VBRApplicationRestorePoint -SQL -Name "crm_db" Get-VBRSQLDatabase -ApplicationRestorePoint $restorepoint[2] | Get-VBRSQLDatabaseRestoreInterval |
Perform the following steps: - Run the Get-VBRApplicationRestorePoint cmdlet. Provide the SQL parameter. Specify the Name parameter value. Save the result to the $restorepoint 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 third restore point in the array). - Run the Get-VBRSQLDatabase cmdlet. Set the $restorepoint[2] variable as the ApplicationRestorePoint parameter value.
- Pipe the cmdlet output to the Get-VBRSQLDatabaseRestoreInterval cmdlet.
|
This example shows how to get the restore interval for the Locations database on the crm_db VM. $restorepoint = Get-VBRApplicationRestorePoint -SQL -Name "crm_db" $locations = Get-VBRSQLDatabase -ApplicationRestorePoint $restorepoint[2] -Name "Locations" Get-VBRSQLDatabaseRestoreInterval -Database $locations From To
---- --
02/11/2014 12:33:39 PM 10/28/2015 12:33:39 PM |
Perform the following steps: - Run the Get-VBRApplicationRestorePoint cmdlet. Provide the SQL parameter. Specify the Name parameter value. Save the result to the $restorepoint 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 third restore point in the array). - Run the Get-VBRSQLDatabase cmdlet. Set the $restorepoint[2] variable as the ApplicationRestorePoint parameter value. Specify the Name parameter value. Save the result to the $locations variable.
- Run the Get-VBRSQLDatabaseRestoreInterval cmdlet. Set the $locations variable as the Database parameter value.
|
Related Commands
Get-VBRSQLDatabase
Example 1. Getting Restore Interval for VM