---
title: "Get-VEHANADatabase"
description: "Returns backed-up SAP HANA databases. Product: Veeam Backup & Replication Product Edition: Enterprise Plus, Veeam Universal License This cmdlet returns an array of backed-up databases located on the specified SAP HANA system."
canonical: "https://helpcenter.veeam.com/docs/vbr/explorers_powershell/get-vehanadatabase.html"
breadcrumb: "Veeam Explorers PowerShell Reference > Veeam Explorers PowerShell Reference > Veeam Explorer for SAP HANA > Get-VEHANADatabase"
dateModified: "2026-08-18"
---

# 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`](start-vehanadatabaserestore.md) cmdlet to restore the SAP HANA databases you need.

## Parameters

<table style="width:100%;" class="Blue_Table">
      <tr style="vertical-align:top">
        <th style="width:20%;">
          <p>Parameter</p>
        </th>
        <th style="width:20%;">
          <p>Description</p>
        </th>
        <th style="width:20%;">
          <p>Type</p>
        </th>
        <th style="width:10%;">
          <p>Required</p>
        </th>
        <th style="width:10%;">
          <p>Position</p>
        </th>
        <th style="width:10%;">
          <p>Accept Pipeline Input</p>
        </th>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">Name</span></p>
        </td>
        <td>
          <p>Specifies the name of an SAP HANA database. The cmdlet will return the SAP HANA database with the specified name.</p>
        </td>
        <td style="width:10%;">
          <p><code>String</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">System</span></p>
        </td>
        <td>
          <p>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.</p><p>Accepts the <a href="vehanasystem.md"><code>VEHANASystem</code></a> object. To get this object, run the <a href="get-vehanasystem.md"><code>Get-VEHANASystem</code></a> cmdlet.</p>
        </td>
        <td style="width:10%;">
          <p><a href="vehanasystem.md"><code>VEHANASystem</code></a></p>
        </td>
        <td style="width:10%;">
          <p>True</p>
        </td>
        <td style="width:10%;">
          <p>0</p>
        </td>
        <td style="width:10%;">
          <p>True (ByValue)</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">Tenant</span></p>
        </td>
        <td>
          <p>Defines that the cmdlet returns only the tenant databases on the selected SAP HANA system.</p>
        </td>
        <td style="width:10%;">
          <p><code>SwitchParameter</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
    </table>

`<CommonParameters>`

This cmdlet supports Microsoft PowerShell common parameters. For more information on common parameters, see the [About Common Parameters](http://go.microsoft.com/fwlink/p/?LinkID=113216) section of Microsoft Docs.

## Output Object
The cmdlet returns the [`VEHANADatabase`](vehanadatabase.md)`[]` array that contains backed-up SAP HANA databases.

## Examples

::: example
### 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:

1. Run the [`Get-VEHANARestoreSession`](get-vehanarestoresession.md) 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.

2. Run the [`Get-VEHANASystem`](get-vehanasystem.md) cmdlet. Set the `$session` variable as the `Session` parameter value and select the necessary restore session. Save the result to the `$system` variable.
3. 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.

:::

::: example
### 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:

1. Run the [`Get-VEHANARestoreSession`](get-vehanarestoresession.md) 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.

2. Run the [`Get-VEHANASystem`](get-vehanasystem.md) cmdlet. Set the `$session` variable as the `Session` parameter value and select the necessary restore session. Save the result to the `$system` variable.
3. 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.

:::

::: example
### 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:

1. Run the [`Get-VEHANARestoreSession`](get-vehanarestoresession.md) 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.

2. Run the [`Get-VEHANASystem`](get-vehanasystem.md) cmdlet. Set the `$session` variable as the `Session` parameter value and select the necessary restore session. Save the result to the `$system` variable.
3. 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.

:::

## Related Commands

- [`Get-VEHANARestoreSession`](get-vehanarestoresession.md)
- [`Get-VEHANASystem`](get-vehanasystem.md)