[SQLDownUnder] Transaction backup job failed

[Susan]

Hi All,

 

Hopefully this is my last question for this year  :-)

 

my transaction log backup is almosy failed all the time.

 

when I look at in history the message below appears:

 

Executed as user: DomNa\svccluster. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029).  The step failed.

when I look at the report also shows me the message as below:

 

End of maintenance plan 'User DB Maintenance Plan' on 21/12/2006 8:30:22 AM
SQLMAINT.EXE Process Exit Code: 1 (Failed)

 

when I look this svccluster's security, it has ' server admin' role but in database access tab, it doesn't have any DB access tick. so does this relate to the problems?

 

Thanks,

 

Susan

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net