cancel
Showing results for 
Search instead for 
Did you mean: 

MSSQL backup failing with error 2

Chan_backup
Level 5

Hi,

There is was login issue with Netbackup sql agent. When i client on it, it gives out error. it seems to be problem with sa account.

so i asked sql team to create a new account sa_bak after that i'm able to connect with Netbackup Sql Agent and able to browse the DB instance.

After that initiated the backup, but its still faling with same error and still trying to connect with sa account not with sa_bak.

Please find the attached activity monitor details, dbclient log and bppllist.

 

-Chan

1 ACCEPTED SOLUTION

Accepted Solutions

Chan_backup
Level 5

Hi,

The issue is resolved.

its a connectivity issues with server and client
its trying to backup with production interface\
and we have cleared the cache in the host
there is no problem with sa account

/etc/host ip and server entry was made as there is not DNS setup for this particular environment.

 

-Chan
 

View solution in original post

3 REPLIES 3

RamNagalla
Moderator
Moderator
Partner    VIP    Certified

Please change the log in accout with the id that you have created in netbackup client servives and also  NetBackup Legacy Network Service

http://www.symantec.com/business/support/index?page=content&id=HOWTO85432

 

and see if that helps.

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

Did you set the connection properties after login with the new account?

Chan_backup
Level 5

Hi,

The issue is resolved.

its a connectivity issues with server and client
its trying to backup with production interface\
and we have cleared the cache in the host
there is no problem with sa account

/etc/host ip and server entry was made as there is not DNS setup for this particular environment.

 

-Chan