Esko Logo Back to Esko Support
Choose your language for a machine translation:
Skip to end of metadata
Go to start of metadata

 

Summary

When trying to restore a backup of the SQL databases (BSJobs, Fastlane, Fastlane_TM) from an earlier version of SQL (SQL 2000 or SQL 2005 (version 8)) into SQL 2012 (version 11), the databases could not be restored due to version incompatibility.

Symptoms

SQL databases will not restore. Error message mentions that the database versions are not compatible. A version 8 database will not restore in a SQL version 11.

Database BSJobs could not be created.
com.microsoft.sqlserver.jdbc.SQLServerException: The database was backed up on a server running version 8.00.2039. That version is incompatible with this server, which is running version 12.00.4100. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.

Solution

  1. The old database needs to be compatible with the latest version possible. In the SQL Server Management Studio Express, Log into SQL instance using "sa" as the user name.
  2.   Browse to the BSJobs database, right-click and select Properties.
      
  3. Go to Options.
  4. Change the Compatibility level: to the highest level available. Save the changes and make a backup on this database. The database will need to be restored in the version specified in the Compatibility level, changed to the highest level again, saved and a new backup made. This new backup should be restored in the SQL 2012 version.

If your old database was MSDE of SQL Server 2000, it is technically not possible to restore the old database to SQL 2012. This is a limitation set by Microsoft (see: http://blogs.technet.com/b/mdegre/archive/2012/06/15/migration-sql-server-2000-to-sql-server-2012.aspx).

You first need to restore this database onto a SQL 2005 or 2008 Server, then set the highest compatible level, then make a backup again. This new backup can then be restored on SQL Server 2012 or 2014.

Different SQL versions

SQL Server 2000

Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

SQL Server 2005

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

SQL Server 2008

Microsoft SQL Server 2008 (SP1) - 10.0.2573.0 (X64)
Feb 4 2011 11:27:06
Copyright (c) 1988-2008 Microsoft Corporation
Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

Article information
Applies to

Automation Engine

Created25-Aug-14
Last revised14-Apr-16
AuthorWIWO
CW Number 
Contents