## 11.7 M\_SNAPSHOTS System View
Provides information about existing snapshots.
## Structure
| Column name       | Data type   | Description                                                      |
|-------------------|-------------|------------------------------------------------------------------|
| HOST              | VARCHAR(64) | Specifies the host name.                                         |
| PORT              | INTEGER     | Specifies the internal port.                                     |
| VOLUME_ID         | INTEGER     | Specifies the persistence volume ID.                             |
| ID                | BIGINT      | Specifies the snapshot ID.                                       |
| TIMESTAMP         | TIMESTAMP   | Specifies the creation time.                                     |
| PURPOSE           | VARCHAR(24) | Specifies why the snapshot was exe­ cuted.                        |
| FOR_BACKUP        | VARCHAR(5)  | Specifies if the snapshot was created for backup: TRUE or FALSE. |
| ANCHOR            | BIGINT      | Specifies the anchor.                                            |
| REDO_LOG_POSITION | BIGINT      | Specifies the redo log position corre­ sponding to the snapshot.  |
| LAST_COMMIT_TIME  | TIMESTAMP   | Specifies the timestamp of the last commit of the snapshot.      |
## Related Information
Monitoring and Managing Tenant Databases M\_DATABASES System View
## Important Disclaimers and Legal Information
## Hyperlinks
Some links are classified by an icon and/or a mouseover text. These links provide additional information. About the icons:
- Links with the icon : Y ou are entering a Web site that is not hosted by SAP . By using such links, you agree (unless expressly stated otherwise in your agreements with SAP) to this:
- The content of the linked-to site is not SAP documentation. You may not infer any product claims against SAP based on this information.
- SAP does not agree or disagree with the content on the linked-to site, nor does SAP warrant the availability and correctness. SAP shall not be liable for any damages caused by the use of such content unless damages have been caused by SAP's gross negligence or willful misconduct.
- Links with the icon : Y ou are leaving the documentation for that particular SAP product or service and are entering a SAP-hosted Web site. By using such links, you agree that (unless expressly stated otherwise in your agreements with SAP) you may not infer any product claims against SAP based on this information.
## Beta and Other Experimental Features
Experimental features are not part of the officially delivered scope that SAP guarantees for future releases. This means that experimental features may be changed by SAP at any time for any reason without notice. Experimental features are not for productive use. You may not demonstrate, test, examine, evaluate or otherwise use the experimental features in a live operating environment or with data that has not been sufficiently backed up.
The purpose of experimental features is to get feedback early on, allowing customers and partners to influence the future product accordingly. By providing your feedback (e.g. in the SAP Community), you accept that intellectual property rights of the contributions or derivative works shall remain the exclusive property of SAP .
## Example Code
Any software coding and/or code snippets are examples. They are not for productive use. The example code is only intended to better explain and visualize the syntax and phrasing rules. SAP does not warrant the correctness and completeness of the example code. SAP shall not be liable for errors or damages caused by the use of example code unless damages have been caused by SAP's gross negligence or willful misconduct.
## Gender-Related Language
We try not to use gender­specific word forms and formulations. As appropriate for context and readability, SAP may use masculine word forms to refer to all genders.
## www.sap.com/contactsap
© 2019 SAP SE or an SAP affiliate company. All rights reserved.
No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP SE or an SAP affiliate company. The information contained herein may be changed without prior notice.
Some software products marketed by SAP SE and its distributors contain proprietary software components of other software vendors. National product specifications may vary.
These materials are provided by SAP SE or an SAP affiliate company for informational purposes only, without representation or warranty of any kind, and SAP or its affiliated companies shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP or SAP affiliate company products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty.
SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE (or an SAP affiliate company) in Germany and other countries. All other product and service names mentioned are the trademarks of their respective companies.
Please see https:/ /www.sap.com/about/legal/trademark.html for additional trademark information and notices.
<!-- image -->