Availability for the Always-On Enterprise
Post Reply
collegeinstructor
Lurker
Posts: 2
Liked: never
Joined: May 12, 2010 2:04 pm
Full Name: Michael Giffin
Contact:

Progress database and VMware Quiescence

Post by collegeinstructor » May 12, 2010 2:10 pm

We have a Progress database on a virtual Linux server
We have had to manually stop the progress database when we have run the backup to avoid corrupting data.
Will the Veeam backup using VMware Quiescence enable me to run a backup of this server without corrupting the database?

Please include a brief explanation as to why or why not.

Vitaliy S.
Veeam Software
Posts: 21726
Liked: 1306 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Progress database and VMware Quiescence

Post by Vitaliy S. » May 12, 2010 2:48 pm

Hello Michael,

I would use built-in functionality of pre-freeze and post-thaw scripts execution while using VMware Tools Quiescence. Those scripts may automate your manual procedures of stopping and starting progress DB while VM snapshot is being taken. In this case you will have your DB backups in consistent state.

For more information about the scripts please refer to link below:

http://www.veeam.com/forums/viewtopic.p ... 05&p=14199

Hope it helps!

Gostev
Veeam Software
Posts: 23216
Liked: 2970 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Progress database and VMware Quiescence

Post by Gostev » May 12, 2010 4:03 pm

Couple of more relevant threads with examples:
http://www.veeam.com/forums/viewtopic.p ... thaw#p4859
http://www.veeam.com/forums/viewtopic.p ... thaw#p6823

You can also get a whitepaper from our support detailing how to perform transactionally consistent backups of MySQL running on Linux VM using VMware pre-freeze/post-thaw to created quiesced snapshots. It should be useful as a reference for how to set everything up.

Alxs
Novice
Posts: 3
Liked: never
Joined: Mar 28, 2015 6:40 pm
Full Name: Alexis Monnier
Contact:

[MERGED] Backup a VM which have a progress database installe

Post by Alxs » Apr 01, 2015 11:01 am

Hello,

I try to find the safest way to backup a VM which have a progress database on it (Open Edge 11.5).

I know that the only supported way to backup a database by progress is to use their own system to do the backup :

http://knowledgebase.progress.com/artic ... cle/P11011
http://knowledgebase.progress.com/artic ... popup=true

So I know that veeam won't be able to do a consistent backup of the database. (It's not a problem since I do a databse dump every day with progress tools)
But do I have a risk to corrupt the database during a veeam backup with vss-aware option enable or not ?

Thanks in advance

Vitaliy S.
Veeam Software
Posts: 21726
Liked: 1306 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Progress database and VMware Quiescence

Post by Vitaliy S. » Apr 01, 2015 12:42 pm

No, there is no risk of corrupting the database by just creating/removing VM snapshots.

Alxs
Novice
Posts: 3
Liked: never
Joined: Mar 28, 2015 6:40 pm
Full Name: Alexis Monnier
Contact:

Re: Progress database and VMware Quiescence

Post by Alxs » Apr 06, 2015 6:30 am

Ok thank you for your reply.

So for you I can safely do a veeam vss aware backup of this vm ?
Or is that better to disable the "vss-aware" option ?

v.Eremin
Veeam Software
Posts: 15412
Liked: 1164 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Progress database and VMware Quiescence

Post by v.Eremin » Apr 06, 2015 8:55 am

So for you I can safely do a veeam vss aware backup of this vm ?
Yes, if it's installed on top of Windows-based VM

Post Reply

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 19 guests