ADSM-L

Re: TDP for SQL restore seems to hang

2005-04-28 10:25:57
Subject: Re: TDP for SQL restore seems to hang
From: "Stapleton, Mark" <mark.stapleton AT BERBEE DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 28 Apr 2005 09:25:41 -0500
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On 
Behalf Of Loon, E.J. van - SPLXM
>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.

This has been discussed before in this forum.

When you restore a large SQL file, the first thing the restore requires
is that the space for the restore be formated by SQL Server. After the
format is complete, data starts to flow to the client.

If the commtimeout occurs before the formatting is complete, the backup
fails.

Bump your commtimeout parameter up and see if that fixes the issue.

--
Mark Stapleton (stapleton AT berbee DOT com)
IBM Certified Advanced Deployment Professional
Tivoli Storage Management Solutions 2005
Office 262.521.5627  

<Prev in Thread] Current Thread [Next in Thread>