ADSM-L

TDP Sql Failures

2003-02-07 10:02:17
Subject: TDP Sql Failures
From: "Gill, Geoffrey L." <GEOFFREY.L.GILL AT SAIC DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 7 Feb 2003 07:00:44 -0800
Recently I upgraded to TDP SQL 5.1 on a SQL server. Once I figured out the
command line differences to get the command file to work they seemed to run
fine. Two days ago I started receiving a failure notification on the
backups, which looks like one of the databases is corrupt.

This particular client is running 5.1.5.2 TSM, on NT4 SP6 TDP SQL 5.1..5.0.
The only thing that has happened is the SQL PS4 was applied the day before
the failures started to occur and the software that uses this database was
applied after the SQL Update. Now neither gave any indication of problems
during their respective upgrades but it almost looks like something must
have gone wrong.

The error reports "backup of insite failed". Could anyone tell me if it's
possible to just restore that database to a known good point, even if it was
before the SQL upgrade and upgrade of the software that uses the database?
Or will I have to restore all databases  to a known good point on the same
day. We have never had to mess with a restore, thankfully, and not since I
don't know much about how it works. Unfortunately I have no test SQL server
to run this on.

This is from last night. The previous sucessful backups reported 16

02/07/2003 03:08:41 ============== Log file pruned using log retention
period of 60 day(s)
02/07/2003 03:08:41 ============== 122 out of 3191 entries pruned from the
top of this log
02/07/2003 03:08:43
=========================================================================
02/07/2003 03:08:46
=========================================================================
02/07/2003 03:08:46 Request : FULL BACKUP
02/07/2003 03:08:46 Database Input List : *
02/07/2003 03:08:46 Group Input List : -
02/07/2003 03:08:46 File Input List : -
02/07/2003 03:08:46 Number of Buffers : 3
02/07/2003 03:08:46 Buffer Size : 1024
02/07/2003 03:08:46 Number of SQL Buffers : 0
02/07/2003 03:08:46 SQL Buffer Size : 1024
02/07/2003 03:08:46 Number of Stripes specified : 1
02/07/2003 03:08:46 Estimate : -
02/07/2003 03:08:46 Truncate Log? : -
02/07/2003 03:08:46 Wait for Tape Mounts? : Yes
02/07/2003 03:08:46 TSM Options File : dsm.opt
02/07/2003 03:08:46 TSM Nodename Override : -
02/07/2003 03:08:46 Sqlserver : CP-ITS-TAX01
02/07/2003 03:08:46
02/07/2003 03:09:21 ACO5436E A failure occurred on stripe number (0), rc =
115
02/07/2003 03:09:21 (RC155)
02/07/2003 03:09:21 Backup of insite failed.
02/07/2003 03:09:21 (RC155)
02/07/2003 03:10:31 Total SQL backups selected: 16
02/07/2003 03:10:31 Total SQL backups attempted: 16
02/07/2003 03:10:31 Total SQL backups completed: 15
02/07/2003 03:10:31 Total SQL backups excluded: 0
02/07/2003 03:10:31 Total SQL backups inactivated: 0
02/07/2003 03:10:31 Throughput rate: 5,678.68 Kb/Sec
02/07/2003 03:10:31 Total bytes transferred: 566,017,520
02/07/2003 03:10:31 Elapsed processing time: 97.34 Secs
02/07/2003 03:10:31 ACO0151E Errors occurred while processing the request.
02/07/2003 03:10:31 ACO0151E Errors occurred while processing the request.

Thanks for the help.

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>