Skip to Content
Author's profile photo John Currie

SAP HANA dynamic tiering SP 12: What to do if Backup Cannot Complete


You are running SAP HANA dynamic tiering SP 12.

A 447 error like the following appears:


backup could not be completed

[110112] Extended storage backup error:

[SAP][ODBC Driver]There is already a backup

or selective restore in progress. \n

— (dblib/db_backupID.cxx 2213)


Backup does not complete because a log backup for point-in-time recovery is underway. Point-in-time log backups are automatic (the error can occur without another user running a backup).


To solve the issue in SP 12, perform this workaround:


1. Query the backup catalog for the state of all log backups that are finished or in progress:


SELECT state_name FROM m_backup_catalog MB, m_backup_catalog_files MBF


MB.backup_id = MBF.backup_id


service_type_name = ‘esserver’


entry_type_name = ‘log backup’


2. If a state name in the output displays as “prepared” or “running,” then a dynamic tiering log backup is in progress.


3. When you see the “finish” entry in the output, the log backup is complete and you can run the data backup.


You can query the views M_BACKUP_CATALOG and M_BACKUP_CATALOG_FILES for dynamic tiering data and log backups just as you do for SAP HANA database data and log backups.


For more information on SAP HANA dynamic tiering troubleshooting, see the SAP HANA Dynamic Tiering: Administration Guide.

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.