SQL Server Performance

media family on device '%ls' is incorrectly formed

Discussion in 'General DBA Questions' started by hba, Jul 9, 2007.

  1. hba New Member


    I have a problem with backups failing with the following error:
    "The media family on device '%ls' is incorrectly formed"

    I have tried the following:http://support.microsoft.com/kb/297104

    But it did not help, and the log file is smaller than 4G.

    Is there anything else that could cause this problem?
    hba, Jul 9, 2007
    #2

  2. satya Moderator

    Do you have certain disk quota enabled on that Windows server?

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
    satya, Jul 9, 2007
    #2

  3. MohammedU New Member

    You get this error when the database backup running and job failed due to network issue or destination server reboot which result incomplete backup...
    When you restart the backup job it can't overwrite eventhough you have WITH INIT option in your command...

    To resolve this simply delete the file before running the backup using xp-cmdshell then run the backup...


    MohammedU.
    Microsoft SQL Server MVP
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
    MohammedU, Jul 9, 2007
    #2

  4. Madhivanan Moderator

    Madhivanan, Jul 15, 2009
    #3

Share This Page