On 12/3/15, Murdare, Vijaykumar S (GE Oil & Gas) <vijaykumar.murdare at ge.com> wrote: > Hi, > > Also, I would like to know while taking the backup of online databases: > > 1) If read operation is in progress, then can I take backup safely with > file copy or any other third party tool?
Yes. > > 2) If my application made the changes and committed the changes to > SQLite and immediately after that backup operation is started, then can I > assure the backup of committed changes are taken (Is there any flush delay > issue?) > There are no "flush delays". The commit operation does not return until all content is safely on disk. -- D. Richard Hipp drh at sqlite.org
