When I take a select query from the M_SNAPSHOTS view, it gets snapshots. How can I delete?

[former_member587980]

Hi All,

I execute the query below;

select * FROM "SYS"."M_SNAPSHOTS"

I want to delete these entries.How to proceed step by step?

Regards,

[HakanHaslaman · Accepted solution]

You can try to delete the snapshot using hdbcons: 2222218 - FAQ: SAP HANA Database Server Management Console (hdbcons)

You can use the command "snapshot l" to list all snapshots, getting the snapshot id. Then delete them running the command "snapshot d <snapshot_id>"