Adding a service to a tenant database

SAP Developer

Answered on 25th Apr, 2018

To scale out a tenant database and/or distribute it across multiple hosts, you can add further server components, for example, an additional index server or a separate XS server. You add a service to a tenant database using the ALTER DATABASE SQL command.

You do this from the system database using the following command:

ALTER DATABASE ADD <service> 

Following perquisites should be met to perform this task:

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