Maybe we are trying to get too fancy here.

Here is perhaps a too simplistic but maybe a useful approach.

Problem: How to back up data that has been changed since some arbitrary
defined date time:

Solution: Every table has a field which stores a timestamp. The timestamp
is updated on update or insert. The backup program is able to scan this
field and back up only those records which fall in a predefined window.

It won't solve all the problems but it's really easy to set up and may be
good enough for most peoples needs. Of course this can be done with
triggers now but it would be neat if the database engine could keep the
timestamps up for you transparently.



:wq
Tim Uckun
Due Diligence Inc. http://www.diligence.com/ Americas Background
Investigation Expert.
If your company isn't doing background checks, maybe you haven't considered
the risks of a bad hire.