cancel
Showing results for 
Search instead for 
Did you mean: 

SQL 2005 backup ErrorCode 2

Renzo_Samuels
Level 3
Hi,

We have a backup problem and we cannot figure it out.
We use Netbackup 6.5.4 and we make sql backups with the sql netbackup sql client.

We have replaced an windows 2003 standard server with a Windows 2008 server 64 bit. Server has the same name as before.
Since that time the sql backup fails. Funny thing, the windwos backup runs perfect.
I checked all the security settings and everything seems to be oke, but the sql backup refuses to work.

Does anyone have any idea ?
All help is appriciated!!

Thanks in advance

Karel
8 REPLIES 8

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified
Please post errors seen in dbclient log on SQL host.

Renzo_Samuels
Level 3
ERR - Error in CDBbackrec::CDBbackrec: 6.
    CONTINUATION: - The system cannot find the file specified.
ERR - Error in VxBSASetEnv(BSA_SERVICE_HOST): 6.
    CONTINUATION: - The handle used to associate this call with a previous VxBSAInit() call is invalid.

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified
This looks like extract from progress log, not dbclient, right?

Renzo_Samuels
Level 3


Renzo_Samuels
Level 3
I have solved the problem.
The server where sql is installed on, has multiple ip-addresses.

thanks for the tip of the dbclientlog! forgot to look in it.....

sluttyduck
Level 3
Karaltje,
What did you do to resolve your issue.
I'm seeing the same error with an SQL cluster with multiple IP addresses.
Thanks

sql_noob
Level 4
with clusters you have to make sure each node has the script file. i even had to create separate policies for each of my cluster instances so i can create separate scripts for each one if i ever run more than one instance on a host

sluttyduck
Level 3
http://seer.entsupport.symantec.com/docs/334935.htm
I'm waiting on my Networking group to add the reverse lookups.
hopefully that will solve my issues.