> 2: I'm not sure I understand what you mean by STORE and RESTORE...

> 1: DTSRUN.EXE
>
> 2: I'm not sure I understand what you mean by STORE and RESTORE...
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
>
> "Joseph Geretz" <jgeretz@nospam.com> wrote in message
> news:eTb7hJRDEHA.1240@TK2MSFTNGP10.phx.gbl...
> > We'd like to be able to provide a simple batch file which will transfer
an
> > online database to another online location. Obviously, this is simple to
> do
> > with a DTS package. Can a DTS package be called from the command line?
> > (Failing this, I guess I could write my own program to launch the DTS
> > package, and obviously my own program could then be launched from the
> > command line.)
> >
> > How about STORE / RESTORE? Can these be invoked from a batch file? If I
> > place both command lines for STORE and RESTORE into the same batch file,
> > will the STORE command block until the STORE process finishes?
Obviously,
> > this is necessary since the RESTORE can't kick off until the STORE
process
> > finishes.
> >
> > Or is there another way of doing this?
> >
> > Thanks very much for your help.
> >
> > - Joe Geretz -
> >
> >
>
>

"Joseph Geretz" <jgeretz@nospam.com> wrote in message
news:eTb7hJRDEHA.1240@TK2MSFTNGP10.phx.gbl...
> We'd like to be able to provide a simple batch file which will transfer an
> online database to another online location. Obviously, this is simple to
do
> with a DTS package. Can a DTS package be called from the command line?
> (Failing this, I guess I could write my own program to launch the DTS
> package, and obviously my own program could then be launched from the
> command line.)
>
> How about STORE / RESTORE? Can these be invoked from a batch file? If I
> place both command lines for STORE and RESTORE into the same batch file,
> will the STORE command block until the STORE process finishes? Obviously,
> this is necessary since the RESTORE can't kick off until the STORE process
> finishes.
>
> Or is there another way of doing this?
>
> Thanks very much for your help.
>
> - Joe Geretz -
>
>

"Joseph Geretz" <jgeretz@nospam.com> wrote in message
news:%23Zyo3YRDEHA.580@TK2MSFTNGP11.phx.gbl...
> Hi Tibor,
>
> Thanks for the quick reply!
>
> > 2: I'm not sure I understand what you mean by STORE and RESTORE...
>
> In Enterprise manager I can Backup (my mistake, I meant Backup, not Store)
> and Restore the database to a new location. I'm wondering if this can be
> done via Command line.
>
> Thanks,
>
> - Joe Geretz -
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote
in
> message news:uJVCPNRDEHA.3804@TK2MSFTNGP09.phx.gbl...
> > 1: DTSRUN.EXE
> >
> > 2: I'm not sure I understand what you mean by STORE and RESTORE...
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> >
> >
> > "Joseph Geretz" <jgeretz@nospam.com> wrote in message
> > news:eTb7hJRDEHA.1240@TK2MSFTNGP10.phx.gbl...
> > > We'd like to be able to provide a simple batch file which will
transfer
> an
> > > online database to another online location. Obviously, this is simple
to
> > do
> > > with a DTS package. Can a DTS package be called from the command line?
> > > (Failing this, I guess I could write my own program to launch the DTS
> > > package, and obviously my own program could then be launched from the
> > > command line.)
> > >
> > > How about STORE / RESTORE? Can these be invoked from a batch file? If
I
> > > place both command lines for STORE and RESTORE into the same batch
file,
> > > will the STORE command block until the STORE process finishes?
> Obviously,
> > > this is necessary since the RESTORE can't kick off until the STORE
> process
> > > finishes.
> > >
> > > Or is there another way of doing this?
> > >
> > > Thanks very much for your help.
> > >
> > > - Joe Geretz -
> > >
> > >
> >
> >
>
>