Dr KNX: Opening the ETS4 Database

Dr KNXBy Dr KNX.

Dear Dr KNX, I'm using another computer and can no longer open my ETS4 database. Can you advise?

Dear Dr KNX, I’m using another computer and can no longer open my ETS4 database. Can you advise?

Dear KNXer,

KNX Association chose the Microsoft SQL Server as the database engine for ETS4 because this meant that they did not need to develop a proprietary database engine from scratch. There are, however, some consequences of this approach, such as not being able to just move ETS4 database files, not even on the same computer! In such cases, you need to create a backup first and then restore this backup file from the new location.

In the images below you can see where in ETS4 you can deal with databases and backups, and for more detail, consult the ETS4 help module.

KNX database 1

KNX database 2

Backups

It is a common recommendation to make backups of any data regularly, so this certainly also counts for ETS databases (projects). Moreover, it is also worth making backup restore checks for ETS4 regularly, because even the ETS4 backup files could get corrupted somehow (due to no fault of its own).

In other words, as any professional working with data within an IT environment, you need a systematic approach to backing up in order to prevent loss of data and hence loss of time and money. It might take a little extra time, but it is your insurance and could save you a big headache in the long-run. As they say, it’s better to be safe than sorry.

I hope that helps, but if you have any questions about this, or any other technical issue, please use the ‘Leave a reply’ option below this article, or send me an email at info@knxtoday.com, and I will do my best to answer you.

Yours truly
Dr KNX

You are welcome to comment on this article. See below.



Comments

Dr KNX: Opening the ETS4 Database — 2 Comments

  1. Hi, can you please advice what to do if you get this pop up”Open Database (C:\SVN\1235 – Heathrow T2B Phase 2\Data\ETS4 Databases\P109.mdf) failed. The Server did not respond in time” when you trying to open databases? It is obviously to late to do backup is in it? I had this on my old laptop from one day to another and because my laptop was due to replace I got my new one now and I was thinking that installing all again will solve that problem but it didn’t. looking forward to hear back from you.

    Regards Jacek.

  2. Hi Jacek

    It looks like a problem with the SQL Server. However, without seeing the log file, it is hard to say what it is. We suggest that you open a support ticket or upgrade to ETS5.

Leave a reply (comments are moderated)