[sqlite] SQLite - Support for VSS writer

2015-12-04 Thread Rowan Worth
On 3 December 2015 at 22:00, Richard Hipp wrote: > On 12/3/15, Murdare, Vijaykumar S (GE Oil & Gas) > 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 cop

[sqlite] SQLite - Support for VSS writer

2015-12-03 Thread Paul Sanderson
You shouldn't need to back up the shm file as this will be recreated if needed. You naming convention is also off, you mean mydatabase.sqlite-journal mydatabase.sqlite-wal mydatabase.sqlite-shm so mydatabase.sqlite* would be what's required (which would include the unneeded shm file). Paul www.

[sqlite] SQLite - Support for VSS writer

2015-12-03 Thread Simon Slavin
On 3 Dec 2015, at 10:17am, Murdare, Vijaykumar S (GE Oil & Gas) wrote: > 1) If read operation is in progress, then can I take backup safely with > file copy or any other third party tool? When taking a backup of the database file you should also copy all other files with similar names i

[sqlite] SQLite - Support for VSS writer

2015-12-03 Thread Murdare, Vijaykumar S (GE Oil & Gas)
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? 2) If my application made the changes and committed the changes to SQLite and immediately after

[sqlite] SQLite - Support for VSS writer

2015-12-03 Thread Richard Hipp
On 12/3/15, Murdare, Vijaykumar S (GE Oil & Gas) 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

[sqlite] SQLite - Support for VSS writer

2015-12-01 Thread Murdare, Vijaykumar S (GE Oil & Gas)
Hi, We are planning to use windows VSS ((Volume Shadow Copy) feature for backup & restore SQLite databases. I would like to know, does SQLite support VSS (Volume Shadow Copy Service) writer supported by the Windows Operating system to create point in time consistent shadow copies (snapshots) fo

[sqlite] SQLite - Support for VSS writer

2015-12-01 Thread Keith Medcalf
inglists.sqlite.org [mailto:sqlite-users- > bounces at mailinglists.sqlite.org] On Behalf Of Murdare, Vijaykumar S (GE > Oil & Gas) > Sent: Tuesday, 1 December, 2015 01:28 > To: sqlite-users at mailinglists.sqlite.org > Cc: Manneri, Niranjan (GE Oil & Gas) > Subject: