Brian,

My experience with SQL database has been to use the TSM SQL Agent.   The
performance is far greater than a flat file restore.  To restore a database
that is 1 GB takes about 15 min in our environment using TSM 3.7 on NT
direct from tape.

If a speedy restore is of importance the agent is the way to go.  The Flat
File backup is a good secondary backup measure.

Hope this helps..

Jerry Kube
Senior Technical Analyst
Ceridian Canada Ltd.
jerry_kube AT ceridian DOT ca






Brian Nick <BRIAN_NICK AT PHL DOT COM>@VM.MARIST.EDU> on 2000/11/08 07:56:10 AM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

Sent by:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To:   ADSM-L AT VM.MARIST DOT EDU
cc:

Subject:  SQL restore question


Hello everyone,

 I was just contacted by one of our DBA's and I have a questions about SQL
restore. We are running TSM 3.7.3 on OS/390 2.9 and TSM client version
3.7.2. Please note that we are not using TDP for SQL. As explained to me by
our DBA there is a dump of the SQL data base taken every night and TSM
backs up the dump. By the way this is SQL 6.5 SP5a. The questions is
performance, we are currently attempting to restore the dump which is a
small file only 230mb. At the current rate it looks like the restore will
take about 2.5 hours to run. The dump file is being restored to its
original location.

 I realize that this question might be vague but it is all the information
that I have to offer at this time. Any help on improving the performance of
this SQL restore would be appreciated.

 Thanks,
    Brian


Brian L. Nick
Systems Technician - Storage Solutions
Phoenix Home Life Mutual Ins.
100 Bright Meadow Blvd
Enfield CT. 06082-1900

E-MAIL:  Brian_Nick AT PHL DOT COM
PHONE:   (860)403-2281