John, Yes. I know what the problem is. The answer can be found in the IBM Knowledge Base.Go here:
http://www-3.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManagerforDatabases.html and search for "ANS1017E". It will come up with 1 hit.. reference# 1114216. In a nutshell... you need to increase the COMMTIMEOUT value on your TSM Server to allow the SQL Server time to preformat the database. Thanks, Del ---------------------------------------------------- > 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 > 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
