The DBAs "claim" they can configure the SQL boxes to send an email with
the success/failure of each db dump. 

As long as somebody actually monitors the emails..........

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

That works fine.
Upside:  No TDP for SQL license required
Downside:  
You (the TSM admin) get no notification if those dumps fail (or
accidentally get turned off). 

I went into a new TSM customer last year and we found 7 out of 12 SQL
servers that were supposedly backing up to disk had somehow gotten the
backups turned off...


-----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 3: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.