Restore the backup of SQLServer 2008 R2 X64 in SQLServer 2008 R2 X86

Question

Restore the backup of SQLServer 2008 R2 X64 in SQLServer 2008 R2 X86

ravisamigo

SSCertifiable

Points: 7440
More actions
July 18, 2012 at 1:21 am

#264009

Hi All,
Can't we restore the backup of SQLServer 2008 R2 X64(Enterprise Evaluation Edition) in SQLServer 2008 R2 X86(Dev edition) ?
When I'm trying to restore/check the restore verify only...it's throwing below error
Msg 3241, Level 16, State 7, Line 1
The media family on device 'C:\DB\xxxxxxx_backup_2012_07_17_180003_3877933.bak' is incorrectly formed. SQL Server cannot process this media family.
Msg 3013, Level 16, State 1, Line 1
VERIFY DATABASE is terminating abnormally.
Please advise.
Thanks and Regards,
Ravi.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Yes, restoring a 2008 R2 backup from an x64 server to 2008 R2 on x86 works fine. Done it several times.

Check that the x64 doesn't have some 3rd party backup tool that's running the backups. Otherwise re-copy, backup could have been damaged in the copy.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

ravisamigo SSCertifiable Points: 7440 More actions · Answer 2

Thanks Gail Shaw.

The same backup is valid (Restore verifyonly..) when I checked in the SQLServer2008 R2X64 bit.

There are no thirdparty tool we use SQLjobs for backups.

Thanks and Regards,

Ravi.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Then it got damaged in the copy.

If both servers are 2008 R2 then you can restore backups between them. x86 vs x64 never matters

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

ravisamigo SSCertifiable Points: 7440 More actions · Answer 4

Please advise how I can resolve this issue. Even tried to transfer the backup file (after zipped) through http://ftp..but still facing the same issue.

Thanks and Regards,

Ravi.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

Check that there isn't a 3rd party backup tool (eg hyperbak)

Check that you can restore the backup right after taking it (verifyonly is not good enough)

Check that the SQL instances really are the same version

Try transfering the backup another way.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass