HOW TO RESTORE SQL SERVER 2000 BACKUP TO SQL SERVER 2008

Pooja Malohtra

Total Post:47

Points:331
Posted by  Pooja Malohtra
 730  View(s)
Ratings:
Rate this:
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 backup (years ago). It was a hosted SQL Server. If I remember correctly, I got the backup using some sort of online "control panel"
  1. Mayank Tripathi

    Post:397

    Points:3117
    Re: How to restore SQL Server 2000 backup to SQL Server 2008

    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.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!