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

avatar image

Sarit
11 1 1 3

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

avatar image

John Sansom
897 2 4

(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

avatar image

Alvin Ramard
1.4k 2 5

(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

avatar image

Peso
1.6k 5 6 9

(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

avatar image

Brian
66 4 5 9

(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

avatar 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.

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:

x2072
x501
x235
x122

asked: Nov 04, 2009 at 01:18 AM

Seen: 13666 times

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

Copyright 2016 Redgate Software. Privacy Policy