Scribd
Upload
6 views2 pages

SAP HANA ALTER SYSTEM Command Guide

The document is a generated SAP HANA SQL Reference Guide for the SAP HANA Platform, specifically version 2.0 SPS 07, created on June 1, 2023. It provides information on the 'ALTER SYSTEM START DATABASE' statement used for starting specified tenant databases, including syntax, permissions, and an example. However, it warns that this is an incomplete version of the official documentation and should not be used for productive purposes.

Uploaded by

chhsu921
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
6 views2 pages

SAP HANA ALTER SYSTEM Command Guide

The document is a generated SAP HANA SQL Reference Guide for the SAP HANA Platform, specifically version 2.0 SPS 07, created on June 1, 2023. It provides information on the 'ALTER SYSTEM START DATABASE' statement used for starting specified tenant databases, including syntax, permissions, and an example. However, it warns that this is an incomplete version of the official documentation and should not be used for productive purposes.

Uploaded by

chhsu921
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

6/1/2023

SAP HANA SQL Reference Guide for SAP


HANA Platform
Generated on: 2023-06-01 15:35:18 GMT+0000

SAP HANA Platform | 2.0 SPS 07

PUBLIC

Original content: [Link]


US&state=PRODUCTION&version=2.0.07

Warning

This document has been generated from the SAP Help Portal and is an incomplete version of the official SAP product
documentation. The information included in custom documentation may not re ect the arrangement of topics in the SAP Help
Portal, and may be missing important aspects and/or correlations to other topics. For this reason, it is not for productive use.

For more information, please visit the [Link]

This is custom documentation. For more information, please visit the SAP Help Portal 1
6/1/2023

ALTER SYSTEM START DATABASE Statement (Tenant Database


Management)
Starts the speci ed database.

Syntax

ALTER SYSTEM START DATABASE <database_name> [ FROM FALLBACK SNAPSHOT ]

Syntax Elements
<database_name>

Speci es the database to start.

<database_name> ::= <identifier>

FROM FALLBACK SNAPSHOT

Starts the tenant database using the fallback snapshot. This allows you to restore the tenant database to the state it was in
when the fallback snapshot was created. For more information about fallback snapshots, see the SAP HANA Tenant Databases
Guide .

Permissions
You must have the DATABASE ADMIN or DATABASE START privilege to use this statement.

Example
Start the my_database database.

ALTER SYSTEM START DATABASE my_database;

Related Information
ALTER DATABASE Statement (Tenant Database Management)
Create a Fallback Snapshot
M_SNAPSHOTS System View
M_DATABASES System View

This is custom documentation. For more information, please visit the SAP Help Portal 2

You might also like