How big is very big? If we're talking very large, what happens during a restore is that it will appear to 'hang' whilst MSSQL server formats the volumes it needs. This is nothing to do with TSM, which will only kick into action when MSSQL server has finished formatting its volumes. If you've a big database, and slow disks, this might take a while... Up your timeout, monitor activity on your SQL server and try again...
Rgds, David McClelland Tivoli Storage Manager Certified Consultant Infrastructure Backup and Recovery Development Shared Infrastructure Development Reuters 85 Fleet Street London EC4P 4AJ -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Loon, E.J. van - SPLXM Sent: 28 April 2005 15:17 To: ADSM-L@VM.MARIST.EDU Subject: TDP for SQL restore seems to hang Importance: High Hi *SM-ers! I have a few SQL clients which seem to "hang" when trying to restore a large database. Restoring a small one (Northwind) works fine, but when they want to restore a larger database TDP just says "Waiting for TSM server.." and nothing else happens until the session is cancelled by the server after 3600 seconds. The client has a session in the SendW state, but the amount of bytes transferred is minimal. The input tape also gets mounted. The actlog just contains the following lines: 28-04-2005 13:18:11 ANE4991I (Session: 714765, Node: KL1012EZ-SQL) TDP MSSQL Win32 ACO3003 Data Protection for SQL: Starting full restore of backup object SCReport to database SCReport on server KL1012EZ. (SESSION: 714765) 28-04-2005 14:20:04 ANR0481W Session 714765 for node KL1012EZ-SQL (TDP MSSQL Win32) terminated - client did not respond within 3600 seconds. (SESSION: 714765) The tdpsql.log also doesn't show any cause, just that the restore is canceled due to the session cancel by the server: 04/28/2005 15:19:25 ACO5436E A failure occurred on stripe number (0), rc = 418 04/28/2005 15:19:25 ANS1017E (RC-50) Session rejected: TCP/IP connection failure 04/28/2005 15:19:26 Restore of SCReport failed. Does anybody know how I can find out why the restore is not working? Thanks in advance! 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. ********************************************************************** ----------------------------------------------------------------- Visit our Internet site at http://www.reuters.com To find out more about Reuters Products and Services visit http://www.reuters.com/productinfo Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Reuters Ltd.
