Restore from backup

It is highly recommended that you make regular backup copies of all data under memoQ TMS.

You need the backup - usually the latest one - if you lose memoQ TMS to a malfunction, or when you need to transfer memoQ TMS to a different computer.

You can restore a backup copy in the Deployment tool: In the memoQ TMS section, just click Restore from backup. But it is not as simple as this.

When you restore a backup copy, it will restore memoQ TMS to the exact same point in time when the backup was made. You would not do this if memoQ TMS were working perfectly.

You must restore data on the same version: For example, if you back up data form memoQ TMS 9.3 (any build), you need to restore them on memoQ TMS 9.3.

Don't make changes unless you have experience operating computer networks and Microsoft SQL Server, and everything written here is clear to you.

  1. Log in to the memoQ TMS computer through Remote Desktop.
  2. Make sure you have your backup file at hand - on the server computer, not on your own.

  3. Download memoQ TMS, and run the package. The Deployment tool installs and starts.

    Download the same version that made the backup: Don't download the latest version - download the one where the backup package was made from.
    To access previous versions, open the Downloads page. Scroll down to find the version you need. Click the down arrow to expand that version. Click the orange Download button, and in the memoQ TMS row, click the Download link.
    There is just one problem: You cannot find out the version of the backup package from the package itself. You need to take note of the version when you make the backup.

  4. In the memoQ TMS section, click Restore from backup. The Restore memoQ TMS from a backup wizard will also install memoQ TMS, and upgrade your data if necessary.

    Careful about SQL Server: You must use the same version and edition of SQL Server as the "old" installation of memoQ TMS. For example, if the "old" memoQ TMS was on SQL Server 2012 Standard, you must use SQL Server 2012 or higher, and the Standard or the Enterprise edition. SQL Server Express will not do; SQL Server 2008 will not do.

    Moving a memoQ TMS cloud to your own server? You will need SQL Server 2014 Express or higher. To get your backup, open the My Account page for your memoQ TMS cloud subscription on the memoQ.com website, and download your backup package.

    deptool-restore-mqs

  5. Next to the Restore package box, click the ellipsis ellipsis_button button. An Open window appears. Find the backup package, click it, and click Open.
  6. You can specify a log file where the restore program keeps record of the events during the restore. This is optional, but highly recommended. Next to the Log file box, click the ellipsis ellipsis_button button. A Save As window opens. Choose a folder and a name for the log file, and click Save. The log file will be a plain text (.txt) file.
  7. The restore program can also bring back the settings of the server from the backup file. The settings under Configurations to restore are there because it is possible that the server is now in a different network than it was before. You can choose new server addresses. To learn more about the internal and external address, read the Install memoQ TMS topic.

  8. If the new server is in the same Windows domain as the previous one, you can also restore the single-sign-on settings. This is important because after the restore, the same users must be able to log in to memoQ TMS. Normally, the single-sign-on settings will be restored. If you cannot restore them - because the server is in a different domain or not in a domain, for example -, clear the Restore SSO configuration from backup package check box.

    SQL server on a different machine? During the restore, you may need to enter the connection string and a user name and a password for the SQL server that hosts the database.

  9. To begin the restore, click Restore. The restore of the database and the settings begins.

Error restoring the database? This happens when you move a memoQ TMS cloud to your own server - and if the memoQ TMS paths and the database paths are different from the "old" server. In this case, you must restore the database manually. (The Restore wizard will restore everything else - do this after that is finished.) Unzip the backup package file, and extract the database file. It has the .mdf extension. To do this, It is recommended to use the SQL Management Studio if it is installed. If not, you can also use the sqlcmd program. With sqlcmd, you need to restore the database using the with replace option. To learn more, read the Useful SQL commands topic.

If something goes wrong in the data of memoQ TMS, you can restore an earlier state of those data. To do this, you need to restore an earlier backup.

Do this only if you have daily backups: If you plan to use backup packages for this, it is highly recommended to run daily backups. Otherwise you may lose too much data if you restore a backup file from last week or from last month. To learn how to set up a daily backup, read the Schedule memoQ TMS backup topic.

  1. Log in to the memoQ TMS computer through Remote Desktop.
  2. Make sure you have your backup file at hand - on the server computer, not on your own.

    Check if you have all necessary permissions: You must be an administrator on the server computer, and you must be in the bulkadmin or the sysadmin role on SQL Server. You also need to be in the db_owner role for the SQL Server database. To learn how to set up these roles, read the Useful SQL commands topic.

  3. Open the Start screen or the Start menu: Press the Windows key.
  4. Type memoQ, and wait for the results to appear. In the list, click memoQ Server Deployment Administration.
  5. Windows may ask you to confirm to run the program. Click Yes or Run.
  6. The memoQ Server Deployment Administration window opens.

  7. In the memoQ TMS section, click Restore from backup. The Restore memoQ TMS from a backup wizard will start.

    deptool-restore-mqs

  8. Next to the Restore package box, click the ellipsis ellipsis_button button. An Open window appears. Find the backup package, click it, and click Open.
  9. You can specify a log file where the restore program keeps record of the events during the restore. This is optional, but highly recommended. Next to the Log file box, click the ellipsis ellipsis_button button. A Save As window opens. Choose a folder and a name for the log file, and click Save. The log file will be a plain text (.txt) file.
  10. Leave everything as it is, and click Restore. The restore of the database and the settings begins.