SQLSERVER 2012從2000還原失敗：Restore of database failed

guocun09發表於2018-07-02
SQLServerRESTDatabaseAI
一次系統遷移，需要將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: ((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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章