We have done that in the past and it worked just fine.  We built the "SQL Dump" 
on our backup server (not TSM at the time) and that allowed the backup server 
to dump the data straight to tape.  We also had a batch process to move the 
files to the bit bucket after they got "old".
The TDP is much simpler, but as long as the DBAs are happy and aware I am not 
worried.

Andy Huebner


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Tyree, David
Sent: Wednesday, June 09, 2010 2:05 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] TDP for SQL vs SQL dumps

                I was talking about backups with a couple of our DBAs
and they mentioned using SQL scripts on the server to export the
database and then use the regular TSM client to backup the exported file
instead of using the TDP.

                They suggested building a server with a bunch of shares,
one share for each of our SQL servers. Then go into each of the SQL
servers and set up a script that dumps the database to share that was
created for it. The dump location would have the regular TSM client
running to catch all the incoming SQL files.

                The DBAs did some db dumps and also some log dumps as
well and were able to restore them back into the server and they seemed
happy with the process.

                Is there anything I'm missing here? It seems like a
reasonable idea to me.



David Tyree
Interface Analyst
South Georgia Medical Center
229.333.1155

Confidential Notice:  This e-mail message, including any attachments, is
for the sole use of the intended recipient(s) and may contain
confidential and privileged information.  Any unauthorized review, use,
disclosure or distribution is prohibited.  If you are not the intended
recipient, please contact the sender by reply e-mail and destroy all
copies of the original message.

This e-mail (including any attachments) is confidential and may be legally 
privileged. If you are not an intended recipient or an authorized 
representative of an intended recipient, you are prohibited from using, copying 
or distributing the information in this e-mail or its attachments. If you have 
received this e-mail in error, please notify the sender immediately by return 
e-mail and delete all copies of this message and any attachments.

Thank you.