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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Loon, E.J. van - SPLXM
Sent: 28 April 2005 15:17
To: ADSM-L AT VM.MARIST DOT 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.