HANA Query to find older service specific log backups?


select destination_path from m_backup_catalog_files o where o.last_redo_log_position is not null and exists(select 1 from m_backup_catalog_files i where i.backup_id = <backup_id> and
i.source_id = o.source_id and i.redo_log_position > o.last_redo_log_position) order by destination_path

Tags: HANA SQL Query sysntax, HANA SQLScript, HANA Backup Query,
Share this article :

Post a Comment

Copyright © 2011. SAP HANA TUTORIALS FREE - S/4 HANA - All Rights Reserved