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

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

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

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

  • 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

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

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