by kaka81 » Mon Aug 22, 2016 11:35 am people like this post
thank you for reply but I've some questions: you mean in backup job: guest processing - enable application-aware processing - applications - select VM - edit - Tab "SQL" and here "backup logs periodically". Is that correct? On VM the "Windows Shadow Copy" Service is running (C:\Windows\system32\vssvc.exe)
Is that correct? Thank you very much. BR, Christoph
by PTide » Mon Aug 22, 2016 12:58 pm people like this post
you mean in backup job: guest processing - enable application-aware processing - applications - select VM - edit - Tab "SQL" and here
No, for SAP ASE backup you need to make sure that you have "Enable appliaction-aware processing" option enabled as well as "Require successful processing" in "General" tab. Please check the whitepaper Andreas has provided you with the link to, p.67
by kaka81 » Mon Aug 22, 2016 1:09 pm people like this post
These settings I've configured from the beginning last October but in my opinion that's not a consistent backup for sybase ASE databases because I'm not able to recover database from e.g. 1 hour ago, only whole VM from last backup (every day @22:00)? And my SAP partner told me that transaction logs etc. are growing bigger and bigger and I should delete them. I don't have these problems with MS SQL Server?!
by kaka81 » Mon Aug 22, 2016 3:01 pm people like this post
If I understand correct - I want consistent backup of Sybase ASE DBs with a max delta of for example 1h. So I had to schedule the backup job periodically every hour (or less) to get consistent backups? is that correct? So if original VM gets broken I could restore this VM from backup with e.g. 1h delta (means backup 1h ago) without any issues?
Yes, thats one of the option. You can then restore to the point of backup with Veeam. If you have one database per server, you can use Instant VM Recovery to bringt the service back within ~5 min (2min + OS boot).
Another option would be to backup once a day ( or more frequent with Veeam) and backup the logs with a generic ASE command to another server. Then there is maybe an option to restore the database with Veeam (maybe file restore, Instant VM Recovery or Database dump restore) and then rollforward the logs with "until_time". I am not a ASE specialist so you need to work with one to get this done and tested. If you can schedule the logbackup high frequent this would give you better RPO but less RTO compared with my first option above.