AS 2000 SQL Agent on NT 4.0 Cluster error E8602

[Peterj0]

I have got a problem with a NT 4.0 SP6a Cluster and SQL 7.0 SP3. This is an Active/Passive SQL Cluster setup. The Active node1 backup is working find using the AS SQL Agent. But when the SQL resources are failed on to the passive node2 the backup fails with the following error.

E8602 Failed to read from database. (DBNAME=master, EC=Backup Agent Error - (127) "Error at virtual Device set. Please check the SQL Server VDI.LOG)

The VDI.LOG out is below

----------------------------------------------
2002/10/30 17:32:52 pid(398)
Error on DBASQL70TID483VD0
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified.

----------------------------------------------
2002/10/30 17:33:25 pid(398)
Error on DBASQL70TID483VD0
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified.

----------------------------------------------
2002/10/30 17:33:58 pid(398)
Error on DBASQL70TID483VD0
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified.

----------------------------------------------
2002/10/30 17:34:31 pid(398)
Error on DBASQL70TID483VD0
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified.

----------------------------------------------
2002/10/30 17:35:04 pid(398)
Error on DBASQL70TID483VD0
Error at SVDS::Open: Open(control) Status Code: 2, x2
Explanation: The system cannot find the file specified.

Things tried:

Reinstalled the SQL Agent and SP3 for AS. Followed cluster install guide on the arcserve support site.

http://support.ca.com/techbases/as2000/as2k-18166.html

Checked arcticle relating to error E8602. This states that updated to SQL SP2 should fix the issue but the SQL Cluster is at SP3. The file in questions is the same version.

http://support.ca.com/techbases/asnt/e8602.html

Also this is a fresh install of SQL 7.0 SP3 (i havn't upgrade from SQL 6.5.

Questions:
Has anyone out there have the same configuration that works ?

Does any one know how to fix this ?

 

[Peterj0]

Sorry to answer my own question but i just read the manual.

The SQL Virtual Server is always remote. The SQL Virtual Server is listedunder the MSCS icon. Therefore it must be backed up through the network or the preferred shares under the MSCS icon in the Backup Manager. It should not be backed up through the local machine or the SQL Virtual Server icon.

i.e local machine backup do not work with SQL Clusters

 

[amacqueen]

Hi,

Just to let you know..

When you install the sql agent use "virtual sql server" name.

The backups should be done thru the "virtual machine"..
See the cluster administrator window and the topmost name will be your "virtual machine"...

thanks,
baba

 

[Arcservebaba]

HI,

The above update is from arcservebaba..

thanks,
baba Baba says...
"Known is a drop, unknown is a ocean"