At a loss here ... my backups against this particular instance have been running great for almost a year, and as of this last week, I am continually failing every night with the same error:
Msg 3266, Sev 16, State 1, Line 2 : The backup data at the end of "path\backup" is incorrectly formatted. Backup sets on the media might be damaged and unusable. To determine the backup sets on the media, use RESTORE HEADERONLY. To determine the usability of the backup sets, run RESTORE VERIFYONLY. If all of the backup sets are incomplete, reformat the media using BACKUP WITH FORMAT, which destroys all the backup sets. [SQLSTATE 42000]
Msg 3013, Sev 16, State 1, Line 2 : BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000]
I come in and resolve the issue by taking a new backup with format, run an additional test backup which works fine ... but then come my nightly scheduled backups, this happens yet again. Unsure what is causing this to continually happen.
Making SQL do what we want it to do.