locked
How to restore a database from sql server 2012 on to sql server 2014. RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I am facing issues while a restoring database from the backup of SQL server 2012 in SQL server 2014.

    I am using the following command for restore.

    Restore database Data from disk='XXX.BAK' with Replace, Recovery;

    and following is the error 

    Msg 3241, Level 16, State 0, Line 1
    The media family on device 'XXX.BAK' is incorrectly formed. SQL Server cannot process this media family.
    Msg 3013, Level 16, State 1, Line 1
    RESTORE DATABASE is terminating abnormally. 

    Can anybody help me in solving the issue.

    Thanks, 

    Rahul








    • Edited by Shanky_621MVP Tuesday, March 8, 2016 2:40 PM formatting
    • Edited by rahulk123 Tuesday, March 8, 2016 2:56 PM
    Tuesday, March 8, 2016 2:35 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Shanky,

    Thanks for your response I tried the command. 

    and following is the error.

    Msg 3241, Level 16, State 0, Line 1
    The media family on device 'XXX.BAK' is incorrectly formed. SQL Server cannot process this media family.
    Msg 3013, Level 16, State 1, Line 1
    VERIFY DATABASE is terminating abnormally.

    Thanks,

    Rahul

    Rahul please take backup again this backup is corrupt. And include checksum  like below

    backup database data from disk='xx.bak' with init, checksum,stats=10
    How often do you run checkdb when was time when checkdb finished successfully ?

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Wiki Articles
    MVP

    Tuesday, March 8, 2016 3:06 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Are you trying to restore a SQL 2012 Enterprise database into a SQL 2014 Standard instance ?

    That may not work because of Enterprise-only features (like TDE).

    Otherwise, you should have no problem restoring a SQL 2012 database into a SQL 2014 instance.

    Tuesday, March 8, 2016 2:40 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Sebastian this message would not come when there is edition mismatch the error message would be different when you are restoring and ent features is used.

    Rahul

    Can you run below on backup and post us what is the output

    restore verifyonly from disk='XXX.BAK'

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Wiki Articles
    MVP

    Tuesday, March 8, 2016 2:41 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Shanky,

    Thanks for your response I tried the command. 

    and following is the error.

    Msg 3241, Level 16, State 0, Line 1
    The media family on device 'XXX.BAK' is incorrectly formed. SQL Server cannot process this media family.
    Msg 3013, Level 16, State 1, Line 1
    VERIFY DATABASE is terminating abnormally.

    Thanks,

    Rahul

    Tuesday, March 8, 2016 2:59 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Shanky,

    Thanks for your response I tried the command. 

    and following is the error.

    Msg 3241, Level 16, State 0, Line 1
    The media family on device 'XXX.BAK' is incorrectly formed. SQL Server cannot process this media family.
    Msg 3013, Level 16, State 1, Line 1
    VERIFY DATABASE is terminating abnormally.

    Thanks,

    Rahul

    Rahul please take backup again this backup is corrupt. And include checksum  like below

    backup database data from disk='xx.bak' with init, checksum,stats=10
    How often do you run checkdb when was time when checkdb finished successfully ?

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Wiki Articles
    MVP

    Tuesday, March 8, 2016 3:06 PM