Hi Mike,

Yes. This is possible. There are a number of customers doing it.
This might help you:

        http://www-01.ibm.com/support/docview.wss?uid=swg21253263


Thank you,

Del

----------------------------------------------------


"ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu> wrote on 06/13/2014
09:35:55 AM:

> From: Michael P Hizny <mhizny AT BINGHAMTON DOT EDU>
> To: ADSM-L AT vm.marist DOT edu
> Date: 06/13/2014 09:36 AM
> Subject: TSM SQL question
> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu>
>
> Hi,
>
> We are trying to set up an automated refresh of our test system
databases
> (Microsoft SQL) using the TSM SQL client.  Does anyone know if it is
> possible to automatically do an SQL backup of a production server
database
> and then restore this to a test system server via a command line script?
>
> Thanks,
>
> Mike