Once the Veeam configuration is completed, SAP HANA needs to be configured to use the correct plugin configuration files when running backups, this can be done using SAP HANA Studio, SAP HANA Cockpit or Native SQL commands. Note that if using the default file generated by the Veeam config wizard, this will be located at "/opt/veeam/VeeamPluginforSAPHANA/veeam_config.xml".
All of the below native SQL configuration examples are setting values for the System layer. When setting System layer parameters all tenants will inherit the property unless otherwise overridden specifically for that tenant. To override the values set at the System layer either connect to the tenant database with the administrative user and set the parameters there, or set the parameter at the Tenant layer.
To set the catalog backup parameter file using native SQL:
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('backup', 'CATALOG_BACKUP_PARAMETER_FILE') = 'file location' WITH RECONFIGURE"
Note that the catalog backups will need to be set to use Backint as well, this can be done with the following native SQL statement:
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('backup', 'CATALOG_BACKUP_USING_BACKINT') = 'true' WITH RECONFIGURE"To set the data backup parameter file using native SQL:
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('backup', 'DATA_BACKUP_PARAMETER_FILE') = 'file location' WITH RECONFIGURE"
To set the log backup parameter file using native SQL:
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('backup', 'LOG_BACKUP_PARAMETER_FILE') = 'file location' WITH RECONFIGURE"
Note that the log backups will need to be set to use backint as well.
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('backup', 'LOG_BACKUP_USING_BACKINT') = 'true' WITH RECONFIGURE"To view or set parameters in SAP HANA Studio, navigate to the Configuration view and in the Global.ini file find the section for backup: