Today I have been requested to move an old database Sqlserver 2000 to a Sqlserver 2012. When I executed the restore I got the next error;
TITLE: Microsoft SQL Server Management Studio
Restore of database ‘HERCULES40’ failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)
System.Data.SqlClient.SqlError: The database was backed up on a server running version 8.00.0760. 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. (Microsoft.SqlServer.SmoExtended)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.2100.60+((SQL11_RTM).120210-1917+)&LinkId=20476
In this case I forgot to check the compatible matrix for backp and restores between version, of course, is my fault. Okay possible solutions;
i) Upgrade fro 2000 to 2012, through the versions like 2008.
ii) Jump, restore this backup in a 2008 and generate a new backup and restore it in 2012.
In my case, option ii was choosed.
HTH – Antonio NAVARRO