There are multiple way to stop and start SAP HANA Tenant Database .
But i personally prefer to stop and start SAP HANA Tenant Database using SAP HANA Studio .
Step 1- Launch SAP HANA Studio and open SQL console .
![](http://i0.wp.com/www.sapbasis1solution.com/wp-content/uploads/2019/08/img_5d42b73b42c96.png?w=1289)
Once SQL Console is open then you can execute below mentioned sql commands for Stop and Start SAP HANA Tenant Database.
How to Stop SAP HANA Tenant Database: ( SMH is TENANT DATABASE SID):
alter system stop database SMH
![](http://i1.wp.com/www.sapbasis1solution.com/wp-content/uploads/2019/08/img_5d42b795f0eff.png?w=1289)
How to verify if Tenant database has been stopped:
Execute SQL command:
select * from m_databases;
ACTIVE _STATUS is NO for SMH .It implies database has been stopped.
![](http://i1.wp.com/www.sapbasis1solution.com/wp-content/uploads/2019/08/img_5d42b7d7a9082.png?w=1289)
How to Start SAP HANA Tenant Database:
alter system start database SMH
![](http://i2.wp.com/www.sapbasis1solution.com/wp-content/uploads/2019/08/img_5d42b87bc9c26.png?w=1289)
How to verify if Tenant database has been started:
Execute SQL command:
select * from m_databases;
ACTIVE _STATUS is YES for SMH .It implies database has been started.
![](http://i2.wp.com/www.sapbasis1solution.com/wp-content/uploads/2019/08/img_5d42b8ac2c554.png?w=1289)