ADSM-L

Re: sql error

2001-05-31 09:41:02
Subject: Re: sql error
From: Del Hoobler <hoobler AT US.IBM DOT COM>
Date: Thu, 31 May 2001 09:41:48 -0400
 $)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
Del Hoobler
IBM Corporation
hoobler AT us.ibm DOT com

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




                     [email protected]?1
                    <[email protected]       To:     ADSM-L AT VM.MARIST DOT EDU
                    CO.KR>               cc:
                    Sent by:             Subject:     sql error
                    "ADSM: Dist
                    Stor Manager"
                    <ADSM-L AT VM DOT MAR
                    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
<Prev in Thread] Current Thread [Next in Thread>
  • sql error, 김인엽
    • Re: sql error, Del Hoobler <=