1.Log in to the memoQ server 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 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.
4.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 subscription 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.
4.Next to the Restore package box, click the ellipsis button. An Open window appears. Find the backup package, click it, and click Open.
5.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.
6.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.
7.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.
8.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 subscription 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.