6/3/2023
SAP HANA Tenant Databases
Generated on: 2023-06-03 04:16:03 GMT+0000
SAP HANA Platform | 2.0 SPS 07
PUBLIC
Original content: [Link]
US&state=PRODUCTION&version=2.0.07
Warning
This document has been generated from the SAP Help Portal and is an incomplete version of the official SAP product
documentation. The information included in custom documentation may not re ect the arrangement of topics in the SAP Help
Portal, and may be missing important aspects and/or correlations to other topics. For this reason, it is not for productive use.
For more information, please visit the [Link]
This is custom documentation. For more information, please visit the SAP Help Portal 1
6/3/2023
Delete a Tenant Database
You can delete tenant databases that are no longer required.
Prerequisites
You've navigated to the Database Overview page of the database you want to manage. See Getting to the Database
Overview Page.
You are logged in to the system database (SYSTEMDB).
You have the system privilege DATABASE ADMIN.
Context
If you delete a tenant database that is running SAP HANA 2.0 SPS 01 or later, you have the option to keep the backup
directories of the deleted tenant. Backups can then only be removed by deleting them from the le system. If you delete a
tenant database that is running an earlier version of SAP HANA, the backup directories are deleted automatically. It’s therefore
recommended that if you want to preserve these backup directories, you relocate them before deleting the database.
Note
If a tenant SAP HANA database is enabled for usage with XS advanced and mapped to an organization/space in XS
advanced, then it is recommended not to use cockpit (or the SQL command line interface) to delete the tenant database but
to use the XS advanced xs command line interface. This is necessary so that XS advanced is aware that the tenant database
is no longer available. Note, too, that if you use the XS advanced xs CLI to delete a tenant database used by XS advanced, all
data in the tenant database is lost. See also 'Maintaining Tenant Databases in XS Advanced'.
Procedure
1. At the top of the Database Overview page, click Database Management.
2. Select the tenant to delete and click Stop.
Once stopped, its status changes to Stopped.
3. Click the (Delete)icon for the tenant.
4. If this database is running SAP HANA 2.0 SPS 01 or later, choose whether to Keep Backup Directories or Delete
Directories and proceed with the database deletion, or Cancel the database deletion. If the database is running an
earlier version of SAP HANA, choose whether to Delete Tenant or Cancel the database deletion.
Results
The system commences the process to delete the database. Once deleted, the database disappears from the list. Volumes and
trace les are removed.
Next Steps
If you con gured the SAP Web Dispatcher to route HTTP requests to the deleted database, you need to update the
con guration.
Related Information
This is custom documentation. For more information, please visit the SAP Help Portal 2
6/3/2023
ALTER SYSTEM STOP DATABASE Statement (Tenant Database Management)
DROP DATABASE Statement (Tenant Database Management)
Execute SQL Statements in SAP HANA Studio
Con gure HTTP(S) Access to Tenant Databases via SAP HANA XS Classic
SAP HANA SQL and System Views Reference
Start a Tenant Database
Maintaining Tenant Databases in XS Advanced
This is custom documentation. For more information, please visit the SAP Help Portal 3