x

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)

more ▼

asked Nov 04, 2009 at 01:18 AM in Default

Sarit gravatar image

Sarit
11 1 1 1

Would it be possible to post your T-SQL restore script for clarification. If you are using the SQL Server Management Studio GUI, just script out the process.
Nov 04, 2009 at 06:38 AM John Sansom
(comments are locked)
10|1200 characters needed characters left

8 answers: sort voted first

I have seen this error on a number of occassions and often it is becuase the backup file you are attempting to restore is corrupt.

Ideally you should look to source an alternative backup of the database in question.

more ▼

answered Nov 04, 2009 at 06:37 AM

John Sansom gravatar image

John Sansom
897 2

(comments are locked)
10|1200 characters needed characters left

I would try to restore the backup onto a SQL 2000 server. That should help you figure out whether or not the backup is corrupted.

more ▼

answered Nov 04, 2009 at 04:17 PM

Alvin Ramard gravatar image

Alvin Ramard
207 2

(comments are locked)
10|1200 characters needed characters left

You can try out Idera's new SQL Virtual Database here http://www.idera.com/Products/SQL-Toolbox/SQL-virtual-database/

to extract your data and transfer them to a SQL Server 2008 database.

more ▼

answered Nov 04, 2009 at 04:35 AM

Peso gravatar image

Peso
1.6k 5 6 8

(comments are locked)
10|1200 characters needed characters left

That sounds like the error you get when trying to restore a backup created Via Litespeed not SQL. Are you sure that the backup file was created by SQL and not 3rd party Backup software?

more ▼

answered Nov 04, 2009 at 01:32 AM

Brian gravatar image

Brian
36 4 4 6

I am the one who 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".
Nov 04, 2009 at 01:44 AM Sarit
(comments are locked)
10|1200 characters needed characters left

I successfully restored several SQL 2000 backups on SQL 2008 servers. Like said by other contributors, I suspect your bak file is corrupted or has been done using a 3rd party tool. Did you check if RESTORE VERIFYONLY works?

more ▼

answered Nov 05, 2009 at 12:15 PM

elian gravatar image

elian
1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1842
x476
x193
x102

asked: Nov 04, 2009 at 01:18 AM

Seen: 12161 times

Last Updated: Apr 03, 2013 at 09:31 AM