Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question

migrated from stackoverflow.com Nov 22 '12 at 17:01

This question came from our site for professional and enthusiast programmers.

3  
Is the error not self-explanatory? –  ChrisBint Nov 22 '12 at 11:00
2  
Is it possible you selected the wrong backup file to restore? Clearly the backup was not taken on 2008. –  Jon Seigel Nov 22 '12 at 18:10
add comment

2 Answers

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.

share|improve this answer
    
@JonSeigel: Thanks! I was looking for that article, but couldn't find it right then... –  marc_s Nov 22 '12 at 18:23
add comment

Checkout these below mansion reference would be help to you.

http://codeonaboat.wordpress.com/2012/02/16/sql-server-2008-creating-a-database-from-a-bak-file/

http://kb.eukhost.com/backup-and-restore-ms-sql-server-2008-database/

http://stackoverflow.com/questions/10637958/how-do-i-import-a-bak-file-into-microsoft-sql-server-2012

Thanks

share|improve this answer
    
Could you add a bit of explanation? Link-only answers are discouraged by the site's standards written in the FAQ. –  dezso Nov 27 '12 at 10:51
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.