Eric,

Go to:

   www.ibm.com

Search for:

   +TDP +SQL +ANS1017E

Thanks,

Del

----------------------------------------------------

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 04/19/2004
08:50:59 AM:

> Hi *SM-ers!
> Our SQL Server guys are migrating several databases to a new server by
using
> a TSM backup. Most database restores went fine, except for one.
> My conclusion is that the TSM server cancels the session after waiting
for 3
> hours, but I cannot find why the restore doesn't work for this database
> only.
>
> They performed the following actions to accomplish the migration:
> 1) The changed the tdpsql.cfg:
> FROMSQLserver  af05100
> SQLSERVer kl1007w9
> 2) They changed the dsm.opt
> nodename    af05100-sql
> PasswordAccess   prompt
> 3) They started the restore through the GUI
> 4) They entered the TSM password and selected the databases to restore.
> 5) All were restored, except for one. They repeated the action for this
> database only: same result.
> I've had them collect the following data:
>
> DSIERROR.LOG:
> 04/19/2004 00:13:56 ANS1005E TCP/IP read error on socket = 824, errno =
> 10054, reason : 'An existing connection was forcibly closed by the
remote
> host.'.
> 04/19/2004 00:13:56 sessRecvVerb: Error -50 from call to 'readRtn'.
>
> TDPSQL.LOG:
> 04/19/2004 00:13:56 ACO5436E A failure occurred on stripe number (0), rc
=
> 418
> 04/19/2004 00:13:56 ANS1017E (RC-50)  Session rejected: TCP/IP
connection
> failure
> 04/19/2004 00:13:57 Restore of Test failed.
> 04/19/2004 00:13:57 ANS1017E (RC-50)  Session rejected: TCP/IP
connection
> failure
>
> Windows Event Log:
> 4/19/2004       00:13:56        MSSQLSERVER     Error   (2)     17055
> KL1007W9\ntdbadm        KL1007W9        18210 :
> BackupVirtualDeviceFile::ClearError:  failure on backup device
> 'TDPSQL-00000BB4-0000'. Operating system error 995(The I/O operation has
> been aborted because of either a thread exit or an application
request.).
>
> SQL Server error log:
> 2004-04-18 21:43:09.82 spid53    Unnamed tape (Family ID: 0xb48c3f90,
> sequence 1) mounted on tape drive 'TDPSQL-00000BB4-0000'.
> 2004-04-19 00:13:56.85 spid53    BackupVirtualDeviceFile::ClearError:
> failure on backup device 'TDPSQL-00000BB4-0000'. Operating system error
> 995(The I/O operation has been aborted because of either a thread exit
or an
> application request.).
>
> TSM Server log:
> 18-04-2004 21:43:09 ANE4991I (Session: 446380, Node: AF05100-SQL)  TDP
MSSQL
> Win32 ACO3003 Data Protection for SQL: Starting full restore of backup
> object Test to database Test on server KL1007W9.
> 18-04-2004 22:13:27 ANR0481W Session 446380 for node AF05100-SQL (TDP
MSSQL
> Win32) terminated - client did not respond within 1800 seconds.
>
> Kindest regards,
> Eric van Loon
> KLM Royal Dutch Airlines