Restoring Backups

[Former Member]

We have SAP Configured on SUSE LINUX Server 11.x version. We have been taking backups to using our Network to another Server. The files are being stored in the form of compressed Zip Folders. We are now looking to restore those backups into our SAP environment.
Please can we have a document on how to go about it

[msundararaja_perumal]

Hello,

I believe the backup you are here is only schema backup and not the instance backup, which is being moved to network drive(usually windows).

In order to restore the schema backup, you need to copy the zipped backup file to Linux server using FTP application like Filezilla or WinSCP, then extract them in the Linux server.

Open the HANA Studio and use the import command to restore the backup file as new schema.

As you may be aware that the same/existing schema name cannot be used like SQL Server.

Thanks.

[dennispadia]

Hello Ravindra,

As you have tagged SAP HANA, I assume that the database you are talking about is HANA. You have zipped your HANA database backup and stored in some different storage (or server, as per your saying) and now you want to restore that zipped HANA database, kindly correct me if there is any discrepancy in my understanding.

Based on my understanding, below is the suggestion -

1) As you have mentioned that you HANA database is backed up in zip folder, does this zip folder contains log and catalog backup?

2) Do you want to perform "Point In Time" recovery or you want to recover database to specific data backup?

- The reason I'm asking is that for Point In time you need to make all log backups available from the time of last complete data backup, whereas for database to specific data backup, database will be restore to last complete backup. The recovery type highlighted below requires log and catalog backup as well.

3) If you want to recover database to specific data backup i.e. from the last complete data backup then you just need to unzip your complete data backup from the folder and make it available to server. Here you have two option, either you can provide catalog backup location to read all complete data backup or you can recover database without backup catalog (in this case you just need to provide path of your complete data backup and this will be the location where you have unzipped your complete data backup)

4) If you made your complete data backup available in some NFS file system (after unzip), your restore will take more time as NFS is slower then local file system.

5) You can refer below Wiki for HANA Backup and Recovery procedure

https://wiki.scn.sap.com/wiki/display/SAPHANA/SAP+HANA+Backup+and+Recovery

or you can refer SAP Help portal to refer recovery procedure based on your version.

https://help.sap.com/viewer/6b94445c94ae495c83a19646e7c3fd56/1.0.12/en-US/c3c66b63bb571014b3e5ad8618...

Regards,

Dennis Padia.