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@VM.MARIST.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:[EMAIL PROTECTED] > Sent: Thursday, April 28, 2005 17:04 > To: ADSM-L@VM.MARIST.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@VM.MARIST.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