ADSM-L

TDP for SQL issues

2003-04-29 12:28:40
Subject: TDP for SQL issues
From: "Gill, Geoffrey L." <GEOFFREY.L.GILL AT SAIC DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 29 Apr 2003 07:43:02 -0700
Below is a problem I have noticed on one of the SQL servers we have. This
server started out on the original ADSM connect agent for SQL and has be
upgraded over the years.



Environment:

TSM Server 5.1.6.3 on AIX 4.3.3

Client has TSM V5.1.5.15 and TDP SQL 5.1.5.0

Client is NT4 SP6a



I can look through the GUI and see all active and inactive versions so it
looks like it is being backed up. I have no way of knowing if the DB's are
any good at the moment since I do not have a server to restore to test.



A snippet of logs on each environment:



35 of these entries in the TSM Server log each night the backup runs:

ANR9999D smnode.c(7073): ThreadId<63> Error receiving EventLog Verb -
invalid data type, 21300, received for

event number 4991 from node (TDP MSSQL)S-CP-ITS-TAX01.



Sqlfull.log:

04/29/2003 03:41:30 Total SQL backups selected:               16

04/29/2003 03:41:30 Total SQL backups attempted:              16

04/29/2003 03:41:30 Total SQL backups completed:              16

04/29/2003 03:41:30 Total SQL backups excluded:               0

04/29/2003 03:41:30 Total SQL backups inactivated:            0

04/29/2003 03:41:30 Throughput rate:                          5,703.21
Kb/Sec

04/29/2003 03:41:30 Total bytes transferred:                  726,951,168

04/29/2003 03:41:30 Elapsed processing time:                  124.48 Secs



The only new entry in the sqldailyerror.log:

04/28/2003 15:36:04 ConsoleEventHandler(): Caught Logoff console event .

04/28/2003 15:36:04 ConsoleEventHandler(): Process Detached.



There are no new entries in the tdpsqlerror.log.

Geoff Gill
TSM Administrator
NT Systems Support Engineer
SAIC
E-Mail:   gillg AT saic DOT com
Phone:  (858) 826-4062
Pager:   (877) 905-7154

<Prev in Thread] Current Thread [Next in Thread>