Post reply

Cannot restore a Database on a higher build of 2005 running SP4 to a lower Build w/SP3?

  • November 8, 2011 at 11:40 am

    #251513

    I'm aware of the restore issues with 2008>2005 & 2008 R2>2008.

    I have a database in dev on SQL 2005 Build 9.0.5292 SP4 that I backed up and attempted to restore to a Production SQL 2005 Server with Build 9.0.4305 SP3 and I'm getting the following message:

    TITLE: Microsoft.SqlServer.Smo

    ------------------------------

    System.Data.SqlClient.SqlError: The media family on device DB.bak' is incorrectly formed. SQL Server cannot process this media family.

    Does the same Microsoft saying that a 'higher build of a SQL server database cannot be restored to a lower' apply to SQL 2005 or did SP4 change this logic?

    Really annoying for 2005 if so. Can understand with 2008.

    Any insights if this fact holds true

    Thanks

  • November 8, 2011 at 1:14 pm

    #1404815

    No, that should work. The internal versions of 2005 SP3 and 2005 SP4 are the same (and iirc, 2005 has a more sensible error message about downgrade restores)

    Could be the backup is damaged. Try taking another backup and restoring it

    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

  • November 8, 2011 at 10:43 pm

    #1404956

    Check the backup is valid or not by the following command

    ---RESTORE VERIFYONLY from backup device

    this command will make sure that ur backup is proper

  • November 9, 2011 at 6:22 am

    #1405104

    That command seemed to have worked. Must have been a temporary glitch of some sort through the GUI

    Thanks for your help

Viewing 4 posts - 1 through 3 (of 3 total)

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