[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 Restore failed Microsoft.SqlServer.Management.RelationalEngineTasks
 

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
Tips
Troubleshooting
Tuning

Restore failed Microsoft.SqlServer.Management.RelationalEngineTasks.


Applies to: SQL Server 2008 R2 Enterprise Edition, SQL Server 7.0.

 

Problem Description.
 

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)
Additional information:
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)




Cause


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.


Solution
 

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.



 

 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.