The delay is that with large DB's, you have to wait for the DB file to be
recreated on disk before it can be restored from backup.

With only say a 1 GB file, it's hardly noticeable.

They has been some occasional discussion about this.

David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH      321.434.5536
Pager  321.634.8230
Fax:    321.434.5509
david.longo AT health-first DOT org


>>> jdury AT DUQLIGHT DOT COM 06/30/04 03:50PM >>>
One of my users is trying to restore a 22 gig MSSQL database using TDP
v5.2.1. The entire restore is taking several hours from start to finish and
I have no idea why. I've watched the process and once it mounts the tape
(the whole DB fits on 1 tape) ,it just sits for usually hours and appears
to do nothing. Any clues why this is taking so long? We are running our TSM
5.2.2.4 server under AIX 5.1 if it matters. Any suggestion on what to look
at?
Thanks,
John

##############################################################
This message is for the named person's use only.  It may 
contain confidential, proprietary, or legally privileged 
information.  No confidentiality or privilege is waived or 
lost by any mistransmission.  If you receive this message 
in error, please immediately delete it and all copies of it 
from your system, destroy any hard copies of it, and notify 
the sender.  You must not, directly or indirectly, use, 
disclose, distribute, print, or copy any part of this message
if you are not the intended recipient.  Health First reserves
the right to monitor all e-mail communications through its
networks.  Any views or opinions expressed in this message
are solely those of the individual sender, except (1) where
the message states such views or opinions are on behalf of 
a particular entity;  and (2) the sender is authorized by 
the entity to give such views or opinions.
##############################################################