what is the OS that the progress database runs on at the moment? Although we have specific integration pieces using VSS for Microsoft SQL & Exchange Server, we also have the ability to quiesce and snapshot virtual machines through VMware and the VMtool Snapshot integration in vCenter. This may give you the ability to pause and snapshot your virtual machine VMDK file systems as part of a schedule.
Even though the majority of our customers with databases use the application integration of our snapshots to pause and quiesce the environment, it's best to keep that to a maximum of perhaps every 30mins or 1hour time frames, as it takes a few seconds to pause and un-pause your database. For more granular snapshot recovery points you can then run crash-consistent snapshots alongside the 30mins/hourly snaps. OR it could be that crash-consistent snapshots are good enough for your database to recover from (Oracle databases are perfectly fine recovering from these snapshots, for example).
Hope the above helps.
Thanks Nick, that explanation makes sense. The Progress database runs on Server 2008 R2, and is around 16GB in size. The actual files that I see change throughout the day (extents) are 512MB each.
It sounds like this might be a "try it and see" for our application, which I'm okay with. We're used to making tradeoff decisions that go along with the software we use... Our current approach is 1 application-based "live copy" type backup per day, because it grinds the response time to a halt for everyone using the system for 45-60 seconds when we run it during business hours. So we'll put that feature in the "maybe, but certainly better than now" column for now. I'd want to do some serious testing of the crash-consistent snapshots in our environment before going that route, but it may be as simple as you say.
Thanks for the detailed info, it helps a lot.