Back-Up New Data Only

[jalbao]

I am using SQLServer 2000 on NT4.

I have an app that contains many databases - each database is owned by a different user. I would like to be able to send each user an .mdb file once a day that contains all/only the data that has been changed/added to thier database in that one day.

Can SQL2000 do this? If somebody can point me in the right direction i'd be stoked.

 

[fluteplr]

One way I can thing of to do this is and some fields to each table in the database that track when the data was last modified/added you can do this with a combination of default values for the added (getdate()) and update triggers for the modifed info. You could then create a dts job that exported all the records in each table with the appropriate dates to a mdb.

Posibility number 2. Give all your users MSDE, you can restore an sql server backup to msde and disrtibute backups, this does not address the only new and modified data issue however.