Get-VEHANADatabase

Short Description

Returns backed-up SAP HANA databases.

Product: Veeam Backup & Replication

Product Edition: Enterprise Plus, Veeam Universal License

Syntax

Get-VEHANADatabase [-System] <VEHANASystem> [-Name <String>] [-Tenant] [<CommonParameters>]

Detailed Description

This cmdlet returns an array of backed-up databases located on the specified SAP HANA system. After you get the backed-up SAP HANA databases, you can use the Start-VEHANADatabaseRestore cmdlet to restore the SAP HANA databases you need.

Parameters

Parameters
Parameter	Description	Type	Required	Position	Accept Pipeline Input
Name	Specifies the name of an SAP HANA database. The cmdlet will return the SAP HANA database with the specified name.	`String`	False	Named	False
System	Specifies the name of the SAP HANA system on which the databases reside. The cmdlet will return the databases on the specified SAP HANA system. Accepts the `VEHANASystem` object. To get this object, run the `Get-VEHANASystem` cmdlet.	`VEHANASystem`	True	0	True (ByValue)
Tenant	Defines that the cmdlet returns only the tenant databases on the selected SAP HANA system.	`SwitchParameter`	False	Named	False

<CommonParameters>

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

Output Object

The cmdlet returns the VEHANADatabase[] array that contains backed-up SAP HANA databases.

Examples

Get-VEHANADatabase Example 1. Getting All Databases on the Specified System

This example shows how to return all SAP HANA databases on a backed-up SAP HANA system.

$session = Get-VEHANARestoreSession

$system = Get-VEHANASystem -Session $session[0]

$database = Get-VEHANADatabase -System $system

Perform the following steps:

Run the Get-VEHANARestoreSession cmdlet. Save the result to the $session variable.

The cmdlet will return an array of active restore sessions. Note the ordinal number of the necessary restore session. In this example, it is the first restore session in the array.
Run the Get-VEHANASystem cmdlet. Set the $session variable as the Session parameter value and select the necessary restore session. Save the result to the $system variable.
Run the Get-VEHANADatabase cmdlet. Set the $system variable as the System parameter value. Save the result to the $database variable to be able to use it with other cmdlets.

Get-VEHANADatabase Example 2. Getting All Tenant Databases on the Specified System

This example shows how to return only the tenant databases that reside on the selected SAP HANA system.

$session = Get-VEHANARestoreSession

$system = Get-VEHANASystem -Session $session[0]

$database = Get-VEHANADatabase -System $system -Tenant

Perform the following steps:

Run the Get-VEHANARestoreSession cmdlet. Save the result to the $session variable.

The cmdlet will return an array of active restore sessions. Note the ordinal number of the necessary restore session. In this example, it is the first restore session in the array.
Run the Get-VEHANASystem cmdlet. Set the $session variable as the Session parameter value and select the necessary restore session. Save the result to the $system variable.
Run the Get-VEHANADatabase cmdlet. Set the $system variable as the System parameter value. Provide the Tenant parameter to only return the tenant databases on the selected system. Save the result to the $database variable to be able to use it with other cmdlets.

Get-VEHANADatabase Example 3. Getting SAP HANA Database with Specified Name

This example shows how to get a specific SAP HANA database using its name.

$session = Get-VEHANARestoreSession

$system = Get-VEHANASystem -Session $session[0]

$database = Get-VEHANADatabase -System $system -Name "Tenant1"

Perform the following steps:

Run the Get-VEHANARestoreSession cmdlet. Save the result to the $session variable.

The cmdlet will return an array of active restore sessions. Note the ordinal number of the necessary restore session. In this example, it is the first restore session in the array.
Run the Get-VEHANASystem cmdlet. Set the $session variable as the Session parameter value and select the necessary restore session. Save the result to the $system variable.
Run the Get-VEHANADatabase cmdlet. Set the $system variable as the System parameter value. Specify the name of the necessary database as the Name parameter value. Save the result to the $database variable to be able to use it with other cmdlets.