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@VM.MARIST.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
