Yiannakis

Go to:
   http://www.ibm.com/us/

and search for:
   +DP +SQL +ANS1017E

You will find that when restoring large databases,
Data Protection for SQL will restore a small amount of data.
At that point, the SQL Server formats the large files that will eventually
hold all of the restored data. This preformat can take SQL Server
quite a while to perform. Once the preformatting is done, Data Protection
for SQL will continue with the restore. You will need to raise the value
of the
COMMTIMEOUT setting on your TSM Server to allow for large SQL database
restores.

Thanks,

Del

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

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 01/20/2005
05:03:33 AM:

> Hi,
> When I display client node's details, I observe that on some nodes the
> TCP/IP Name and TCP/IP address is blank while on others it has the name
and
> IP address of each node. I cannot understand why.
> Any suggestions ?
>
> The problem I face is that I have a SQL Dbase that is corrupted and I'm
> trying to restore thru the SQL client gui. The session starts correctly,
the
> correct tapes are loaded but the session remains there (for more than an
> hour) on SENDW.
> The owner of the database has deattached the database and renamed the db
> files so that he won't lose them. Could that be the reason ?
> Thanks
>
> Environment
> TSM Server on Win2000, version 5.2
> TSM Client on Win2000, version 5.1.5
> Yiannakis Vakis
> Systems Support Group, I.T.Division
> Tel. 22-848523, 99-414788, Fax. 22-337770