Availability for the Always-On Enterprise
MPlesnerJ
Veeam Software
Posts: 77
Liked: 23 times
Joined: Apr 01, 2014 12:30 pm
Full Name: Martin Plesner-Jacobsen
Contact:

Re: Backup SAP ASE DBs

Post by MPlesnerJ » Jun 08, 2016 10:31 pm

Hi Andreas,

Any news?
Thank you.
/ Martin

kaka81
Influencer
Posts: 13
Liked: 1 time
Joined: Dec 02, 2015 12:56 pm
Full Name: Christoph Moser
Contact:

Re: Backup SAP ASE DBs

Post by kaka81 » Aug 22, 2016 10:41 am

Hi again,

nothing's new here? :(

Thx.
BR, Christoph

Andreas Neufert
Veeam Software
Posts: 2811
Liked: 478 times
Joined: May 04, 2011 8:36 am
Full Name: @AndyandtheVMs Veeam PM
Location: Germany
Contact:

Re: Backup SAP ASE DBs

Post by Andreas Neufert » Aug 22, 2016 10:50 am

https://www.veeam.com/wp-sap-oracle-dep ... guide.html
You can find an appendix about ASE there.

kaka81
Influencer
Posts: 13
Liked: 1 time
Joined: Dec 02, 2015 12:56 pm
Full Name: Christoph Moser
Contact:

Re: Backup SAP ASE DBs

Post by kaka81 » Aug 22, 2016 11:35 am

Hi Andreas,

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

PTide
Veeam Software
Posts: 4246
Liked: 349 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: Backup SAP ASE DBs

Post by PTide » Aug 22, 2016 12:58 pm

Hi,
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

Thanks

Andreas Neufert
Veeam Software
Posts: 2811
Liked: 478 times
Joined: May 04, 2011 8:36 am
Full Name: @AndyandtheVMs Veeam PM
Location: Germany
Contact:

Re: Backup SAP ASE DBs

Post by Andreas Neufert » Aug 22, 2016 1:02 pm

There is another Appendix for MS SQL maybe it was the wrong appendix.

kaka81
Influencer
Posts: 13
Liked: 1 time
Joined: Dec 02, 2015 12:56 pm
Full Name: Christoph Moser
Contact:

Re: Backup SAP ASE DBs

Post by kaka81 » Aug 22, 2016 1:09 pm

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?!

PTide
Veeam Software
Posts: 4246
Liked: 349 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: Backup SAP ASE DBs

Post by PTide » Aug 22, 2016 1:18 pm

There are three options mentioned in the appendix, which one have you configured?

kaka81
Influencer
Posts: 13
Liked: 1 time
Joined: Dec 02, 2015 12:56 pm
Full Name: Christoph Moser
Contact:

Re: Backup SAP ASE DBs

Post by kaka81 » Aug 22, 2016 1:28 pm

sorry, the first one (a) as you have written with enable application aware processing and require successful processing

Andreas Neufert
Veeam Software
Posts: 2811
Liked: 478 times
Joined: May 04, 2011 8:36 am
Full Name: @AndyandtheVMs Veeam PM
Location: Germany
Contact:

Re: Backup SAP ASE DBs

Post by Andreas Neufert » Aug 22, 2016 2:06 pm 1 person likes this post

All 3 options were documented with the intention to bring ASE in a consistent state to backup on image level. (and use VM/Instant VM and File Level Recovery).

You need to handle logs with native scripts from ASE.
Veeam do not provide any tool to delete logs over time and restore to a specific point in time with ASE. (No Veeam Explorer for ASE available).

It is common that the ASE partner have some bavkup scripts that can be modified for Veeam there.
For example you can run your logfile handling script at post script in the Veeam job.

kaka81
Influencer
Posts: 13
Liked: 1 time
Joined: Dec 02, 2015 12:56 pm
Full Name: Christoph Moser
Contact:

Re: Backup SAP ASE DBs

Post by kaka81 » Aug 22, 2016 3:01 pm

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?

And with postscript I could delete log files etc.

Andreas Neufert
Veeam Software
Posts: 2811
Liked: 478 times
Joined: May 04, 2011 8:36 am
Full Name: @AndyandtheVMs Veeam PM
Location: Germany
Contact:

Re: Backup SAP ASE DBs

Post by Andreas Neufert » Aug 22, 2016 3:17 pm

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.

kaka81
Influencer
Posts: 13
Liked: 1 time
Joined: Dec 02, 2015 12:56 pm
Full Name: Christoph Moser
Contact:

Re: Backup SAP ASE DBs

Post by kaka81 » Aug 23, 2016 5:10 am

ok, this sounds good for me.

Just another (maybe stupid) question: what's the best way to backup and replicate these Sybase VMs? Backup every full hour, replication every half hour?

Andreas Neufert
Veeam Software
Posts: 2811
Liked: 478 times
Joined: May 04, 2011 8:36 am
Full Name: @AndyandtheVMs Veeam PM
Location: Germany
Contact:

Re: Backup SAP ASE DBs

Post by Andreas Neufert » Aug 23, 2016 7:24 am

It depends on your needs.
You can consider Replication from Backup maybe to tansport data only once.

At Replica 28 Restore Points are max.
If you need a very high restore point amount at Backup job, consider Syntetic Full with Incrementals (~max 60 incrementals per synt full).

w00ch
Lurker
Posts: 1
Liked: never
Joined: Oct 04, 2017 3:03 am
Full Name: Don Macalalad
Contact:

Re: Backup SAP ASE DBs

Post by w00ch » Oct 04, 2017 6:05 am

Any one can share their current setup on backing up the SAP ASE DBs?

Do i really need to setup VSS for the DB server?

Post Reply

Who is online

Users browsing this forum: Bing [Bot], colmennis, CRossAmalSugar, Google [Bot], tsmith_co and 21 guests