ADSM-L

Re: tsm sql error messages

2001-05-17 11:31:08
Subject: Re: tsm sql error messages
From: Del Hoobler <hoobler AT US.IBM DOT COM>
Date: Thu, 17 May 2001 11:31:06 -0400
$)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...
<Prev in Thread] Current Thread [Next in Thread>