It will support the same power-fail consistency as any other non-VSS aware application.
That is, VSS will function as designed -- it will "look" like you "turned off the power" and then did an "offline" backup -- the resulting backup will be crash consistent. Like any product that uses such techniques to backup a running system while it is, well, running, such as BESR, Acronis, NT Backup, the built-in backup stuff in windows, and on and on, you will experience the same result. The backup may be working or it may be useless. Just like when you arbitrarily crash a computer by turning off the power, it may or may not ever work again. So the answer is yes, it will work just like anything else that is not VSS aware. SQLite is a library, not an application. It would be to the application designer who is using the SQLite librarys' job to intercept the notifications from VSS so and action them in such a way as to ensure that the application is in an application-consistent state when VSS is making its crash-consistent backup. This is much the same way as an "application" (Exchange, SQL Server, etc) can have application hooks into VSS. It is the application programmer who looks after such things, not the library writer. The library has no way of knowing how to make the application consistent. Only the application designer knows that. > -----Original Message----- > From: sqlite-users-bounces at mailinglists.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: [sqlite] SQLite - Support for VSS writer > > 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) for SQLite database? > > Thanks and Regards, > Vijay > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
