Skip to content
Knowledge base

How do I back up and restore the imos iX database?

Step-by-step guide to backing up and restoring the imos iX database with SQL Server Management Studio, including checks and common mistakes.

Short answer: imos iX stores all master data and orders in a single Microsoft SQL Server database. You create a backup in SQL Server Management Studio (SSMS) via Tasks › Back Up to a .bak file, and restore it via Tasks › Restore › Database. Make sure everyone has closed imos first, and always double-check that you have selected the right database.

Information

Applies to

  • imos iX 2019 and later, with the database on Microsoft SQL Server
  • All modules (CAD, CAM iX, Organizer): they share the same database
  • Tool: SQL Server Management Studio (SSMS)
  • Last reviewed: November 2026

Preparation

  1. Open imos iX and go to imos iX options. Write down the server name, the database name and the database login details.
iX options shows the server and database name.
  1. Install SSMS if it is not yet on the server or PC. It is a free download from Microsoft.
  2. Choose a backup folder the SQL server itself can reach, for example D:\Backup\imos on the server.
  3. Ask all designers to save their drawings and close imos.

Creating a backup

  1. Start SSMS, enter the server name and login details from imos iX options and click Connect.
Logging in to Management Studio with the details from iX options.
  1. Expand Databases and right-click the imos database, for example IMOS_DEMO.
  2. Choose Tasks › Back Up….
Right-click the database, Tasks, Back Up.
  1. Set Backup type to Full and Back up to to Disk.
  2. Remove any existing destination with Remove and choose Add….
Choose Disk as the destination and add a file with Add.
  1. Enter a recognisable file name including the date, for example D:\Backup\imos\IMOS_DEMO_2026-10-26.bak, and click OK.
A recognisable file name with a date.
  1. Click OK again to start the backup and wait for the message that it completed successfully.
  2. Check the folder to confirm the .bak file is there and has a realistic size.
Tip

A typical imos database produces a .bak file of a few hundred MB up to a few GB. Is the file suspiciously small, or missing? Check the folder and write permissions before you continue.

Restoring a backup

  1. Make sure everyone has closed imos. There must be no open connections to the database.
  2. Log in to SSMS on the server where the database needs to be restored.
  3. Right-click the database you want to replace and choose Tasks › Restore › Database…. If the database does not exist yet, right-click Databases and choose Restore Database….
Restoring via Tasks, Restore, Database.
  1. Under Source, select Device, click the button with the dots and add the .bak file. Opening the folder can take a few seconds.
  2. Under Destination, check the database name: it must match the name in imos iX options.
Always check the database name under Destination.
  1. Open Options and tick Overwrite the existing database (WITH REPLACE) and Close existing connections to destination database.
Enable overwriting on the Options page.
  1. Check one last time that you are overwriting the right database, then click OK.
  2. Start imos iX and open a familiar order to confirm the data is correct.

Why this approach?

imos iX is more than a drawing program. Materials, edge banding, articles, machining principles and orders all live in one SQL database. A copy of the program folder or of individual drawings is therefore not a backup. Only a database backup contains everything you need to keep working.

We ask everyone to close imos because changes saved during the backup do not end up in the file. During a restore, it prevents an open connection from blocking the process, or someone working in a half-restored database.

A date in the file name looks like a detail. In practice, it is exactly what you need when you want to restore the right version quickly after a mistake.

Frequently asked questions

Can I schedule the backup automatically?

Yes. With SQL Server Agent (not available in the free Express edition) or with Windows Task Scheduler and a small script, you can create a daily backup automatically. See the step-by-step guide with script in How do I schedule a daily automatic backup of imos iX? Do agree on who checks that those backups actually succeed.

How often should I make a backup?

At least daily if drawings are made every day. In addition, always make a backup before an imos iX update, a database import or a server migration.

Can I use a backup to move the database to another server or PC?

Yes. Restore the .bak file on the new SQL Server and then update the connection in imos iX options. A full server migration involves extra steps, such as network shares and firewall ports. See How do I move imos iX to a new server?

Do I need to back up anything besides the database?

Yes. The imos folder on the server with drawings, templates, CNC settings and configuration files is not stored in the database. Include that folder in your regular file backup.

Further reading

More than one solution

Almost every question in this knowledge base has more than one solution. The best fit depends on your workflow, machinery and integrations. Not sure which applies to you, or are you using software we don't (yet) support? Feel free to email Wood Intelligence. We're happy to think along with any challenge.

imos is a trademark of imos AG. Wood Intelligence is an independent consultancy.

Download access

Sign in to check whether this download is available.