$)C
Hello,
A few things to check...
Make sure the SQL userid "sa" has the Sysadmin fixed server role.
It appears that you are using "sa" because your command line entry
does not show you using /SQLSECURE option (for Windows authentication)
or the /SQLUSER and /SQLPWD options for entering alternate SQL
ids/passwords.
Also, make sure you are running at least 1.1.2 of TDP for SQL.
(The latest version is are available from "ftp.software.ibm.com" in
directory
/storage/tivoli-storage-management/maintenance/tivoli-data-protection/ntsql/1.1.2.)
I would also recommend that you take a look at TDP for SQL version 2.
It has many new features including the two big ones of taking advantage
of standard TSM policy management (no more deleting old backups)
and SQL 2000 support.
Other than that, you should open a problem with IBM service.
A trace will help the service team determine what is going wrong.
Thanks,
Del
----------------------------------------------------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
1h@N?1
<iykim@CDDATA. To: [EMAIL PROTECTED]
CO.KR> cc:
Sent by: Subject: sql error
"ADSM: Dist
Stor Manager"
<[EMAIL PROTECTED]
IST.EDU>
02/07/2001
04:26 AM
Please respond
to "ADSM: Dist
Stor Manager"
Can anybody know how it works??
Please check this out and give me a clear answer..
Thanks in advance..
05/31/2001 11:58:46,COMMAND LINE : sqldsmc /backupfull:*
/adsmnode:donghwa_sql /adsmpwd:donghwa_sql /logfile:c:
\progra~1\tivoli\tsm\mssql\sql.log /logprune:14
05/31/2001 11:58:46,Logging on to the TSM server...
05/31/2001 11:58:46,Logging on to the SQL server...
05/31/2001 12:00:43,Backed up - master, type: DB, size: 9927909, actual
bytes: 0, secs: 0.00, Kb/Sec: 0.00, SQL server: APTDOMAIN, TSM server: dsm,
SQL status: DB-LIB message: Backup or restore operation terminating
abnormally.
, TSM status: ANS1303E (RC3) Client ended transaction
05/31/2001 12:00:50,Backed up - model, type: DB, size: 1272831, actual
bytes: 0, secs: 0.00, Kb/Sec: 0.00, SQL server: APTDOMAIN, TSM server: dsm,
SQL status: DB-LIB message: Backup or restore operation terminating
abnormally.
, TSM status: ANS1303E (RC3) Client ended transaction
05/31/2001 12:00:57,Backed up - msdb, type: DB, size: 9722633, actual
bytes: 0, secs: 0.00, Kb/Sec: 0.00, SQL server: APTDOMAIN, TSM server: dsm,
SQL status: DB-LIB message: Backup or restore operation terminating
abnormally.
, TSM status: ANS1303E (RC3) Client ended transaction
05/31/2001 12:01:05,Backed up - pubs, type: DB, size: 1704017, actual
bytes: 0, secs: 0.00, Kb/Sec: 0.00, SQL server: APTDOMAIN, TSM server: dsm,
SQL status: DB-LIB message: Backup or restore operation terminating
abnormally.
, TSM status: ANS1303E (RC3) Client ended transaction
05/31/2001 12:01:12,Backed up - Northwind, type: DB, size: 3710811, actual
bytes: 0, secs: 0.00, Kb/Sec: 0.00, SQL server: APTDOMAIN, TSM server: dsm,
SQL status: DB-LIB message: Backup or restore operation terminating
abnormally.
, TSM status: ANS1303E (RC3) Client ended transaction
05/31/2001 12:01:19,Backed up - sintra, type: DB, size: 20006305, actual
bytes: 0, secs: 0.00, Kb/Sec: 0.00, SQL server: APTDOMAIN, TSM server: dsm,
SQL status: DB-LIB message: Backup or restore operation terminating
abnormally.
, TSM status: ANS1303E (RC3) Client ended transaction
05/31/2001 12:01:26,Backed up - aptbank, type: DB, size: 1391597093, actual
bytes: 0, secs: 0.00, Kb/Sec: 0.00, SQL server: APTDOMAIN, TSM server: dsm,
SQL status: DB-LIB message: Backup or restore operation terminating
abnormally.
, TSM status: ANS1303E (RC3) Client ended transaction
