SQL Backup failed with exit code: 760
--my backup files look ok (based on date modified and based on the jobs step output file )
--SQL BAckup however thows error 760 causing the job to reflect failed state.IN the step output file everything seems to success except the last line which says "Msg 50000, Sev 16: SQL Backup failed with exit code: 760 SQL error code: 0 [SQLSTATE 42000]"
--the tlog backups also fail with this error sometimes.(again,,,backup files look ok though)
--I ran this (that petey has given out in some other forum) :
SELECT a.backup_start_date, a.database_name, a.first_lsn, b.*
FROM msdb..backupset a
INNER JOIN msdb..backupmediafamily b ON a.media_set_id = b.media_set_id
INNER JOIN master..sysdatabases c ON a.database_name COLLATE DATABASE_DEFAULT = c.name COLLATE DATABASE_DEFAULT
WHERE b.physical_device_name LIKE 'SQLBACKUP_%'
And it returns 39 rows....with backup start date showing dates beteen 2-4 years ago ( nothing recent)
---FYI..this is sql 2000 and SQL Backup v18.104.22.168
Any help would be appreciated!
thanks in advance!