Del, 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. But from command line and the TDP GUI it works fine. -----Original Message----- From: Del Hoobler [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 3:07 PM To: [EMAIL PROTECTED] Subject: Re: Sql Agent 2000 and TDP 2.2 for SQL for a cluster configuration. > My SQL expert is having an issue with the SQL Agent and TDP for SQL in a > Windows 2000 clustered environment using MSSQL 2000 . When you run a backup > from the SQL agent the DSM.OPT file must have the following: > > NODENAME CLUSTERNAME (In this case LABCDB10) > > CLUSTERNODE YES > > When run from the command line or TDP SQL GUI the opt file must have : > > NODENAME VIRTUALNODENAME (Where SQL is loaded, LABVDB10) > > CLUSTERNODE YES When running this in a cluster, you should be using the exact same NODENAME in the dsm.opt file for TDP for SQL CLI or GUI. If you use different NODENAMEs the backups will be going to different filespaces. It is our recommendation that the NODENAME you use match the virtual SQL server name. It should not be the cluster server name. I am not sure I understand. When you say "SQL agent" what are you referring to? TDP for SQL? The MS SQL agent service? Or, do you mean the TSM scheduler? Are you using the "/SQLSERVER" option when using the TDP for SQL CLI and GUI? You should be and you must specify the virtual SQL server name on that option. For more details see Chapter 1 and Appendix C of the User's Guide. Thanks, Del ---------------------------------------------------- Del Hoobler IBM Corporation [EMAIL PROTECTED] "Celebrate we will. Life is short but sweet for certain..." -- Dave ________________________________________________________________________ This email has been scanned for all viruses by the MessageLabs SkyScan service. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.messagelabs.com ________________________________________________________________________ ________________________________________________________________________ This email has been scanned for all viruses by the MessageLabs SkyScan service. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.messagelabs.com ________________________________________________________________________
