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.
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
- Open imos iX and go to imos iX options. Write down the server name, the database name and the database login details.
- Install SSMS if it is not yet on the server or PC. It is a free download from Microsoft.
- Choose a backup folder the SQL server itself can reach, for example
D:\Backup\imoson the server. - Ask all designers to save their drawings and close imos.
Creating a backup
- Start SSMS, enter the server name and login details from imos iX options and click Connect.
- Expand Databases and right-click the imos database, for example
IMOS_DEMO. - Choose Tasks › Back Up….
- Set Backup type to Full and Back up to to Disk.
- Remove any existing destination with Remove and choose Add….
- Enter a recognisable file name including the date, for example
D:\Backup\imos\IMOS_DEMO_2026-10-26.bak, and click OK.
- Click OK again to start the backup and wait for the message that it completed successfully.
- Check the folder to confirm the .bak file is there and has a realistic size.
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
- Make sure everyone has closed imos. There must be no open connections to the database.
- Log in to SSMS on the server where the database needs to be restored.
- 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….
- Under Source, select Device, click the button with the dots and add the .bak file. Opening the folder can take a few seconds.
- Under Destination, check the database name: it must match the name in imos iX options.
- Open Options and tick Overwrite the existing database (WITH REPLACE) and Close existing connections to destination database.
- Check one last time that you are overwriting the right database, then click OK.
- Start imos iX and open a familiar order to confirm the data is correct.
Restoring overwrites everything. Any changes made after the backup was created will be lost. Always make a fresh backup of the current database before restoring an older one.
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.
Common mistakes
- Backing up to a mapped network drive letter. SQL Server runs under its own service account and cannot see your drive mappings. Use a folder on the server itself, or a full network path where the SQL service has write permissions.
- Going from a newer to an older SQL Server. A backup from a newer SQL Server version cannot be restored on an older version. The other way round works.
- Selecting the wrong database. A server often hosts several databases. Always check the name in imos iX options.
- Keeping the backup on the same disk as the database. If that disk fails, you lose both. Copy the .bak file to another location as well.
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
- How do I schedule a daily automatic backup of imos iX?
- How do I move imos iX to a new server?
- How do I install imos iX 2025 and what should I check?
- imos iX is slow: what can I check?
- imos iX support
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.