ADSM-L

SQL Restore Fails

2003-09-25 14:19:44
Subject: SQL Restore Fails
From: John Stephens <jws AT STEPHENS DOT NET>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 25 Sep 2003 14:17:03 -0400
I am attempting to restore a 90 gig SQL database to a test server ( not the 
original location).
The Restore will start and I will have disk activity but then it will stop and 
generate a TCPIP connection failure,

09/25/2003 11:30:03 Request                       :  RESTORE
09/25/2003 11:30:03 Database Input List           : -
09/25/2003 11:30:03 Object Input List             : -
09/25/2003 11:30:03 Group Input List              : -
09/25/2003 11:30:03 File Input List               : -
09/25/2003 11:30:03 Log or Set Input List         : -
09/25/2003 11:30:03 Into Input List               : -
09/25/2003 11:30:03 Undo File                     : -
09/25/2003 11:30:03 Relocate Input List           : -
09/25/2003 11:30:03 To Input List                 : -
09/25/2003 11:30:03 Include Inactive Files?       : Yes
09/25/2003 11:30:03 Number of Buffers             : 3
09/25/2003 11:30:03 Buffer Size                   : 1024
09/25/2003 11:30:03 Number of SQL Buffers         : 0
09/25/2003 11:30:03 SQL Buffer Size               : 1024
09/25/2003 11:30:03 Number of Stripes specified   : 1
09/25/2003 11:30:03 Wait for Tape Mounts?         : Yes
09/25/2003 11:30:03 DateTime                      : -
09/25/2003 11:30:03 MarkName                      : -
09/25/2003 11:30:03 After                         : -
09/25/2003 11:30:03 Recovery                      : Yes
09/25/2003 11:30:03 Replace                       : Yes
09/25/2003 11:30:03 Restricted User Only?         : Yes
09/25/2003 11:30:03 Partial?                      : -
09/25/2003 11:30:03 TSM Options File              : C:\Program 
Files\Tivoli\TSM\TDPSql\dsm.opt
09/25/2003 11:30:03 TSM Nodename Override         : -
09/25/2003 11:30:03 Fromsqlserver                 : HQSAPPRO
09/25/2003 11:30:03 Sqlserver                     : MACSAPTST
09/25/2003 11:30:03   
09/25/2003 12:46:22 ACO5436E A failure occurred on stripe number (0), rc = 418
09/25/2003 12:46:22 ANS1017E (RC-50)  Session rejected: TCP/IP connection 
failure
09/25/2003 12:46:23 Restore of PRO failed.
09/25/2003 12:46:23 ANS1017E (RC-50)  Session rejected: TCP/IP connection 
failure
09/25/2003 12:46:23 Total database backups inspected:               1
09/25/2003 12:46:23 Total database backups requested for restore:   1
09/25/2003 12:46:23 Total database backups restored:                0
09/25/2003 12:46:23 Total database skipped:                         0
09/25/2003 12:46:23 Throughput rate:                                0.67 Kb/Sec
09/25/2003 12:46:23 Total bytes transferred:                        3,145,728
09/25/2003 12:46:23 Elapsed processing time:                        4,580.04 
Secs
09/25/2003 12:46:23 ACO0151E Errors occurred while processing the request. 

Does anyone have any ideas , what is causing this? I am using the latest SQLTDP 
5.1.5.15, I have upgraded the B/A client to the latest 5.2 version, hope this 
is not causing the problem.
I have increased the TSM server's commtimeout to 1800 ( 30 minutes) and it does 
not change a thing.

Thanks for your help


John Stephens
www.Storserver.com 

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