Removing a service from a tenant database in SAP HANA


Yes, it is possible to remove a server component, which are no longer required. This can be performed using ALTER DATABASE SQL command.

Following perquisites should be met to perform this task −

  • You are logged on to the system database.
  • You have the system privilege DATABASE ADMIN.

To remove a service, you need to open SQL console of the SAP HANA studio and run “ALTER DATABASE” statement.

ALTER DATABASE DB1 REMOVE '<service name>' AT LOCATION 'HOST_A:30XXX'

Updated on: 13-Mar-2020

880 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements