ADSM-L

[ADSM-L] TDP for SQL restore question

2007-06-27 21:40:22
Subject: [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 11:41:47 +1000
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.

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