Hi, I have an interesting TDP for SQL problem. Similar issues have been addressed many times on the forum, but this is a bit different, i think.
I have: Windows server running multiple (x2) SQL server instances SQL server called SERVERX One instance called INSTANCE1 and the other called INSTANCE2 TDP TSM 5.2.2 server on Z/os 1.5 My configuration: I have defined two TDP nodes, i.e. TDPNODE1 and TDPNODE2 Two DSM.OPT files (TDPNODE1.opt and TDPNODE2.opt) with appropraite node names Command files (one for log, one for incremental and one for full backups). This is the contents of the LOG command file: @ECHO OFF set sql_dir="C:\Tsm\TDPSql" cd /d %sql_dir% echo Current date is:>> C:\TSM\tdpsql\logs\sqlbkup.log date /t < NUL >> C:\TSM\tdpsql\logs\sqlbkup.log echo Current time is:>> C:\TSM\tdpsql\logs\sqlbkup.log time /t < NUL >> C:\TSM\tdpsql\logs\sqlbkup.log start /b /wait tdpsqlc backup * log /tsmoptfile=c:\tsm\tdpsql\tdpnode1.opt /logfile=c:\tsm\tdpsql\logs\sqlbkup.log start /b tdpsqlc backup * log /tsmoptfile=c:\tsm\tdpsql\tdpnode2.opt /logfile=c:\tsm\tdpsql\logs\sqlbkup.log /sqlserver=serverx\instance2 Scheduled service TSM schedule with OBJECTS field using a command file on the windows server I backup logs, daily incr and full weekly This configuration works just fine. I get two filespaces for each nodename (meta and data for each). Node name is TDPNODE1 Filespace name of SERVERX\TDPNODE1\meta\0000 Filespace name of SERVERX\TDPNODE1\data\0001 and Node name is TDPNODE2 Filespace name of SERVERX\TDPNODE2\meta\0000 Filespace name of SERVERX\TDPNODE2\data\0001 My problem? Running via the schedule is good. The backups run and are written to the correct filespaces. If i run a backup for TDPNODE1 from the GUI, this works fine. But, if i run a backup for TDPNODE2 from the GUI, it creates filespaces with TDPNODE1 as the node name but filespace names of SERVERX\TDPNODE2\meta\0000 and SERVERX\TDPNODE2\data\0001, and increments the fsid count. So, the problem only occurs at the GUI. Yes, i have followed the red book where it states clearly that to use the GUI for operations of another SQL server instance, create a shortcut to tdpsql.exe and specify another instance: /sqlserver=server_instance_name. I can get by because the normal method of backup, via the schedules, works good. But if the DBA decides to do a manual/GUI backup, the data is written to a different filespace. I noted Del's comments last month that perhaps some subscribers on the list will share experiences of their environment, so i though i'd ask the question. Any thoughts? Jeff White ************************************************************************* This e-mail may contain confidential information or be privileged. It is intended to be read and used only by the named recipient(s). If you are not the intended recipient(s) please notify us immediately so that we can make arrangements for its return: you should not disclose the contents of this e-mail to any other person, or take any copies. Unless stated otherwise by an authorised individual, nothing contained in this e-mail is intended to create binding legal obligations between us and opinions expressed are those of the individual author. The CIS marketing group, which is regulated for Investment Business by the Financial Services Authority, includes: Co-operative Insurance Society Limited Registered in England number 3615R - for life assurance and pensions CIS Unit Managers Limited Registered in England and Wales number 2369965 - for unit trusts and PEPs CIS Policyholder Services Limited Registered in England and Wales number 3390839 - for ISAs and investment products bearing the CIS name Registered offices: Miller Street, Manchester M60 0AL Telephone 0161-832-8686 Internet http://www.cis.co.uk E-mail [EMAIL PROTECTED] CIS Deposit and Instant Access Savings Accounts are held with The Co-operative Bank p.l.c., registered in England and Wales number 990937, P.O. Box 101, 1 Balloon Street, Manchester M60 4EP, and administered by CIS Policyholder Services Limited as agent of the Bank. CIS is a member of the General Insurance Standards Council CIS & the CIS logo (R) Co-operative Insurance Society Limited ********************************************************************************