Re: [ADSM-L] TSM SQL question

Hi Rick,

There are two commands in the second step.
I can see the entire commands in Firefox and IE, although the
text wraps at different places in both browsers.

Here is the first command (I wrapped on each option):

     tdpsqlc restore Northwind FULL
        /relocate=Northwind,Northwind_log
        /to=g:\MSSQL\DATA\northwnd.mdf,g:\MSSQL\DATA\northwnd.ldf
        /fromsqlserver=TSMCRASH
        /sqlserver=TSMBURN
        /tsmnode=crash
        /tsmpassword=pwd
        /mountwait=yes


Here is the second command:

     tdpsqlc restore Northwind FULL
        /RELOCATEDIR=g:\MSSQL\DATA\
        /fromsqlserver=TSMCRASH
        /sqlserver=TSMBURN
        /tsmnode=crash
        /tsmpassword=pwd
        /mountwait=yes


I hope this helps.

Thank you,

Del

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


"ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu> wrote on 06/27/2014
04:04:20 PM:

> From: Rick Adamson <RickAdamson AT BILOHOLDINGS DOT COM>
> To: ADSM-L AT vm.marist DOT edu
> Date: 06/27/2014 04:05 PM
> Subject: Re: TSM SQL question
> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu>
>
> Del,
> Is it just me or does the restore command in step two of this
> article run off the page rather than wrapping to the next line?
>
> I did submit the issue in the comment section, but as it is will
> leave many hanging....
>
> Thanks
>
> ~Rick
>
>
>
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On
> Behalf Of Del Hoobler
> Sent: Monday, June 16, 2014 6:38 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: [ADSM-L] TSM SQL question
>
> 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
>