Restore from backup
It is highly recommended that you make regular backup copies of all data under memoQ server.
You need the backup - usually the latest one - if you lose memoQ server to a malfunction, or when you need to transfer memoQ server to a different computer.
You can restore a backup copy in the Deployment tool: In the memoQ server section, just click Restore from backup. But it is not as simple as this.
When you restore a backup copy, it will restore memoQ server to the exact same point in time when the backup was made. You would not do this if memoQ server were working perfectly.
You must restore data on the same version: For example, if you back up data form memoQ server 8.0 (any build), you need to restore them on memoQ server 8.0.
Don't make changes unless you have experience operating computer networks and Microsoft SQL Server, and everything written here is clear to you.
- Log in to the memoQ server computer through Remote Desktop.
- Make sure you have your backup file at hand - on the server computer, not on your own.
- Download memoQ server, 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 https://www.memoq.com/en/downloads web page. Click the memoQ server tab, and scroll down to Previous versions. 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.
- In the memoQ server section, click Restore from backup. The Restore memoQ server from a backup wizard will also install memoQ server, 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 server. For example, if the "old" memoQ server 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 cloud to your own server? You will need SQL Server 2012 Express or higher. To get your backup, open the My Account page for your memoQ cloud subscription on the memoQ.com website, and download your backup package.
- Next to the Restore package box, click the ellipsis button. An Open window appears. Find the backup package, click it, and click Open.
- 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 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.
- 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 server topic.
- 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 server. 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.
- 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 cloud to your own server - and if the memoQ server 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 server, 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 server backup topic.
- Log in to the memoQ server computer through Remote Desktop.
- 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.
- Open the Start screen or the Start menu: Press the Windows key.
- Type memoQ, and wait for the results to appear. In the list, click memoQ Server Deployment Administration.
- Windows may ask you to confirm to run the program. Click Yes or Run.
- The Deployment window opens. In the memoQ server section, click Restore from backup. The Restore memoQ server from a backup wizard will start.
- Next to the Restore package box, click the ellipsis button. An Open window appears. Find the backup package, click it, and click Open.
- 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 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.
- Leave everything as it is, and click Restore. The restore of the database and the settings begins.