Post reply

Restore SQL Server 2005 database in SQL Server 2008 instance

  • October 6, 2010 at 10:56 am

    #227595

    Hi,

    I'm trying to restore a SQL Server 2005 database into a SQL Server 2008 instance and getting the below error:

    Msg 3241, Level 16, State 7, Line 1

    The media family on device 'D:\Backups\MyDB_10-06-2010.BAK' is incorrectly formed. SQL Server cannot process this media family.

    Msg 3013, Level 16, State 1, Line 1

    RESTORE DATABASE is terminating abnormally.

    Question:

    Can we Restore SQL Server 2005 database in SQL Server 2008 instance?

    Thanks

  • October 6, 2010 at 10:57 am

    #1232821

    You can, but that backup file is corrupt. Try to take another full backup and restore again.

  • October 6, 2010 at 11:06 am

    #1232828

    hi

    Try with this

    RESTORE VERIFYONLY

    from disk = 'D:\Backups\MyDB_10-06-2010.BAK'

    Your version of SQL Server may be a lower version than the client's and a restore to a lower version is not supported.

    The version used for the backup can be obtained by running

    RESTORE HEADERONLY

    from disk = 'D:\Backups\MyDB_10-06-2010.BAK'

    If both fails then your backup is corrupted .Most likely by transferring the file from FTP or some other place you have not taken fully

    Thanks

    Parthi

    Thanks
    Parthi

  • October 6, 2010 at 11:26 am

    #1232858

    I'm sorry!!!

    My question is wrong. Actually, I'm trying to restore a SQL Server 2008 database backup into a SQL Server 2005 instance and getting the error above mentioned. Is restoring a SQL Server 2008 database backup into a SQL Server 2005 instance possible?

  • October 6, 2010 at 11:33 am

    #1232865

    gmamata7 (10/6/2010)

    I'm sorry!!!

    My question is wrong. Actually, I'm trying to restore a SQL Server 2008 database backup into a SQL Server 2005 instance and getting the error above mentioned. Is restoring a SQL Server 2008 database backup into a SQL Server 2005 instance possible?

    Bakward compatibility is not possiable

    80 = SQL Server 2000

    90 = SQL Server 2005

    100 = SQL Server 2008

    Thanks

    Parthi

    Thanks
    Parthi

  • October 6, 2010 at 11:43 am

    #1232875

    gmamata7 (10/6/2010)

    Is restoring a SQL Server 2008 database backup into a SQL Server 2005 instance possible?

    No, and that's regardless of compatibility level.

    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 5 (of 5 total)

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