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
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
Bruce Lowrie
<b.e.lowrie@DOWCO To: [EMAIL PROTECTED]
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
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
Cluster Node Yes
Compression Off
PasswordAccess Generate
WaitMount True
CommMethod TCP/IP
TcpServerAddress adsmsv2eth
TcpPort 1500
Bruce E. Lowrie
