Schedule memoQ TMS backup

From the Deployment tool, you can make a full backup of memoQ TMS. You can do it manually, or you can schedule the backups, so that memoQ TMS is backed up automatically and regularly.

This topic is about scheduling regular backups.

To learn how to back up memoQ TMS manually, see the Back up memoQ TMS topic.

SQL server on different machine or installed separately? If SQL Server was not installed by the Deployment tool itself, make sure that the user backing up memoQ TMS has the bulkadmin or sysadmin server-level role on the SQL Server. To check and set this up, you need the sqlcmd program. To learn about the actual commands, read the Useful SQL commands topic.

Always take note of the version because you will need it when you restore the package: When you make a backup, always note down the version of the memoQ TMS (for example, 11.1 - you don't need the build number). When you open the Deployment tool, the memoQ TMS section will show the version of the memoQ TMS that is running - and not the version of the Deployment tool. Include the version number (for example, 11.1) in the name of the folder where you store the backup packages.

How to get here

When you do this, memoQ TMS will already be installed on the server computer.

  1. Log in to the memoQ TMS computer through Remote Desktop.

  2. Open the Start screen or the Start menu: Press the Windows key.

  3. Type memoQ, and wait for the results to appear.

  4. In the list, click memoQ TMS deployment tool.

  5. Windows may ask you to confirm to run the program. Click Yes or Run.

  6. The memoQ TMS deployment tool window opens. You need the topmost section (memoQ TMS):

    memoQ TMS already installed window with advanced options selection

  1. Click Advanced:

    deptool-mqs-advanced-menu

  2. From the menu, choose Schedule backup. The Schedule memoQ TMS backup window opens:

    deptool-schedule-backup

What can you do?

  1. Click the Schedule automatic and regular backups radio button.
  2. Choose when and how often memoQ TMS must create the backup. In the First time box, set the first time when a backup is saved. Choose a date and a time for this. Then, choose how often the backup should happen.
    • To have a backup every day or every few days, click the Daily radio button, and set the number of days in the Frequency (days) box.
    • To have a backup every week or every few weeks, click the Weekly radio button, and set the number of weeks in the Frequency (weeks) box. In the dropdown below Frequency, choose which days of the week the backup should be made. You can choose one or several days.
    • To have a backup every month or every few months, click the Monthly radio button. To set which day(s) of the month the backup should happen: Select those days in the in the Recur on (day of month) dropdown.
  3. Choose a folder where the backup will be saved. It can be on the memoQ TMS computer or on another computer. In any case, the user in whose name the backup is made needs access to that folder. You also need to decide about this:
    • Should memoQ TMS overwrite the last backup? If it should, click Overwrite the backup file every time.
    • Or, should memoQ add a date to the backup file, and keep the earlier ones? If it should, click Keep every backup file (with its date in the file name).

      Create a folder that contains the version number of memoQ TMS: You will need the exact same version to restore the backup package. For example, if you make the backup from memoQ TMS 11.1, you will need the deployment tool for memoQ TMS 11.1 to restore that backup. (The build number - the third one - does not have to be the same.) However, the backup package does not indicate the version number. It is useful to create a folder that contains the version number, for example: mQs-11-1-backups.

      Caution: If you keep earlier backups, you will need much more disk space for the backups.

  4. If you need an e-mail when a backup is made: Check the Send email notification about the backup to the following addresses check box, and enter the e-mail addresses in the box below the check box. Separate the addresses with semicolons (;).

    E-mailing must be set up: memoQ TMS uses the same e-mail settings for all notifications. You will receive e-mails about backups if e-mailing is set up on the server. To do that, open the Configure server window, and click the E-mail tab. Or, in the Schedule memoQ TMS backup window, click Configure the memoQ TMS's e-mail SMTP settings. That will open the Configure e-mail SMTP options window, which has the same settings. To learn more, see the Configure server topic.

  5. Choose a user account in whose name memoQ TMS will do the backup. In the Account name box, enter the user name - with a domain name if necessary. In the Password box, enter the password for that user.

User must be an  administrator: The user needs to have administrator's privileges on Windows. The user must also have access to the %PROGRAMFILES% folder, the memoQ TMS data and AppData folders, as well as the SQL server database. The user must have permission to create a database backup and to write in the target folder.

When you finish

Click OK. The Deployment tool schedules a task in Windows to run the backup.

It is the deployment tool that makes the backup. Because this tool can run in one single instance only, other users cannot run it while the backup is running.

The result of the backup is logged in the Windows event logs. The Deployment tool logs the following events:

  • A backup has completed successfully (information)
  • A backup has failed (error)
  • Failure to send e-mail notification (warning).

    To view the Windows event logs, use the Event Viewer program.

    To remove the backup task: Use the Task Scheduler program in Windows.