SQLSERVER 2012从2000还原失败：Restore of database failed

一次系统迁移，需要将 SQLSERVER 2000 DB备份 还原到 SQLSERVER 2012，对SQL2000 DB backup后在SQL2012 SSMS中 resotre时失败了并报错：

TITLE: Microsoft SQL Server Management Studio
------------------------------

Restore of database 'eVMI' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)

------------------------------
ADDITIONAL INFORMATION:

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.7001. 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.7001.0+((SQL11_PCU_Main).170815-1011+)&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

官方BLOG说明SQL 2000迁移2012方法 ：
https://blogs.technet.microsoft.com/mdegre/2012/06/15/migration-sql-server-2000-to-sql-server-2012/

https://blogs.technet.microsoft.com/mdegre/2009/07/21/migration-sql-server-2000-to-sql-server-2008/

You will have to make the migration in two steps:

- Step 1: Make a first migration from SQL 2000 to SQL 2008 for instance. You need to be SQL 2000 SP4, then follow this step : Migration SQL Server 2000 to SQL Server 2008
 
- Step 2: Make a second migration from SQL Server 2008 to 2012.

Restoring a database SQL server 2000

On your new instance Microsoft SQL Server 2008, connect to Management Studio 2008. Then click on the "Restore Database". Then follow the instructions.   --原来可以从 2000 backup后到2008 restore 后，再对 2008 backup后到2012 restore

按此方法，利用SQL 2008作为中转，测试成功

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25583515/viewspace-2157205/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25583515/viewspace-2157205/