SAP HANA Backup & Recovery Validation

A sample EMPLOYEE table was created and populated with five employee records to establish a known baseline before backup operations began.

sql>CREATE COLUMN TABLE EMPLOYEE (
sql>  EMP_ID INTEGER,
sql>  NAME NVARCHAR(50),
sql>  DEPARTMENT NVARCHAR(50)
sql>);
sql>
sql>INSERT INTO EMPLOYEE VALUES
sql>(1,'John Smith','Sales'),
sql>(2,'Sarah Jones','Finance'),
sql>(3,'Michael Brown','IT'),
sql>(4,'Emma Wilson','HR'),
sql>(5,'David Taylor','Operations');
sql>
sql>SELECT * FROM EMPLOYEE;

01-employee-data-created.png

Fullscreen

A Complete Data Backup was performed to create a consistent recovery point before any changes were made to the business data.

sql>BACKUP DATA USING FILE ('EMPLOYEE_FULL_BACKUP');

02-complete-backup.png

Fullscreen

Before initiating the database recovery procedure, the SAP HANA Backup Catalog was reviewed to confirm that the Complete Data Backup had been successfully registered and that a valid recovery point was available. A detailed investigation of backup verification is documented separately in the Backup Verification (M_BACKUP_CATALOG) case study.

sql>SELECT
sql>  ENTRY_TYPE_NAME,
sql>  STATE_NAME,
sql>  SYS_START_TIME
sql>FROM M_BACKUP_CATALOG
sql>ORDER BY SYS_START_TIME DESC;

03-backup-catalog.png

Fullscreen

Business records were intentionally deleted from the EMPLOYEE table to simulate accidental data loss as part of the recovery validation exercise.

sql>DELETE FROM EMPLOYEE;
sql>COMMIT;

04-simulated-data-deletion.png

Fullscreen

Two verification queries were executed to confirm that the employee records had been deleted before the recovery procedure was initiated.

sql>SELECT * FROM EMPLOYEE;
sql>
sql>SELECT COUNT(*) AS TOTAL_ROWS FROM EMPLOYEE;

05-empty-employee-table.png

Fullscreen

05B-row-count-verification.png

Fullscreen

The SAP HANA Recovery Wizard was launched and the NBU tenant database selected as the recovery target.

06-recovery-wizard.png

Fullscreen

Point-in-Time Recovery was configured by selecting a recovery timestamp immediately before the DELETE transaction occurred. Backup used: EMPLOYEE_FULL_BACKUP.

07-point-in-time-recovery.png

Fullscreen

The tenant database was restored using the selected Complete Data Backup together with the required transaction log backups to the selected recovery point.

08-recovery-successful.png

Fullscreen

A final SQL verification was performed to confirm that the original employee records had been successfully restored.

sql>SELECT * FROM EMPLOYEE;

09-restored-employee-data.png

Fullscreen