January 12, 2004 at 10:44 am
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.
January 12, 2004 at 11:56 am
http://support.microsoft.com/default.aspx?scid=kb;en-us;297104&Product=sql2k
Could there be mulitiple backup files you have to restore together?
January 12, 2004 at 12:01 pm
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
January 13, 2004 at 6:55 am
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