memoQ server

If you are using a server solution, it is also advisable to regularly back up the SQL database that contains information about the users, groups, permissions and projects. By default, it is found in the following folder, which also contains the project folder and some configuration files that you may also want to back up:

  • C:\Documents and Settings\All Users\Application Data\memoQ Server
    (In Windows Vista: C:\ProgramData\memoQ Server)

The SQL database file and the transaction log are stored under the names memoQServer.mdf and memoQServer_log.ldf. Both are needed for a successful backup and restore. During the server installation you might have changed the path where the server database is stored. If you did change it, make sure that you back up the new path as well. The folder where server project documents are stored can also be changed from the Server Administrator, so if you are not using the default folder, back up the actual project folder as well.

Before the backup or restore operation, you will need to stop the memoQ Server service and the service of the SQL Server instance pertaining to the memoQ Server (in that order). Failure to do so may stop you from successfully finishing the operation, or might even leave the server in an unworkable state. After the backup or restore operation, start the SQL instance service and the memoQ Server service (in that order) again.

Never try to restore a database backup if you have upgraded your server to a newer version since the backup was taken. The database schema often gets modified between versions, and a database created by an older version might not work with the current version of the server. If you need to restore a database that was created in an older version of memoQ Server, you first need to uninstall you current version of memoQ Server, and install the version the database was created in. After this, you can restore the backup of the database, and install the current version. The installer will upgrade the restored database to the current version.