Hi Del! Wow!! Could it really be that easy?!?! I have raised the commtimeout to 3600 and I will ask the SQL Server guys to retry the restore. Thank you very much!!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines
-----Original Message----- From: Del Hoobler [mailto:[EMAIL PROTECTED] Sent: Monday, April 19, 2004 15:58 To: [EMAIL PROTECTED] Subject: Re: SQL Server restore fails (5.2.1.0) Eric, Go to: www.ibm.com Search for: +TDP +SQL +ANS1017E Thanks, Del ---------------------------------------------------- "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 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 ********************************************************************** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **********************************************************************