Backup Software / Features / Database Backup Software / SQLite Backup
SQLite backup can be simple but tricky, as a typical SQLite database is merely a file, no more. You can copy this file… and get too many errors to handle with. Alternatively, you can trust to a recommended backup solution, Handy Backup, and do all SQLite copy table actions without an effort!
Version 8.2.0, built on 30 September 2020 110 MB
These are the two ways to perform SQLite backup database:
Both methods can provide effective SQLite backup and restore. We are recommending you using the first method usually, and turning to ODBC configuration when you wish to set up a multi-source backup task processing many different databases.
You can create SQLite backup database for C# applications, or make a copy of SQLite local app, or even backup SQLite database Android-style (when connecting your Android device as a USB external drive) with common methods.
You can either merely to restore a SQLite database to its original position, or to clone it to another place – for migration, mirroring or creating a test database, for example. Just select an advanced mode in a recovery task and then click “Change Location” on Step 3, to select a new destination for SQLite backup.
You can backup SQLite database to Google Drive, Amazon S3, to almost any other popular cloud, to a private cloud via WebDAV, or to an FTP service, or to a NAS, to a local drive, an external USB device or to any place you want! A plenty of plug-ins in Handy Backup allow perfect storage for your SQLite backup!
Version 8.2.0, built on 30 September 2020 . 110 MB Backup Software from Novosoft LLC. 89 USD per license.
The Professional solution can make automatic SQLite backup and recovery along with any other user-type and specific data you use in your daily job.
Here we are describing how to make a SQLite backup using the common Computer data source. To set up an automatic backup task for your SQLite data, please follow the next instruction:
Note: You can use the “Computer” plug-in and “File filters…” option instead, to seek for files you need by file extensions (often such as “.sqlite” or “.db3”) or by name. By this way, you can even separate one SQLite application from another, e.g., create only a SQLite3 backup.
That is all. Handy Backup requires no further steps for automating the SQLite backup job.
To recover a SQLite file from backup, create a recovery task on Step 1. Then on Step 2 you must find and select a file backup.hbi with all recovery information. Handy Backup always creates this file in your SQLite backup storage folder.
After selecting this file, click “Next” and proceed to create a recovery task as described in the User Manual. However, if you plan to create a copy or a mirror of some SQLite backup database, work in advanced mode and click “Change Location” on Step 3, to select a new destination for databases.
Note: You must use the same plug-in (“Database” or “Computer”) for recovery that was being used for SQLite backup. It is true for both recovering and migrating purposes.
Besides using Handy Backup, other ways to create a SQLite backup database are in exist. Here we are shortly describing some of these ways.
Using Handy Backup for saving SQLite data copies, you can guarantee yourself from flaws, errors and inconveniences of any other way to backup SQLite databases.
Try the might of Handy Backup by downloading a free, full-scale trial version on a 30-days test period!
thanks a bundle..
Copyright © 2004-2021 Novosoft LLC. All rights reserved. Handy Backup software.10685-B Hazelhurst Dr., Houston, TX 77043, United States Tel.: +1 (707) 703-13-11
Back to Top