ADSM-L

Re: TDP for SQL restore seems to hang

2005-04-29 08:32:43
Subject: Re: TDP for SQL restore seems to hang
From: "Loon, E.J. van - SPLXM" <Eric-van.Loon AT KLM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 29 Apr 2005 14:32:57 +0200
Hi Del!
I will. We discovered that restoring an older backup on this client did
work, but when we tried to restore the most recent one again, we saw the
same behavior again...
I will create a PMR, however, I have to find a pc with IE6 first, because
ESR doesn't seem to like my browser version ;-(
Thanks for your help Del!
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines


-----Original Message-----
From: Del Hoobler [mailto:hoobler AT US.IBM DOT COM]
Sent: Friday, April 29, 2005 14:22
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: TDP for SQL restore seems to hang


Eric,

I agree that it should not take more than 1 hour to preformat
a 500MB database. I would suggest placing a call with
IBM Service. They can look at the trace and figure out what
is going on.

Thanks,

Del

----------------------------------------------------

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 04/29/2005
04:09:13 AM:

> Hi Dell!
> No, it's not Lanfree.
> Is formatting a 500 Mb. database something that should take more than an
> hour???
> Kindest regards,
> Eric van Loon
> KLM Royal Dutch Airlines
>
>
> -----Original Message-----
> From: Del Hoobler [mailto:hoobler AT US.IBM DOT COM]
> Sent: Thursday, April 28, 2005 17:04
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: TDP for SQL restore seems to hang
>
>
> Eric,
>
> These are the exact symptoms that happen when the SQL Server hasn't
> completed the format. Is this LANFREE my chance? If so, you need to
> change the COMMTIMEOUT on the Storage Agent as well. If not,
> I recommend bumping up the COMMTIMEOUT value to something even
> higher to see if it resolves the problem. If not, a Data Protection
> for SQL trace will help the IBM Service team determine where
> the problem is... but... I really think this is the problem.
>
> Thanks,
>
> Del
>
> ----------------------------------------------------
>
> "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 04/28/2005
> 10:46:47 AM:
>
> > Hi Mark and David!
> > Thank you very much for your reply!
> > The database they are trying to restore is about 500 Mb., so
formatting
> > should easily be done in one hour...
> > 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.
**********************************************************************

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