Stopping a SAP HANA Cloud Database

In this lesson, you'll learn how to stop your SAP HANA Cloud database instance that you previously created in your SAP Business Technology Platform (BTP) account.

As a database administrator, you need to stop your company's SAP HANA Cloud database deployed in the SAP Business Technology Platform.

From the SAP BTP cockpit, navigate to your SAP BTP subaccount (1), in the navigation panel select Instances and subscriptions (2), and select the SAP HANA Cloud (3) to open the SAP HANA Cloud Central.

The SAP HANA Cloud Central (1) opens in a new browser tab. This makes it easier to navigate between the SAP HANA Cloud Central and SAP BTP Cockpit.

To open the Actions Menu for the selected cloud database, select the °°° (2) button. From the Actions menu, select the Stop (3) option to shutdown the SAP HANA Cloud database instance.

Your SAP HANA Cloud database instance is now being stopped. The whole shutdown process takes around 30 seconds.

It's also possible to stop an SAP HANA Cloud database instance using the Cloud Foundry CLI. Before you can stop a database instance, you need to install the Cloud Foundry CLI and log on to the SAP BTP as previously explained.

To Stop an SAP HANA Cloud database using the Cloud Foundry CLI, execute the following steps:

1. Open a Linux Terminal or Windows PowerShell.
2. Log in to the SAP BTP using the command cf login -o <organisation> -s <space> -a <API endpoint> and enter your credentials.
3. To create a new database service, execute the command:
   Code Snippet

   Copy code

   Copy code

   Switch to dark mode

   Switch to dark mode

   123456
   cf update-service <service name> -c
   '{"data":
       {
         "serviceStopped": true
       }
    }'

   Example:

   Code Snippet

   Copy code

   Copy code

   Switch to dark mode

   Switch to dark mode

   1
   cf update-service HC200-Demo-Database -c '{ "data": {"serviceStopped": true}}'

   The above command will stop the started database.

Have a look at the Start and Stop an Instance Using the CLI page to have a complete list of parameters that can be used to stop a database instance.