Server: Msg 3241

  • HEEELP!

    I am trying to restore a production database about 17GB to a development server.  I am not the DBA of the production Server, I am the DBA of the development Server.

    The message that is always coming up is:

    Server:  Msg 3241, Level 16, State 37, Line 1,The media family on device $$$$ is incorrectly formed, SQL Server cannot process this media family.

    Server:  Msg 3013, Level 16, State 1, Line 1, RESTORE DATABASE is terminating abnormally.

    For what I have seen this problem may stem from how the backup is configure, Have anyone come across this problem, and how was it solve.

     

    Thanking you in advance.

     

  • http://support.microsoft.com/default.aspx?scid=kb;en-us;297104&Product=sql2k

    Could there be mulitiple backup files you have to restore together?

  • Quite possible, the problem is that the production DBA doesn't communicate at all, so I need to go around him to get my job done.

    I basically want to try all possible avenues before I bug him.

     

    If any suggestion I am will to listen.

     

    Lystra

     

  • Try a restore labelonly on the file and check the familycount column that it returns to see if it is more than one and then check the familysequencenumber to see which file it is in the family.

     

    -Chris

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

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