Re: SQL Server restore fails (184.108.40.206)
+TDP +SQL +ANS1017E
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 04/19/2004
> Hi *SM-ers!
> Our SQL Server guys are migrating several databases to a new server by
> a TSM backup. Most database restores went fine, except for one.
> My conclusion is that the TSM server cancels the session after waiting
> hours, but I cannot find why the restore doesn't work for this database
> 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:
> 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
> 04/19/2004 00:13:56 sessRecvVerb: Error -50 from call to 'readRtn'.
> 04/19/2004 00:13:56 ACO5436E A failure occurred on stripe number (0), rc
> 04/19/2004 00:13:56 ANS1017E (RC-50) Session rejected: TCP/IP
> 04/19/2004 00:13:57 Restore of Test failed.
> 04/19/2004 00:13:57 ANS1017E (RC-50) Session rejected: TCP/IP
> 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
> 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
> application request.).
> TSM Server log:
> 18-04-2004 21:43:09 ANE4991I (Session: 446380, Node: AF05100-SQL) TDP
> 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
> Win32) terminated - client did not respond within 1800 seconds.
> Kindest regards,
> Eric van Loon
> KLM Royal Dutch Airlines