Hi there ...

we are trying to improve our Backup-Routine ..
by comparing tha Backup-FileDate with the Database-FileDates (edbtbl,edbidx,edbblb)
we are trying to detect changed databases ..
a few problems/questions are coming up ...

- Is it possible to Flush all changes to Disk (EDBServer)
- Is there a kind of last-modify-date for an entire database or the tables?

- Using a Trigger  is no real option ...  (Too slow (many tables with many more records)))
- Selecting over all Tables is also not possible ... (The Tables are really big ... and not all are having modifydate-columns )

(We already splitted our Database into several smaller Databases to gain a better performance ...)

However ... if we could simply force a flush .. we could do a findfirst/findnext (which we are already doing) and see what table has been changed ...

Volker


Have you thought of setting up a mirrored system and using the built in publishing system to keep it up to date?

Setting it up to start with would be a bit of a problem but once its up and running it should be fine, and as an added benefit you can even backup the mirrored system.

Roy Lambert

Volker,

Roy is correct - you should definitely use the replication for "hot backup" processing.  It is ideally suited for this purpose.

Tim Young
Elevate Software
www.elevatesoft.com