> Yes, SQL Agent is the SQL Server Agent service.
> Yes, the /SQLServer option is being used in all cases which is set to the
> virtual server name.
>
> When using the SQL Server Agent and the DSM.opt has the Virtual SQL
Server
> node name we receive the follow error:
>
> NODENAME cannot be the local machine name when CLUSTERNODE is set to YES.
> Process Exit Code 418. The step failed.
>
> The dsierror.log shows the following:
> 02/07/2002 15:05:20 ANS1155E CLUSTERNODE option is set to YES but cluster
is
> not enabled.
> Either the machine does not have cluster server installed, or the cluster
> server is not running.
Bruce, Tony,
Try setting the following variable in
the batch file that you run right
BEFORE you kick off the tdpsqlc command.
_VIRTUAL_SERVER_NAME_=clus-server-name
where clus-server-name is the name of
your "CLUSTER virtual server" and
NOT the SQL virtual server name.
---
For example:
For example:
===========================================
SET _VIRTUAL_SERVER_NAME_=VIRTUAL_SERVER_NAME
tdpsqlc backup * full /sqlserver=VIRTUAL_SQL_SERVER_NAME
===========================================
Notice the values are different. One is the
virtual cluster name, and the other the
virtual SQL cluster name.
Thanks,
Del
----------------------------------------------------
Del Hoobler
Del Hoobler
IBM Corporation
hoobler AT us.ibm DOT com
"Celebrate we will. Life is short but sweet for certain..." -- Dave
|