Snapshot backups with OpenEdge & VMWare

[Lewis, Tim]

I've been doing some research on database backups four our new VMWare environment that's based on Cisco UCS servers and NetApp (ugghh!) file storage. Our backup service is outsourced and we have a meeting this week to discuss how to change our current backup processes to make best use of the available technology. The outsourcer is proposing using NetApp tools for this but we are using some Veaam products already so they are an option.

I've found Libor's presentation from Exchange 2014 on virtualised environments, but the examples of using Veamm and BackupExec snapshots are a demo and there doesn't seem to be a video.

I've also seen the Knowledgebase article - http://knowledgebase.progress.com/articles/Article/000055417 - and I assume the changes for Centos are applicable to Windows. The only issue I might have is that I have multiple databases that make up my application environment and ideally I'd want to proquiet and snapshot them all at the same time.

If anyone has any experiences they are prepared to share I'd be grateful.

Tim


Tim Lewis
Database Administrator

Home Group
2 Gosforth Park Way, Gosforth Business Park
Newcastle upon Tyne
NE12 8ET

T: 0191 2907827



http://www.facebook.com/HomeGrouphousing
http://www.twitter.com/homegroup
http://www.homegroup.org.uk/



Celebrating 75 years of thriving communities and futures

The following are all part of Home Group:

Home Scotland, Live Smart @ Home, Home Group Developments.

Home Group Limited* (charitable registered society no. 22981R); Home in Scotland Limited** (charitable registered society no. 1935R(S). Scottish Charity no. SC005247) Property Factor ID: PF000277; Live Smart @ Home Limited* (Registered in England under no. 03402204); Home Group Developments Limited* (Registered in England under no. 04664018).

* Registered office address: 2 Gosforth Park Way, Gosforth Business Park, Newcastle upon Tyne NE12 8ET.

** Registered office address: 20 Harvest Road, Newbridge, Edinburgh, EH28 8LW.

This email (and any attachment(s)) is private and intended solely for the recipient. Its unauthorised use, disclosure, storage or copying is not permitted. If you are not the intended recipient please destroy all copies and inform the sender by return e-mail. Internet e-mail is not a secure medium as messages can be intercepted and read by someone else.
Please bear this in mind when deciding whether to send information by e-mail.

For any queries please contact our service desk on +44 (0) 845 155 3222.


This e-mail has been scanned for all viruses by Star.

The service is powered by MessageLabs.
http://www.star.net.uk
____________________________________________________________________________

[Libor Laubacher]

> there doesn't seem to be a video

.. probably for the best :-D

The demo did consist of taking a VEEAM backup of a VM with a running db I believe running Windows. The pre-freeze and post-thaw scripts were present and had proquiet in them and VEEAM was instructed to invoke them via "Use VMware Tools Quiescence" option in the backup job. If you have a multiple databases pre-free/post-thaw scripts would need to proquiet them all.

The default pre-freeze-script.bat and post-thaw-script.bat for Windows is c:\windows or rather %WINDIR% .

With VEEAM you can also use their own custom scripts as well - http://helpcenter.veeam.com/backup/80/vsphere/backup_job_vss_scripts_vm.html

[Lewis, Tim]

Libor

Just one other question that popped into my mind. How does the snapshot work with after-imaging? I assume I’d still want after-imaging running with this, so after the proquiet would I want to switch to the next AI file so that the snapshot and the AI files are aligned?