Help Center
Choose product document...
Veeam Backup & Replication 9.5
PowerShell Reference

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

Get-VBRSQLDatabaseRestoreInterval -Database <VBRSQLDatabase> [<CommonParameters>]

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
Pipeline
Input

Accept
Wildcard
Characters

Database

Specifies the database for which you want to get the intervals.

Accepts VBRSQLDatabase type.

True

Named

True (by Value
FromPipeline, ValueFromPipeline
ByPropertyName)

False

<CommonParameters>

This cmdlet supports Microsoft PowerShell common parameters. For more information about common parameters, see http://go.microsoft.com/fwlink/p/?LinkID=113216.

Return Type

VBRDatabaseRestoreInterval

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
----                                         --
02/11/2014 12:33:39 PM                       10/28/2015 12:33:39 PM

Related Commands

Get-VBRSQLDatabase

Veeam Large Logo

User Guide for VMware vSphere

User Guide for Microsoft Hyper-V

Enterprise Manager User Guide

Veeam Cloud Connect Guide

Veeam Backup Explorers User Guide

PowerShell Reference

RESTful API Reference

Veeam Backup FREE Edition User Guide

Veeam Backup for Microsoft Office 365

Veeam ONE Documentation

Veeam Agent for Windows Documentation

Veeam Agent for Linux Documentation

Veeam Management Pack Documentation