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

来源：这里教程网时间：2026-03-02 11:18:29 作者：

一次系统迁移，需要将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作为中转，测试成功