Can’t restore SQL Server 2000 backup to SQL Server 2008
I have a backup file taken from a SQL Server 2000 database and I'm trying to restore it to a 2008 database. However, I'm getting this error:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) The media family on device 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\customers.bak' is incorrectly formed. SQL Server cannot process this media family. RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)
I am the one who originally took the b开发者_运维百科ackup (years ago). It was a hosted SQL Server. If I remember correctly, I got the backup using some sort of online "control panel"
SQL 2000 SP4 database can be upgraded on-the-fly to SQL 2008 (including restore-upgrade). See Version and Edition Upgrades. If you get that message most likely the media is corrupted.
In SQL Server 2008, follow these steps
- Create New database with the same name as in SQL Server 2000
- After writing database name, go to Options tab
- In Compatibility Level dropdown select 'SQL Server 2000 (80)
- After creating database, go to Task and select restore
- After selecting restore resource go to options tab and select 'Overwrite the existing database (With Replace)
- Your database will be restored
精彩评论