Get-VBRSQLDatabaseRestoreInterval
Short Description
Shows interval of backups available for a selected database.
Applies to
Platform: VMware, Hyper-V
Product Edition: Standard, Enterprise, Enterprise Plus
Syntax
Related Commands
Return Type
Detailed Description
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.
Parameters
Parameter | Description | Required | Position | Accept | Accept |
Database | Specifies the database for which you want to get the intervals. | True | Named | True (by Value | False |
<CommonParameters>
This cmdlet supports Microsoft PowerShell common parameters. For more information about common parameters, see http://go.microsoft.com/fwlink/p/?LinkID=113216.
Example 1
This command gets the restore interval for the "crm_db" VM.
PS C:\PS> $restorepoint = Get-VBRApplicationRestorePoint -SQL -Name "crm_db" PS C:\PS> Get-VBRSQLDatabase -ApplicationRestorePoint $restorepoint[2] | Get-VBRSQLDatabaseRestoreInterval |
Example 2
This command gets the restore interval for the "Locations" database on the "crm_db" VM.
PS C:\PS> $restorepoint = Get-VBRApplicationRestorePoint -SQL -Name "crm_db" PS C:\PS> $locations = Get-VBRSQLDatabase -ApplicationRestorePoint $restorepoint[2] -Name "Locations" PS C:\PS> Get-VBRSQLDatabaseRestoreInterval -Database $locations From To |