Database back ups failing

[nondrinker]

Currently we have 3 back ups that run on our SQLServer 2000 like this.
1. Daily diff back up (runs once a day)
2. trans back up (runs every half an hour)
3. Weekly full back up (runs once a week).

Last week i moved the physical location of the .bak file to a different machine. #1 and #2 still ran fine whenever their turn came even after the move, but today i noticed that #3 failed with this error message:

***************************************
" Executed as user: [COMPANYNAME\SQLServer. 10 percent backed up. [SQLSTATE 01000] (Message 3211) 20 percent backed up. [SQLSTATE 01000] (Message 3211) 30 percent backed up. [SQLSTATE 01000] (Message 3211) 40 percent backed up. [SQLSTATE 01000] (Message 3211) 50 percent backed up. [SQLSTATE 01000] (Message 3211) 60 percent backed up. [SQLSTATE 01000] (Message 3211) 70 percent backed up. [SQLSTATE 01000] (Message 3211) Write on 'backup_directory' failed, status = 64. See the SQL Server error log for more details. [SQLSTATE 42000] (Error 3202) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed."

****************************************
And since then whenever #2 tries to run it errors out with this message:

*****************************************
The backup data in 'backup_directory' is incorrectly formatted. Backups cannot be appended, but existing backup sets may still be usable.
******************************************

and this is what #2 executes, (now unsuccesfully)

*********************************************
BACKUP failed to complete the command BACKUP LOG [Orders] TO [backup_directory] WITH NOINIT , NOUNLOAD , NAME = N'Orders trans backup', NOSKIP , STATS = 10, NOFORMAT


*********************************************

Any help in this matter will be appreciated.

Thank you.

 

[SQLBill]

Did you look in the SQL Server Error log for more information?

See the SQL Server error log for more details.

Did you check the Windows Event Viewer Logs to see if there were any related error messages?

What else was going on during the time the full backup failed? Was there another backup being done (maybe of all the files by the system admin)?

Are you backing up to tape or disk? Is there any more space left?

-SQLBill

Posting advice: FAQ481-4875