Thanks for that clear and concise explanation. It appears that is exactly what is happening. After 40 - 45 minutes the actual restore part of it started and it has now restored 3 Gb of the database.
Paul Dudley ANL IT Operations Dept. > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On > Behalf Of David Longo > Sent: Thursday, 28 June 2007 11:49 AM > To: [email protected] > Subject: Re: [ADSM-L] TDP for SQL restore question > > Maybe DB was smaller when you restored to D drive, or D is faster disk than E. > > For this size you need bigger timeout, I have COMMTIMEOUT on > TSM server set to 15,000 seconds (250 minutes) > > What is happening is that SQL (not TSM) is building the DB > for the data to be restored to. If it was only say 5GB, you would barely notice. > When DB is built, then the restore starts flying! > > David Longo > > >>> Paul Dudley <[EMAIL PROTECTED]> 6/27/2007 9:41 PM >>> > I am currently trying to restore a database from our production server > onto the E drive of a test server. > > I have previously been able to restore a database from our production > server onto the D drive of the test server. > > The database is 40 Gb in size. > > When I have tried this previously the session has timed out after 5 > minutes. I have increased the idle time out to 120 minutes. > > It is currently trying to restore and the output from the "q sess" > command shows that 3.2 Mb of bytes have been sent. This amount of bytes > was sent in the first minute of the restore session after the tape was > mounted. Since then it has stayed at 3.2 Mb for the past 35 minutes. The > session state according to "q sess" is SendW. > > The load on the client server is quite low - between 1% and 5%. There is > more than enough disk space to restore the database. I have checked > Enterprise Manager and there is not much activity on the server. > > There are no other processes running on the TSM server. > > If this session times out and the restore fails after 120 minutes how > can I work out why this has happened? Is there anything I can do to make > it work? As stated above I have been able to restore the same sized > database onto the D drive of the same client server. > > Thanks > Paul > > > > Paul Dudley > ANL IT Operations Dept. > ANL Container Line > [EMAIL PROTECTED] > > > > > > ANL - CELEBRATING 50 YEARS > > ANL DISCLAIMER > This e-mail and any file attached is confidential, and intended solely to the > named addressees. Any unauthorised dissemination or use is strictly > prohibited. If you received this e-mail in error, please immediately notify the > sender by return e-mail from your system. Please do not copy, use or make > reference to it for any purpose, or disclose its contents to any person. ANL - CELEBRATING 50 YEARS ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
