Database backup
Database backup
Hi
How do we backup the Review Assistant database?
Heyman
How do we backup the Review Assistant database?
Heyman
Re: Database backup
Hello,
You should stop the "Devart Review Assistant" service and then copy the database from:
"%ProgramData%\Devart\Review Assistant\reviewassistant.db"
You should stop the "Devart Review Assistant" service and then copy the database from:
"%ProgramData%\Devart\Review Assistant\reviewassistant.db"
Re: Database backup
Will it help to use database from trial version after purchasing?AlexeyN wrote:Hello,
You should stop the "Devart Review Assistant" service and then copy the database from:
"%ProgramData%\Devart\Review Assistant\reviewassistant.db"
Re: Database backup
Database in not affected in any way, when you perform Review Assistant licensing operation.
Re: Database backup
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
would be important to us to do a regular and easy backup of the reviews
best regards
Andreas
Re: Database backup
We have planned a new feature - automatic creation of database backups.
Re: Database backup
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
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
Re: Database backup
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
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