Database backup

Database backup

Postby heyman » Wed 24 Jul 2013 19:38

Hi

How do we backup the Review Assistant database?

Heyman
heyman
 
Posts: 1
Joined: Wed 24 Jul 2013 19:18

Re: Database backup

Postby AlexeyN » Thu 25 Jul 2013 09:27

Hello,

You should stop the "Devart Review Assistant" service and then copy the database from:
"%ProgramData%\Devart\Review Assistant\reviewassistant.db"
AlexeyN
Devart Team
 
Posts: 244
Joined: Wed 12 Sep 2012 12:09

Re: Database backup

Postby allev » Thu 22 Aug 2013 11:54

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?
allev
 
Posts: 8
Joined: Fri 16 Aug 2013 11:21

Re: Database backup

Postby AlexeyN » Thu 22 Aug 2013 12:01

Database in not affected in any way, when you perform Review Assistant licensing operation.
AlexeyN
Devart Team
 
Posts: 244
Joined: Wed 12 Sep 2012 12:09

Re: Database backup

Postby ima-aa » Sun 20 Oct 2013 20:05

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
ima-aa
 
Posts: 2
Joined: Sun 20 Oct 2013 19:03

Re: Database backup

Postby AlexeyN » Mon 21 Oct 2013 10:40

We have planned a new feature - automatic creation of database backups.
AlexeyN
Devart Team
 
Posts: 244
Joined: Wed 12 Sep 2012 12:09

Re: Database backup

Postby ima-aa » Mon 21 Oct 2013 11:38

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
ima-aa
 
Posts: 2
Joined: Sun 20 Oct 2013 19:03

Re: Database backup

Postby rhames » Tue 03 Mar 2015 10:29

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
rhames
 
Posts: 2
Joined: Tue 03 Mar 2015 10:09


Return to Review Assistant