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 Anyone else having this problem? Bruce E. Lowrie Sr. Systems Analyst Information Technology Services Storage, Output, Legacy *E-Mail: [EMAIL PROTECTED] *Voice: (989) 496-6404 7 Fax: (989) 496-6437 *Post: 2200 W. Salzburg Rd. *Post: Mail: CO2111 *Post: Midland, MI 48686-0994 This e-mail transmission and any files that accompany it may contain sensitive information belonging to the sender. The information is intended only for the use of the individual or entity named. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on the contents of this information is strictly prohibited. Dow Corning's practice statement for digitally signed messages may be found at http://www.dowcorning.com/dcps. If you have received this e-mail transmission in error, please immediately notify the Security Administrator at <mailto:[EMAIL PROTECTED]> ________________________________________________________________________ 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 ________________________________________________________________________
