SAP HANA Best Practices

For SAP HANA best practices in Amazon and Azure environments, see the following links:

Backup Operations Considerations

Storage Policies

Use the following guidelines when you assign a storage policies:

  • Use a separate storage policy for data backups and log backups

  • Configure the following options for the data storage policy:

    • Enable deduplication

    • Compression

  • Enable resource caching for the log storage policy

Restore Operations

Initialize Log Area Option

When you select the Initialize Log Area option, the software only replays the log entries from the backup when it is required. The following are the most common scenarios when you use the option:

Note

Consider your environment when you choose the option.

  • When you have a corrupt catalog

  • When the log area is not usable

  • When you perform a database copy or a system copy

Data Only Restore

The following are the most common scenarios when you use the option:

  • When the catalog is corrupted

  • When you do not want to replay the logs

Point-in-Time Catalog Restore

The following are the most common scenarios when you use the option:

  • When the most recent catalog backup is corrupted

  • When you perform multiple restore operations with the Initialize Log Area option

Loading...