FIX – Cannot Restore SQL Server 2000 Backup on SQL Server 2012

Posted on : 10-05-2012 | By : Devi Prasad | In : SQL Errors, SQL Server 2000, SQL Server 2008 R2, SQL Server 2012, SQLServerPedia Syndication

Share:

2


Unable to Restore SQL Server 2000 Backup on SQL Server 2012?

If you are trying to restore SQL Server 2000 backup on SQL Server 2008 you would be facing error like:


Msg 3169, Level 16, State 1, Line 1

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.2100. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.

Restoring SQL Server 2000 backup to SQL Server 2012 is not supported.

Why?
According to MSDN 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.

How to restore then?
Fix/resolution:
Use SQL Server 2008 R2 as an intermediate source.

Steps:
1. First restore the SQL Server 2000 backup to SQL Server 2008 r2.
2. Then backup the database from SQL Server 2008 r2 and restore it on SQL Server 2012.

If you do not have SQL Server 2008 r2, You can download a trial version of SQL Server 2008 r2 from the below links.
http://msdn.microsoft.com/en-us/evalcenter/ff459612
http://www.microsoft.com/sqlserver/en/us/editions/previous-versions.aspx

Alternatively you can use SQL Server 2005 (or) SQL Server 2008 also as an intermediate source.

Following the above steps should help solve the problem.

Also verify the database backup on each target server before restoring: Verify SQL Server Database Backup

(Visited 455 times, 1 visits today)



References : Devi Prasad (sqlserverlearner.com)

Need Help On SQL Server?

Cannot Find Solution to your problem (or) If you are looking for some help on SQL Server. Dont worry Click Here to Post your question and solve your issue.


Do you like my blog?

If you liked reading this blog, please help spread the word by sharing this blog with your friends.




Comments (2)

[…] It is not possible to restore a SQL 2000 backup into SQL 2012. The solution is install an intermediate SQL instance (2005,2008,2008 R2), restore to that instance, then detach and attach into the SQL 2012 instance. For smaller databases, I was able connect to the SQL 2000 database from my SQL 2012 instance and use ‘Generate Scripts…’ in the context menu to script the objects and data. […]

Good suggestion friend, I am involved in a migration project now where I need to restore SQL Server 2000 data to SQL Server 2012

Write a comment