Advice on best way to Auto Backup Tables

[js061256]

I have a whole bunch of database tables in various databases to backup. Is there a standard or preferred way to do this? My first thought was to create a separate database with linked tables and run make table queries periodically to keep the backups current.

Am I on the right track? Does anyone have code examples that might work?

 

[namliam]

Why not simply copy the whole database as a backup on a periodic basis?