Restore failed Microsoft.SqlServer.Management.RelationalEngineTasks.
Applies to: SQL Server 2008 R2 Enterprise Edition, SQL Server 7.0.
I was trying to restore a backup from a SQL Server 7.0 instance into a SQL
Server 2008 R2 instance when I received the following error:
Microsoft SQL Server Management Studio.
Restore of database [databasename] failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)
System.Data.SqlClient.SqlError: The database was backed up on a server running
version 7.00.0623. That version is incompatible with this server, which is
running version10.50.2500. Either restore the database on a server that supports
the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.SmoExtended)
SQL Server 2008 R2 does not support upgrading a database from SQL Server 7.0.
When a backup created on earlier versions of SQL Server is restored on a newer
version of SQL Server, the database is automatically upgraded to the new version. In
this scenario the restore was not possible due to compatibility issues.
The solution was restoring the database into a SQL Server 2005 instance, I
changed the compatibility level of the database to 80, then
detached the database from the SQL Server 2005 instance and attach it to the
SQL Server 2008 R2 instance.