Issue
When restoring database, an error will show up, saying that version is incompatible with this server.
Product Line
EcoStruxure Building Operation, TAC INET
Environment
I/NET
Cause
This is usually caused by restoring new SQL database to older version or under different kind of Operation Systems (like restoring a 64 bit database to a 32bit SQL server). Microsoft doesn't like to do this.
Resolution
There is build number matrix for each SQL server version:
| RTM (Gold, no SP) | SP1 | SP2 | SP3 | SP4 | |
| SQL Server 2012 | 11.00.2100.60 | 11.00.3000 | |||
| SQL Server 2008 R2 | 10.50.1600.1 | 10.50.2500 | 10.50.4000 | ||
| SQL Server 2008 | 10.00.1600.22 | 10.00.2531 | 10.00.4000 | 10.00.5500 | |
| SQL Server 2005 | 9.00.1399.06 | 9.00.2047 | 9.00.3042 | 9.00.4035 | 9.00.5000 |
So check the build number in the error message and download the corresponding version of SQL to restore and be used for I/NET.
Refer to How to Troubleshoot on DBCreate for more issues about DBCreate.
