The backup data in ‘%ls’ is incorrectly formatted. Backups cannot be appended, but existing backup sets may still be usable.

Details
Product: SQL Server
Event ID: 3266
Source: MSSQLServer
Version: 8.0
Component: SQL Engine
Message: The backup data in ‘%ls’ is incorrectly formatted. Backups cannot be appended, but existing backup sets may still be usable.
   
Explanation
A filemark in the backup device specified in the BACKUP or RESTORE operation could not be read. Possible 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.
  • Often an operating system error will also be reported, such as when the disk is out of space or the path is not found. If so, this will indicate the underlying cause of the error.

For more information about this message, see Microsoft Knowledge Base article 290787.

   
User Action
Follow these steps:

  • Check the output from your BACKUP or RESTORE command as well as the SQL Server error log for related errors and troubleshoot them.
  • Verify that the specified backup file is not damaged.
  • If the backup device specified in the BACKUP or RESTORE command is on a remote server, retry the operation when connectivity between the machines will not be a problem, or move the backup device to the local server.
  • You can not add more backups to a disk file in this condition. If you want to back up to this disk file, use WITH FORMAT to overwrite it. If you want to restore from the damaged backup file, and there is more than one backup set in the file, some of those backup sets may be usable. Use RESTORE HEADERONLY or RESTORE VERIFYONLY to find out what is in that backup file and whether any of the backup sets are usable.

Related:

Leave a Reply