One suggestion about database backup

[bx93 0]

Suppose there are lots tables in your database instance, and there maybe lots data within them. Backup task may cost u many time.What I suggest here is to add one more table in the instance, which contains the current delta of every other tables. Structure of TblLogs:1) record id, to be the index of this table, maybe automatic increased.2) tableName, contains the name of every table3) delta can be a int type. increase every time when the certain table is modified (ignore of select operation).With such table, we are able to develop a application, which check if the delta of a table is increased, and only backup the table which really need to be updated.Current suggestion has not been tried yet. Hope someone could present better solution here.

[miCRoSCoPiC^eaRthLinG 0]

-Hi, as you said yourself - you have to design an application or rather (if using windows or linux) - a background process that constantly monitors any change in the databas and commit incremental backups. Instead of that I'd rather use MySQL or PGSQL locally and use their auto-incremental backup feature (the same process thats used to generate incremental binary logs for replication servers) - much easier and much faster - with virtually to user-end programming on your part.