Error on SQL Server 2000 backup (.bak file) restored on SQL Server 2012 When I try to restore a database in my new SQL Server 2012 instance I get this error :


  Restore of database 'MyDb' failed.
  (Microsoft.SqlServer.Management.RelationalEngineTasks)
  
  System.Data.SqlClient.SqlError: The database was backed up on a server running version 8.00.2055. That version is incompatible with this server, which is running version 11.00.2218. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.SmoExtended)


Can you help me?
The database is a SQL Server 2000 database (version 8.00.2055) - and you cannot directly update a SQL Server 2000 database to SQL Server 2012.

You'll need to take an interim step first (restore it in SQL Server 2008, back it up from that server again).

See the relevant MSDN documentation:


  In SQL Server 2012, you can restore a user database from a database backup that was created by using SQL Server 2005 or a later version.


but SQL Server 2000 is NOT supported.