$)C $)C
Did you try specifying a valid sql userid and password?
For example:
sqldsmc /backupfull:* /SQLUSer:userid /SQLPWD:password
The default is "sa" for /SQLUSER and "" (blank) for SQLPWD.
Also, if this is running on a cluster, specify "/SQLSERVER=sqlservername".
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
1h@N?1
<iykim@CDDATA. To: ADSM-L AT VM.MARIST DOT EDU
CO.KR> cc:
Sent by: Subject: tsm sql error messages
"ADSM: Dist
Stor Manager"
<ADSM-L AT VM DOT MAR
IST.EDU>
05/17/2001
08:20 AM
Please respond
to "ADSM: Dist
Stor Manager"
Please check following error messages and give me an advice..
Thanks in advance..
C:\Program Files\Tivoli\TSM\MSSQL>sqldsmc /backupfull:*
Tivoli Storage Manager
Tivoli Data Protection for Microsoft SQL Server - Version 1, Release 1,
Level 2
(C) Copyright IBM Corporation 1997, 1999. All rights reserved.
TSM API Version 3, Release 7, Level 2
TSM Nodename: dongbu_sql
License file exists and contains valid license data.
Please enter the TSM password for node dongbu_sql:
**********
Logging on to the TSM server...
Logging on to the SQL server...
ACO4210E -- Failed to connect to SQL server.
* gui =GG`=C error meg.
05/17/2001 15:49:54,ACO4210E -- Failed to connect to SQL server.
05/17/2001 17:06:28,
=======================================================================
05/17/2001 17:06:41,Backed up - master, type: DB, size: 9115730, actual
bytes: 0, secs: 0.0, Kb/Sec: 0.0, SQL server: DONGBUCHEM, TSM server: dsm,
SQL status: DB-LIB message: Backup or restore operation terminating
abnormally., TSM status: ANS1303E (RC3) Client ended transaction
05/17/2001 17:06:49,Backed up - model, type: DB, size: 1195785, actual
bytes: 0, secs: 0.0, Kb/Sec: 0.0, SQL server: DONGBUCHEM, TSM server: dsm,
SQL status: DB-LIB message: Backup or restore operation terminating
abnormally., TSM status: ANS1303E (RC3) Client ended transaction
05/17/2001 17:06:56,Backed up - msdb, type: DB, size: 9758679, actual
bytes: 0, secs: 0.0, Kb/Sec: 0.0, SQL server: DONGBUCHEM, TSM server: dsm,
SQL status: DB-LIB message: Backup or restore operation terminating
abnormally., TSM status: ANS1303E (RC3) Client ended transaction
05/17/2001 17:07:03,Backed up - pubs, type: DB, size: 1900911, actual
bytes: 0, secs: 0.0, Kb/Sec: 0.0, SQL server: DONGBUCHEM, TSM server: dsm,
SQL status: DB-LIB message: Backup or restore operation terminating
abnormally., TSM status: ANS1303E (RC3) Client ended transaction
05/17/2001 17:07:10,Backed up - Northwind, type: DB, size: 3630701, actual
bytes: 0, secs: 0.0, Kb/Sec: 0.0, SQL server: DONGBUCHEM, TSM server: dsm,
SQL status: DB-LIB message: Backup or restore operation terminating
abnormally., TSM status: ANS1303E (RC3) Client ended transaction
05/17/2001 17:07:17,Backed up - dongbu, type: DB, size: 28189377, actual
bytes: 0, secs: 0.0, Kb/Sec: 0.0, SQL server: DONGBUCHEM, TSM server: dsm,
SQL status: DB-LIB message: Backup or restore operation terminating
abnormally., TSM status: ANS1303E (RC3) Client ended transaction
05/17/2001 17:07:24,Backed up - Zipcode, type: DB, size: 7070730, actual
bytes: 0, secs: 0.0, Kb/Sec: 0.0, SQL server: DONGBUCHEM, TSM server: dsm,
SQL status: DB-LIB message: Backup or restore operation terminating
abnormally., TSM status: ANS1303E (RC3) Client ended transaction
05/17/2001 17:07:43,ACO2589E -- The specified database objects are not
available on the selected TSM server (dsm).
05/17/2001 17:11:33,
=======================================================================
05/17/2001 17:11:33,COMMAND LINE : sqldsmc /backupfull:*
05/17/2001 17:11:44,Logging on to the TSM server...
|