This is an archive version of the document. To get the most up-to-date information, see the current version.

Get-VESQLIRDatabase

Short Description

Returns Microsoft SQL Server databases that are published within an instant recovery session.

Applies to

Veeam Backup & Replication

Product Edition: Enterprise, Enterprise Plus, Veeam Universal License

Syntax

Get-VESQLIRDatabase [[-DatabaseName] <string>] [<CommonParameters>]

Detailed Description

This cmdlet returns an array of backed-up SQL Server databases that are published within an instant recovery session.

After you get published SQL Server databases within an instant recovery session, you can perform the following operations with these databases:

Parameters

Parameter

Description

Type

Required

Position

Accept Pipeline Input

DatabaseName

Specifies a name of a Microsoft SQL Server database. The cmdlet will return an array of databases with the specified name.

String

False

0

False

<CommonParameters>

This cmdlet supports Microsoft PowerShell common parameters. For more information on common parameters, see the About Common Parameters section of Microsoft Docs.

Output Object

The cmdlet returns the VESQLIRDatabase[] object that contains an array of SQL Server databases that are published within an instant recovery session.

Examples

Example 1. Getting SQL Server Databases with Specified Name

This command returns a list of the Fiscal database within the specified Microsoft SQL restore session.

$IRDatabase = Get-VESQLIRDatabase -DatabaseName "Fiscal"