E8602 Failed to read from database. Agent Error (127)

[lovalles]

I have seen this problem with Sql 7.0 and resolve it with SP2, but i have SQL2000 and ArcServe 2000.
what could be wrong?

this is the vdi.log file

2001/12/19 21:44:02 pid(2776) tid(2484)
Error on Global\DBASQL70TID2484VD0
Error at TriggerAbort: invoked

 

[techsolid]

1) Check the Databases compatability from Enterprise manager. It should be 80 for SQL 2000. If it is not, then you have this error.
2) Install SQL agent with SA account
3) Check the SQL services properties. If particular service is started with any specific account, make sure that account has LOAD AND DUMP permissions on databases.

Thnx
Pat

 

[CInman]

Does that mean that a database running in compatibility mode 70 in SQL 2000 will not be able to be backed up using ArcServe 2000?

 

[fritz4000]

When the agent sees that a certain version of SQL is installed, it can only backup database with that compatibility level (this is what I have seen to this point). It is also my experience that upgrading SQL (say from 6.5 to 7) only updates the compatibility level of standard SQL databases. Custom databases tend to not get updated properly.