Solved

SQL Restore Problem

Posted on 2009-07-16
10
1,478 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 70

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
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 
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
 
LVL 50

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 70

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 50

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

This guide will walk you through the essential considerations and tech stack for building scalable websites. Know how to grow your business the smart way!
I have a large data set and a SSIS package. How can I load this file in multi threading?
The purpose of this video is to demonstrate how to integrate Mailchimp with Facebook. This will be demonstrated using a Windows 8 PC. Mailchimp and Facebook will be used. Log into your Mailchimp account. : Click on your name. Go to Account Setti…
The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…

695 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