Solved

SQL Restore Problem

Posted on 2009-07-16
10
1,464 Views
Last Modified: 2013-12-24
I create backups of an SQL database from a Windows Server 2008 using MS SQL 2008. I can restore the backup from another server that jas Windows Server 2003 and SQL Server 2008. The problem I am having is when I try to restore the same backup (that restores correctly on these 2 servers) to a remote server that uses Server 2003 and SQL 2005. For months now I have been restoring the daily backups to this remote server (either by copying via the network), from a backup tape, or from an external hard drive and then using the GUI to restore from the backup. About a week ago, I stopped being able to restore the same backup on the remote server that I can restore on the other 2 servers. The error I am getting is "The DRbackups\Procuranightlybackup.bak is incorrectly formed. SQL Server cannot process this media family. RESTORE HEADER ONLY is terminating abnormally - MS SQL Server Error 3241)

I have tried running the backup using scripts, using the RESTOREHEADERONLY and every other suggestted way to run it that I found from previous questions from your website, from Microsoft's. The backup is NOT corrupt because I can restore the same backup on two other servers and have tried each day with different backups and still get the same error on this remote server. Please help!
0
Comment
Question by:tt0wnsend
  • 3
  • 2
  • 2
  • +1
10 Comments
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24877103
>> The problem I am having is when I try to restore the same backup (that restores correctly on these 2 servers) to a remote server that uses Server 2003 and SQL 2005.

You wont be able to restore a backup taken from SQL Server 2008 machine to a machine running SQL Server 2005.
Backward compatibility is supported whereas Forward compatibility is not supported.

What I am saying is 100% correct as you have received the error message as "The error I am getting is "The DRbackups\Procuranightlybackup.bak is incorrectly formed. SQL Server cannot process this media family. RESTORE HEADER ONLY is terminating abnormally - MS SQL Server Error 3241)"

>> SQL Server cannot process this media family

SQL server 2005 will not be able to process media family or backups taken from SQL Server 2008.

Hope this helps
0
 
LVL 68

Expert Comment

by:Qlemo
ID: 24877125
Any chance that service packs are different on those machines?
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24877131
Qlemo,
     Its not a problem with Service packs..
Its the problem with the versions of SQL Server.

You can restore a backup taken from SQL Server 2005 to 2008 but you can't do the reverse case.
If you try to do it, then you will receive the error message exactly what is posted above.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24877193
>> I can restore the backup from another server that jas Windows Server 2003 and SQL Server 2008.

And this confirms it too.
0
Want to promote your upcoming event?

Attending an event? Speaking at a conference? Or exhibiting at a trade show? Easily inform your contacts by using a promotional banner in your email signature. This will ensure your organization’s most important contacts are in the know.

 
LVL 46

Expert Comment

by:Vitor Montalvão
ID: 24877202
tt0wnsend, you are trying to restore a SQL Server 2008 database in SQL Server 2005 instance.
SQL Server 2005 came before SQL Server 2008 so I think won't be possible to restore there the database backup you have.
Anyway check if the database backup isn't compressed because SQL Server 2005 doesn't work with compressed backups.

Good luck
0
 
LVL 68

Expert Comment

by:Qlemo
ID: 24877233
I was confused by
"For months now I have been restoring the daily backups to this remote server (either by copying via the network), from a backup tape, or from an external hard drive and then using the GUI to restore from the backup."
and all the Windows and MSSQL versions ...

This should never have worked, for the reasons already stated (no version downgrade).

0
 
LVL 46

Expert Comment

by:Vitor Montalvão
ID: 24877412
I remembered something now. If compatibility level of that database was set to 9.0 (2005) then backup & restore could work fine during all that time. So maybe compabilitiy level now change to 10.0 (2008) and stopped working.

Can't find another logical explanation.
0
 
LVL 1

Accepted Solution

by:
idumlupinar earned 500 total points
ID: 24877455
Ihttp://www.devx.com/dbzone/Article/40531
http://stackoverflow.com/questions/545316/is-it-possible-to-restore-sql-server-2008-backup-in-sql-server-2005

By default you won't be able to restore SQL Server 2008 backup to SQL Server 2005, however the tutorials above might help.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Know what services you can and cannot, should and should not combine on your server.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
The purpose of this video is to demonstrate how to reset a WordPress password if you are locked out and cannot reset the password. A typical use would be if you cannot access the email to which WordPress would send the password recovery email to…
The purpose of this video is to demonstrate how to Test the speed of a WordPress Website. Site Speed is an important metric of a site’s health. Slow site speed can result in viewers leaving your site quickly and not seeing your content. This…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now