When trying to back up SQL2000 (SP4) it apears to back up a few of the databases, but then errors out on the rest. I receive the following:
V-79-57344-33938 -
An error occurred on a query to database xxxxxxx.
Final error: 0xe0008492 - Database Query Failure. See the job log for details.
Final error category: Resource Errors
I have the SQL agent, I've tried to run with and with out AOFO. I've set the "restrict anonymous" on both the media server and the resource SQL server to 1. Tried reinstalling the agent on the resource server. Nothing helps.
The odd thing is that I can back up the SQL database on other servers just fine without having to do any of the fixes.
Oh, I'm also running BE10.1 Rev 5629.
Any ideas?
