How To Back Up Database

SQL Server

Before updating Review Assistant we strongly recommend you to manually create a backup of your database and move it to your backup location before starting the installation process.

LocalDB

Upon updating Review Assistant to a newer version, a backup file of the Review Assistant database is automatically created in a default installation folder. However, to prevent data loss, we recommend you to move the backup file to you own backup location.

To create a backup of your database, please proceed as follows:

  1. Stop the Review Assistant server using the following command:

    net stop “Devart Review Assistant”

  2. Copy a server database file and move it to your backup location using the following command:

    copy “%ProgramData%\Devart\Review Assistant\reviewassistant.db.bak”

  3. Reboot the Review Assistant server using the following command:

    net start “Devart Review Assistant”

Note: You can combine the above commands in a batch file and run it on schedule to ensure regular data backup.