Post reply

Backup : error message about format

  • July 9, 2004 at 2:41 am

    #109084

    Hi,

    I have a job Fullbackup who run all night. Since 3 days I have an error messages like this :

    Msg 3266, Sev 16: The backup data in 'F:\MSSQL\BACKUP\master_1.dmp' is incorrectly formatted. Backups cannot be appended, but existing backup sets may still be usable. [SQLSTATE 42000]

    Msg 3013, Sev 16: BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000]

    Msg 0, Sev 16: Backup of database [master] [SQLSTATE 01000]

    Msg 0, Sev 16: * [SQLSTATE 01000]

    Note : Although backup master doesn't work, all my databases were backuped in the same directory ('F:\MSSQL\BACKUP\)

    On this problem MS said :

    A filemark in the backup device could not be read. There are many reasons as to why you may encounter a filemark error. Some of the reasons include:

    • A media failure on the device where the backup is located.
    • A write failure during the creation of the backup. For example a loss of connectivity during a network backup.

    WORKAROUND

    To allow SQL Server to perform new backups to the backup device, you must manually delete or erase the device by using the following command: 

    BACKUP DATABASE mydatabase TO DISK='C:\MyDatabase.bak' with FORMATBut it doesn't fix the problem
    Can anyone have this problem find the solution ?
    Kinds Regards
    Philippe (Brezhoneg DBA)

  • July 12, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • April 3, 2007 at 9:49 am

    #698338

    Copy the backup file to some other location and delete the  original file from the backup location. Re start the job and it will work fine.

    Thanks,

    -Mohsin

  • June 27, 2010 at 10:27 pm

    #1185498

    Hi friend

    Please refer this link by MS

    http://support.microsoft.com/kb/290787

    thanks

    Surendra

  • July 21, 2010 at 10:02 pm

    #1196623

    As mentioned earlier, the backup file format is not usable and the file needs to be deleted. After that try taking the backup with INIT or FORMAT options in the Backup Command.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

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

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