Hi, Case:
“I copied first five pages from database using online backup api & during sleep time other process write to database which is actually part of first copied five pages, In that case at the end of backup can I assure I will have my database backed up with latest changes. (Changes done during backup as well) As of now I am having database on Flash memory. I have followed below link for details. It say “If another thread or process writes to the source database while this function is sleeping, then SQLite detects this and usually restarts the backup process when sqlite3_backup_step() is next called”. - It means it will start back-up from start or resume from last left page but making sure all update will be written in backup file. - Is their any issue if process acquiring database handle will do both the operation (Writing & Backup). http://www.sqlite.org/backup.html Cheers Techi _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users