> 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
Del Hoobler
IBM Corporation
hoobler AT us.ibm DOT com
"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
________________________________________________________________________
|