Networks

Ask something
Discussion Locked

SQL Backup Error 3266

0 helpful
2 replies

by paulkayengheng

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

My backup are failing daily with these error message:

The backup data in 'TRates_BackupToDEV' is incorrectly formatted. Backups cannot be appended, but existing backup sets may still be usable. [SQLSTATE 42000] (Error 3266) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.

2 replies

by tony hopkinson

MS Says
http://support.microsoft.com/default.aspx?scid=kb;EN-US;290787

Which I've got to admit is n't a damn lot of help.
I've had this when I've backed up to a device (disk) on one machine and then move it to another and attempted a restore from device (restore from file worked) but there was only one backup set in the file.
Other than that they appear to be saying hardware/network error. Me thinks ms bug personally.

This discussion is closed to new replies.