Knowledge Base
cancel
Showing results for 
Search instead for 
Did you mean: 

Incompatible SQL Server Version error when Restoring I/NET Database in DBCreate

Issue

When restoring database, an error will show up, saying that version is incompatible with this server.

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 Lessons Learned Article LL#15834 for more issues about DBCreate.

Tags (1)
Version history
Revision #:
1 of 1
Last update:
2 weeks ago
Updated by: