Adding a service to a tenant database


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 −

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

Updated on: 13-Mar-2020

304 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements