1. I am working on my software development project which involves database design. Can anyone recommend a nice and simple database design document template or at least suggest the most important chapters which the document should include? Would be even better if it is a template and it is filled in with some sample data.
2. My requirements include database backup, archiving and restore. Can anyone explain the concepts behind this functionality and more particularly, the difference between backup and archiving?
Backup is simply saving your database data to an external file. Archiving is the process of copying these backups and retaining them for a period of time, usually on a separate file system or even at a separate site, in case your primary data site is struck by a catastrophe.
If it's not practically useful, then it's practically useless.