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
