+ Reply to Thread
Results 1 to 8 of 8

Restore problem... "The media family on device '%ls' is incorrectly formed"

  1. Restore problem... "The media family on device '%ls' is incorrectly formed"

    A client keeps sending me .BAK files. A couple have worked, but I
    have gotten this error on many:

    Error 3241 Severity 16 State 1
    The media family on device '%ls' is incorrectly formed. SQL Server
    cannot process this media family.

    If I view the contents of the .BAK (in Enterprise Manager), it says it
    is INCOMPLETE.

    This indicates that maybe the backup was bad. However, since they have
    sent me so many bad ones, my question is why are these backups turning
    out bad?

    Some details:

    -The client is using SQL Server 2000 SP4, so am I
    -I am running Win2K Server, they are running Win 2003 server.
    -I looked at KB 297104 which deals with this error, but that is for
    pre-SP4.
    -When I run a restore verifyonly, I get the same error

    Since I am off-site and can't go to the client site, any ideas on what
    they may be doing wrong or what we can do for me to get a legitimate
    copy of this database on my server? I am going crazy with these files
    that won't load and don't know what to tell my client.


  2. Re: Restore problem... "The media family on device '%ls' is incorrectly formed"

    have them run a verify before sending them to you. This should guarantee a
    valid backup.

    --
    RelevantNoise.com - dedicated to mining blogs for business intelligence.

    Looking for a SQL Server replication book?
    http://www.nwsu.com/0974973602.html

    Looking for a FAQ on Indexing Services/SQL FTS
    http://www.indexserverfaq.com
    "Mike C" wrote in message
    news:1187736521.741462.231380@l22g2000prc.googlegroups.com...
    >A client keeps sending me .BAK files. A couple have worked, but I
    > have gotten this error on many:
    >
    > Error 3241 Severity 16 State 1
    > The media family on device '%ls' is incorrectly formed. SQL Server
    > cannot process this media family.
    >
    > If I view the contents of the .BAK (in Enterprise Manager), it says it
    > is INCOMPLETE.
    >
    > This indicates that maybe the backup was bad. However, since they have
    > sent me so many bad ones, my question is why are these backups turning
    > out bad?
    >
    > Some details:
    >
    > -The client is using SQL Server 2000 SP4, so am I
    > -I am running Win2K Server, they are running Win 2003 server.
    > -I looked at KB 297104 which deals with this error, but that is for
    > pre-SP4.
    > -When I run a restore verifyonly, I get the same error
    >
    > Since I am off-site and can't go to the client site, any ideas on what
    > they may be doing wrong or what we can do for me to get a legitimate
    > copy of this database on my server? I am going crazy with these files
    > that won't load and don't know what to tell my client.
    >




  3. Re: Restore problem... "The media family on device '%ls' is incorrectly formed"

    Hello,

    First of all tell your client to do a restore with verify only or header only
    to test, on their side, the correctness of the backup. If it's possible, tell
    the client to do a full restore of the backup.
    Second, if the first worked out well, send back the media to the client and
    tell them to try the above process.
    It is possible that between different copies of the backup file it becomes
    corrupt. If the transfer of the backup file it is done over wan this is
    something sure. A second possibility it is this file is part of a multivolume
    backup. Sql Server has the option to backup a database to more than one file
    to speed up the backup process.
    Hope this helps you solve the problem.

    I recommend you reading this too
    http://www.dbforums.com/showthread.php?t=682406.

    Cheers.


    Mike C wrote:
    >A client keeps sending me .BAK files. A couple have worked, but I
    >have gotten this error on many:
    >
    >Error 3241 Severity 16 State 1
    >The media family on device '%ls' is incorrectly formed. SQL Server
    >cannot process this media family.
    >
    >If I view the contents of the .BAK (in Enterprise Manager), it says it
    >is INCOMPLETE.
    >
    >This indicates that maybe the backup was bad. However, since they have
    >sent me so many bad ones, my question is why are these backups turning
    >out bad?
    >
    >Some details:
    >
    >-The client is using SQL Server 2000 SP4, so am I
    >-I am running Win2K Server, they are running Win 2003 server.
    >-I looked at KB 297104 which deals with this error, but that is for
    >pre-SP4.
    >-When I run a restore verifyonly, I get the same error
    >
    >Since I am off-site and can't go to the client site, any ideas on what
    >they may be doing wrong or what we can do for me to get a legitimate
    >copy of this database on my server? I am going crazy with these files
    >that won't load and don't know what to tell my client.



  4. Re: Restore problem... "The media family on device '%ls' is incorrectly formed"

    On Aug 22, 5:08 am, "flooriin" wrote:
    > Hello,
    >
    > First of all tell your client to do arestorewith verify only or header only
    > to test, on their side, the correctness of the backup. If it's possible, tell
    > the client to do a fullrestoreof the backup.
    > Second, if the first worked out well, send back themediato the client and
    > tell them to try the above process.
    > It is possible that between different copies of the backup file it becomes
    > corrupt. If the transfer of the backup file it is done over wan this is
    > something sure. A second possibility it is this file is part of a multivolume
    > backup. Sql Server has the option to backup a database to more than one file
    > to speed up the backup process.
    > Hope this helps you solve theproblem.
    >
    > I recommend you reading this toohttp://www.dbforums.com/showthread.php?t=682406.
    >
    > Cheers.
    >
    > Mike C wrote:
    > >A client keeps sending me .BAK files. A couple have worked, but I
    > >have gotten this error on many:

    >
    > >Error 3241 Severity 16 State 1
    > >Themediafamily on device '%ls' is incorrectly formed. SQL Server
    > >cannot process thismediafamily.

    >
    > >If I view the contents of the .BAK (in Enterprise Manager), it says it
    > >is INCOMPLETE.

    >
    > >This indicates that maybe the backup was bad. However, since they have
    > >sent me so many bad ones, my question is why are these backups turning
    > >out bad?

    >
    > >Some details:

    >
    > >-The client is using SQL Server 2000 SP4, so am I
    > >-I am running Win2K Server, they are running Win 2003 server.
    > >-I looked at KB 297104 which deals with this error, but that is for
    > >pre-SP4.
    > >-When I run arestoreverifyonly, I get the same error

    >
    > >Since I am off-site and can't go to the client site, any ideas on what
    > >they may be doing wrong or what we can do for me to get a legitimate
    > >copy of this database on my server? I am going crazy with these files
    > >that won't load and don't know what to tell my client.


    The client said they did a verify when they did the backup. I will
    have them check to see if RESTORE VERIFYONLY works. Assuming the file
    is good, I can only think of 2 unlikely issues:

    -The file is becoming corrupt when they zip it up. Since it is bigger
    than a DVD, that is the only way to get it to me.
    -Running W2K Server vs. W2003 Server is making some dofference.


  5. Re: Restore problem... "The media family on device '%ls' is incorrectly formed"

    On Aug 22, 5:08 am, "flooriin" wrote:
    > Hello,
    >
    > First of all tell your client to do a restore with verify only or header only
    > to test, on their side, the correctness of the backup. If it's possible, tell
    > the client to do a full restore of the backup.
    > Second, if the first worked out well, send back the media to the client and
    > tell them to try the above process.
    > It is possible that between different copies of the backup file it becomes
    > corrupt. If the transfer of the backup file it is done over wan this is
    > something sure. A second possibility it is this file is part of a multivolume
    > backup. Sql Server has the option to backup a database to more than one file
    > to speed up the backup process.
    > Hope this helps you solve the problem.
    >
    > I recommend you reading this toohttp://www.dbforums.com/showthread.php?t=682406.
    >
    > Cheers.
    >
    > Mike C wrote:
    > >A client keeps sending me .BAK files. A couple have worked, but I
    > >have gotten this error on many:

    >
    > >Error 3241 Severity 16 State 1
    > >The media family on device '%ls' is incorrectly formed. SQL Server
    > >cannot process this media family.

    >
    > >If I view the contents of the .BAK (in Enterprise Manager), it says it
    > >is INCOMPLETE.

    >
    > >This indicates that maybe the backup was bad. However, since they have
    > >sent me so many bad ones, my question is why are these backups turning
    > >out bad?

    >
    > >Some details:

    >
    > >-The client is using SQL Server 2000 SP4, so am I
    > >-I am running Win2K Server, they are running Win 2003 server.
    > >-I looked at KB 297104 which deals with this error, but that is for
    > >pre-SP4.
    > >-When I run a restore verifyonly, I get the same error

    >
    > >Since I am off-site and can't go to the client site, any ideas on what
    > >they may be doing wrong or what we can do for me to get a legitimate
    > >copy of this database on my server? I am going crazy with these files
    > >that won't load and don't know what to tell my client.


    The restore verifyonly or backuponly works at the client site. I
    verified versions. They are using Sql Server 2000 SP3 (plus a
    cumulative patch) while I am running SP4. I can try and go back to
    SP3, but that seems unlikely culprit (more likely if their version
    were higher than mine). Any other ideas?


  6. Re: Restore problem... "The media family on device '%ls' is incorrectly formed"

    On Aug 22, 5:08 am, "flooriin" wrote:
    > Hello,
    >
    > First of all tell your client to do a restore with verify only or header only
    > to test, on their side, the correctness of the backup. If it's possible, tell
    > the client to do a full restore of the backup.
    > Second, if the first worked out well, send back the media to the client and
    > tell them to try the above process.
    > It is possible that between different copies of the backup file it becomes
    > corrupt. If the transfer of the backup file it is done over wan this is
    > something sure. A second possibility it is this file is part of a multivolume
    > backup. Sql Server has the option to backup a database to more than one file
    > to speed up the backup process.
    > Hope this helps you solve the problem.
    >
    > I recommend you reading this toohttp://www.dbforums.com/showthread.php?t=682406.
    >
    > Cheers.
    >
    > Mike C wrote:
    > >A client keeps sending me .BAK files. A couple have worked, but I
    > >have gotten this error on many:

    >
    > >Error 3241 Severity 16 State 1
    > >The media family on device '%ls' is incorrectly formed. SQL Server
    > >cannot process this media family.

    >
    > >If I view the contents of the .BAK (in Enterprise Manager), it says it
    > >is INCOMPLETE.

    >
    > >This indicates that maybe the backup was bad. However, since they have
    > >sent me so many bad ones, my question is why are these backups turning
    > >out bad?

    >
    > >Some details:

    >
    > >-The client is using SQL Server 2000 SP4, so am I
    > >-I am running Win2K Server, they are running Win 2003 server.
    > >-I looked at KB 297104 which deals with this error, but that is for
    > >pre-SP4.
    > >-When I run a restore verifyonly, I get the same error

    >
    > >Since I am off-site and can't go to the client site, any ideas on what
    > >they may be doing wrong or what we can do for me to get a legitimate
    > >copy of this database on my server? I am going crazy with these files
    > >that won't load and don't know what to tell my client.


    Do you think me being on w2K and them on W2003 server makes a
    difference?


  7. Re: Restore problem... "The media family on device '%ls' is incorrectly formed"

    I do not believe the problem arise because of different Windows versions. I
    think it's more about database and the process to backup and deliver the
    database. You have said that are cases when the backup was restored
    successfully. What is different from your current situation? I am more
    concern about different Sql Server version. I know about a bug in SP3 when a
    differential database backup could miss to save some extents ... but you are
    talking about full backup.

    Read this too
    http://www.sqlservercentral.com/foru...eid=167366&p=2
    Maybe it will help you. Read the last post and try out the utility told
    there.

    Cheers.

    Mike C wrote:
    >> Hello,
    >>

    >[quoted text clipped - 40 lines]
    >> >copy of this database on my server? I am going crazy with these files
    >> >that won't load and don't know what to tell my client.

    >
    >Do you think me being on w2K and them on W2003 server makes a
    >difference?


    --
    Message posted via SQLMonster.com
    http://www.sqlmonster.com/Uwe/Forums...erver/200708/1


  8. Re: Restore problem... "The media family on device '%ls' is incorrectly formed"

    On Aug 24, 6:25 am, "flooriin via SQLMonster.com" wrote:
    > I do not believe the problem arise because of different Windows versions. I
    > think it's more about database and the process to backup and deliver the
    > database. You have said that are cases when the backup was restored
    > successfully. What is different from your current situation? I am more
    > concern about different Sql Server version. I know about a bug in SP3 when a
    > differential database backup could miss to save some extents ... but you are
    > talking about full backup.
    >
    > Read this toohttp://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&mes...
    > Maybe it will help you. Read the last post and try out the utility told
    > there.
    >
    > Cheers.
    >
    > Mike C wrote:
    > >> Hello,

    >
    > >[quoted text clipped - 40 lines]
    > >> >copy of this database on my server? I am going crazy with these files
    > >> >that won't load and don't know what to tell my client.

    >
    > >Do you think me being on w2K and them on W2003 server makes a
    > >difference?

    >
    > --
    > Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200708/1


    I installed SQL Server 2000 MSDE on an XP box and I was able to
    restore the backup. That means the file is fine. I am just going to
    work with that since I don't need any of the enterprise features.
    This is a short project and it isn't worth spending 100 hrs trying to
    figure out what the problem is.


+ Reply to Thread