Devart Forums

Hi

How do we backup the Review Assistant database?

Heyman

Hello,

You should stop the "Devart Review Assistant" service and then copy the database from:
"%ProgramData%\Devart\Review Assistant\reviewassistant.db"

AlexeyN wrote:Hello,

You should stop the "Devart Review Assistant" service and then copy the database from:
"%ProgramData%\Devart\Review Assistant\reviewassistant.db"

Will it help to use database from trial version after purchasing?

Database in not affected in any way, when you perform Review Assistant licensing operation.

yes but its difficult do stop the server for the daily backup. Maybe its possible to use a "real" database like ms sql, oracle, ... so we can do a online backup.

would be important to us to do a regular and easy backup of the reviews

best regards
Andreas

We have planned a new feature - automatic creation of database backups.

thanks - that sounds nice.

But i think the best to many of us would be supporting a major database so we can set up just one backup job. also own reporting would be easier...

best regards
Andreas

Is it possible to use the sqlite3 command utility to backup a database while the "Devart Review Assistant" service is running?

e.g.

sqlite3 reviewassistant.db

SQLite> .backup reviewassistant_backup.db

EDIT:

I've been playing around with this, it seems to work. I was able to restore the reviewassistant.db from a backup while the "DevArt Review Assistant" service was running on my local trial copy. I didn't try it on a server, but I believe the sqlite3 .restore command should handle locks etc.

I tried the following to automate the backup:

1) Download Sqlite3.exe from https://sqlite.org/download.html

2) Copy the sqlite3.exe to the same folder as reviewassistant.db (e.g C:\ProgramData\Devart\Review Assistant)

3) Create a batch file called RunBackup.bat in the same folder

4) Add the following two lines to the batch file:
sqlite3 reviewassistant.db ".backup reviewassistant_backup.db"
if exist reviewassistant_backup.db ren "reviewassistant_backup.db" "reviewassistant_backup_%date:/=-%_%time::=-%.db"

Now if RunBackup is run (either from command line or as a scheduled task) a backup file will be created with the date/time stamp in it (so multiple backups can be kept).

To restore a backup, first rename the relevant backup file from reviewassistant)backup_date_time.db to reviewassistant_backup.db (this is important, if the filename does not match that used to create the backup, the restore fails). From a command prompt enter:
sqlite3 reviewassistant.db

This will open the reviewassistant database in sqlite3. At the sqlite3 prompt, enter:
.restore reviewassistant_backup.db

Then exit sqlite3 by typing .quit