Discussions specific to the Microsoft Hyper-V hypervisor
Post Reply
cdlane
Enthusiast
Posts: 53
Liked: 3 times
Joined: Aug 09, 2015 5:48 pm
Full Name: Chris Lane
Contact:

Can Veeam backup SQLite...

Post by cdlane » Sep 24, 2018 1:17 pm

Hi All,

We run a product called Adaxes made by Softerra and I had cause to roll the VM running the software back to the previous night. This resulted in the Adaxes SQLite and associated logs being very broken and I have just had a fun weekend putting it back together.

For now I'll have to create a scheduled task to back up the application using their inbuilt tool which in turn is just backed up by Veeam as part of the file system...hardly convenient though.

Anybody out there with any pointers please?

Rick.Vanover
Veeam Software
Posts: 600
Liked: 127 times
Joined: Nov 30, 2010 3:19 pm
Full Name: Rick Vanover
Location: Columbus, Ohio USA
Contact:

Re: Can Veeam backup SQLite...

Post by Rick.Vanover » Sep 24, 2018 2:33 pm

Hi there cdlane! We don't have an integrated solution for Adaxes (like the Veeam Explorer for SQL). My recommendation is to maybe find a way to manually quiesce the application with a script that would be run at the start of the backup.

A broader recommendation is to do SureBackup - and in the SureBackup step, put in something that you could verify the application restores OK.

Mike Resseler
Product Manager
Posts: 5740
Liked: 612 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: Can Veeam backup SQLite...

Post by Mike Resseler » Sep 25, 2018 10:29 am

Hi Chris,

SQLite is not vss aware. So you need to work with it just like any other non-vss aware clients. As Rick says, look for scripts that you can perform just before and after the backup to get your SQLite DB in a consistent state. What you do at this point in time is actually the same as pulling the plug from the server while it is running (so you are actually in danger of that also.). It is basically only a crash-consistent backup.

Rick.Vanover
Veeam Software
Posts: 600
Liked: 127 times
Joined: Nov 30, 2010 3:19 pm
Full Name: Rick Vanover
Location: Columbus, Ohio USA
Contact:

Re: Can Veeam backup SQLite...

Post by Rick.Vanover » Sep 25, 2018 5:23 pm

Mike's point above is a good re-iteration for SureBackup....

cdlane
Enthusiast
Posts: 53
Liked: 3 times
Joined: Aug 09, 2015 5:48 pm
Full Name: Chris Lane
Contact:

Re: Can Veeam backup SQLite...

Post by cdlane » Oct 01, 2018 7:22 am

Many thanks Chaps, before and after scripts in place to stop/start the relevant services etc.

Mike Resseler
Product Manager
Posts: 5740
Liked: 612 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: Can Veeam backup SQLite...

Post by Mike Resseler » Oct 01, 2018 9:42 am

Chris,
Yes, and some (but please ask SQLite experts) will prefer to even do additional commands on the database to have it in a specific state as a backup file, and then start everything again.

evilaedmin
Expert
Posts: 106
Liked: 13 times
Joined: Jul 26, 2018 8:04 pm
Full Name: Eugene V
Contact:

Re: Can Veeam backup SQLite...

Post by evilaedmin » Oct 02, 2018 1:45 pm

cdlane wrote:
Sep 24, 2018 1:17 pm
I had cause to roll the VM running the software back to the previous night. This resulted in the Adaxes SQLite and associated logs being very broken and I have just had a fun weekend putting it back together.
Hi cdlane,
This is perhaps a derailment of your question but SQLite should be durable in the face of crash consistency, Dr. Hipp has much documentation about its design and implementation. Is it possible your vendor's application is somehow disabling built in protections? Link: https://www.sqlite.org/howtocorrupt.html

Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests