Re: TDP for SQL 1.1.2

Bruce,

Officially, TDP for SQL 1.1.2 is supported
only on SQL 6.5 and SQL 7. See:

    http://www.tivoli.com/support/storage_mgr/tdp_ms.html#SQL

SQL 2000 support was added with TDP for SQL 2.2.0 early this year.
Version 2 added a whole lot of new function.  See:

   http://www.tivoli.com/products/index/data_protect_mssql/index.html

We have tested TDP for SQL 2.2.0 with SQL 2000 active/active in a
Windows 2000 cluster with no problems.


Interestingly, your query filespace output shows that
you have successfully backed up the "consigment" and
the "dbadmin" databases to this node on 7/10/2000.
How were you able to do that?

To get around this problem you could remove the
CLUSTERNODE YES option from the options file
but your generated password may not work properly
in a cluster failover situation.

You could try calling IBM/Tivoli service.
A trace would help.... not sure how far you'd get since
your not running in a supported environment.

Thanks,

Del

----------------------------------------------------
Del Hoobler
Del Hoobler
IBM Corporation
hoobler AT us.ibm DOT com

"It's a beautiful day.  Don't let it get away."  -- Bono




                    Bruce Lowrie
                    <b.e.lowrie@DOWCO       To:     ADSM-L AT VM.MARIST DOT EDU
                    RNING.COM>              cc:
                    Sent by: "ADSM:         Subject:     Re: TDP for SQL 1.1.2
                    Dist Stor
                    Manager"
                    <[email protected]
                    .EDU>


                    07/12/2001 04:53
                    PM
                    Please respond to
                    "ADSM: Dist Stor
                    Manager"





Del,

This is a 2 node Windows 2000 Cluster and the cluster service is running.
When we run "dsmc query filespace" program with the same dsmsql.opt we do
not get the same error (it actually works since we can use the gui to
backup):
Node Name: DCLABVDB80
Session established with server ADSMSV2: AIX-RS/6000
  Server Version 4, Release 1, Level 2.0
  Server date/time: 07/12/2001 16:35:40  Last access: 07/12/2001 08:54:05

Num     Last Incr Date      Type    File Space Name
---     --------------      ----    ---------------
  1   07/10/2001 16:09:29   API:NTSQL  DCLABVDB80.consigment
  1   07/10/2001 16:09:29   API:NTSQL  DCLABVDB80.consigment
  2   07/10/2001 16:09:08   API:NTSQL  DCLABVDB80.dbadmin
  3   07/11/2001 20:54:02   NTFS    \\dclabcdb80\i$

Results from running "sqldsmc /adsmqueryserver":

Tivoli Storage Manager
Tivoli Data Protection for Microsoft SQL Server
Command Line Interface - Version 1, Release 1, Level 2.01
(C) Copyright IBM Corporation 1997, 1999. All rights reserved.

TSM API Version 4, Release 1, Level 2
TSM Nodename: client

License file exists and contains valid license data.

Server      Options
-----------------------------------------------------------------------
dsmsql      Nodename          dclabvdb80
dsmsql      Nodename          dclabvdb80
            Cluster Node      Yes
            Compression       Off
            PasswordAccess    Generate
            WaitMount         True
            CommMethod        TCP/IP
            TcpServerAddress  adsmsv2eth
            TcpPort           1500


Bruce E. Lowrie