Hi there

I'm looking for Design Pointers/suggestions NOT code !

I have been assigned to develop an App that would maintain 600+ staff daily log.
This Org. Operates on 3 shifts a day/ 7 days a week/ 365 days a year.
After doing some testing, by the end of the year, my MDB would be around 10+ MB.
AND here is the Q:

How would I handle Monthly/Yearly (Back up/Archiving) since restoring would overwrite the original data ?


Thanx.