ADSM-L

Re: [ADSM-L] TDP for SQL restore question

2007-06-27 22:01:28
Subject: Re: [ADSM-L] TDP for SQL restore question
From: Paul Dudley <pdudley AT ANL.COM DOT AU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 28 Jun 2007 12:02:53 +1000
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:ADSM-L AT VM.MARIST DOT EDU] On
> Behalf Of David Longo
> Sent: Thursday, 28 June 2007 11:49 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> 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 <pdudley AT ANL.COM DOT AU> 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
> pdudley AT anl.com DOT au
>
>
>
>
>
> 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.

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