Unable to Restore SQL Server 2000 Database Backup to SQL Server 2012 Instance
Although SQL Server 2000 is out of support, still there are some legacy applications still using SQL Server 2000. As there are many latest versions of SQL Server available in the market including SQL Server 2012 and SQL Server 2014 being the latest.
User may think that they can migrate directly from SQL Server 2000 to either SQL Server 2012 or SQL Server 2014, but it is not possible. We cannot even restore a database backup performed on SQL Server 2000 on to an instance running SQL Server 2012 or SQL Server 2014.
Below is the error which you will receive if you try to restore SQL Server 2000 backup file to SQL Server 2012.
Restore of database ‘DBName’ failed . (miscrosoft.sqlserver.management.relationalenginetasks)
The database was backed up on a server running version 8.00.0194. That version is incompatible with this server, which is running version 11.00.2100.
So, in order to resolve this issue, you will first need to restore this database on SQL Server 2005 or SQL Server 2008 R2 SQL Server instance and then perform backup of this database from the new instance and restore it on the SQL Server 2014 instance.
This error “The database was backed up on a server running version **.**.****” can also occur if you are trying to restore a database which was backed up on hither version and then trying to restore on the lower version of SQL Server instance. Example, this error can also occur if you try to restore a database which was backed up on SQL Server 2008 R2 and then you try to restore it on SQL Server 2008(non R2) instance.
This is applicable on below versions of SQL Server
SQL Server 2000
SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014
Hope this was helpful.
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.