Thanks Del.

Problem with MAXMUMMP.  Fixed now.

However I now get the following:


24-02-2003 13:23:50 ACO5456W The backup is corrupt and is not fully
restorable.
24-02-2003 13:23:50 Processing will continue.
24-02-2003 13:23:50 ACO0302E A failure occured on stripe number (3), rc =
428
24-02-2003 13:23:50 ACO5407E The SQL server aborted the operation.
24-02-2003 13:23:50 ACO0302E A failure occured on stripe number (2), rc =
428
24-02-2003 13:23:50 ACO5407E The SQL server aborted the operation.
24-02-2003 13:23:54 ACO0302E A failure occured on stripe number (0), rc =
428
24-02-2003 13:23:54 ACO5407E The SQL server aborted the operation.
24-02-2003 13:24:54 ACO0302E A failure occured on stripe number (1), rc =
428
24-02-2003 13:24:54 ACO5407E The SQL server aborted the operation.
24-02-2003 13:24:55 ACO5407E The SQL server aborted the operation.
24-02-2003 13:24:55 Restore of PrecisePW failed.
24-02-2003 13:24:55 ACO5407E The SQL server aborted the operation.
24-02-2003 13:24:55 Total database backups inspected:               1
24-02-2003 13:24:55 Total database backups requested for restore:   1
24-02-2003 13:24:55 Total database backups restored:                0
24-02-2003 13:24:55 Total database skipped:                         0
24-02-2003 13:24:55 Throughput rate:                                0.00
Kb/Sec
24-02-2003 13:24:55 Total bytes transferred:                        0
24-02-2003 13:24:55 Elapsed processing time:                        65.02
Secs
24-02-2003 13:24:55 ACO0151E Errors occurred while processing the request.


I'm talk to  my SQL DBA tells me that the test restore worked before the
data was migrated to tape.

Any ideas?

Thanks in advance.



   ________________________________
    Rizwan Shamim
    Central Backup Service (CBS)
    Merrill Lynch Europe PLC
    Tel: 020 7995 1176
    Mobile:     0787 625 8246
    mailto:rizwan_shamin AT ml DOT com

    For very important information relating to this e-mail please click on
this link: http://www.ml.com/legal_info.htm


> -----Original Message-----
> From: Del Hoobler [SMTP:hoobler AT US.IBM DOT COM]
> Sent: Thursday, February 20, 2003 7:27 PM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Re: FW: TDP SQL Restore Error
>
> Rizwan,
>
> RC=418 means there was a problem with the TSM API.
>
> Take a look at the TSM Server activity log to see
> why it terminated the sessions.  It could be that
> the volumes were not available or there were not
> enough mountpounts defined to satisfy the request.
> ... Or MAXNUMMP was not set high enough to fulfill
> the multiple stripe restore request.
>
> If you cannot figure out what the problem is,
> please calll IBM support.
>
> Thanks,
>
> Del
>
> ----------------------------------------------------
>
> Del Hoobler
> IBM Corporation
> hoobler AT us.ibm DOT com
>
> - Remember that the best job security is
> doing a job well and doing it cheerfully.
>
> > I'd be grateful if someone could shed some ligh on this:
> >
> >
> > 18-02-2003 16:15:43 ACO0302E A failure occured on stripe number (4), rc
> =
> > 418
> > 18-02-2003 16:15:43 ANS1017E (RC-50)  Session rejected: TCP/IP
> connection
> > failure
> > 18-02-2003 16:15:43 ACO0302E A failure occured on stripe number (0), rc
> =
> > 418
> > 18-02-2003 16:15:43 ANS1017E (RC-50)  Session rejected: TCP/IP
> connection
> > failure