Re: Seeking Command Line Help

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/18/04 

Date: Thu, 18 Mar 2004 19:39:46 +0100

You can use OSQL.EXE and through that execute the appropriate BACKUP and
RESZTORE commands (both OSQL.EXE and BACKUP, RESTORE are documented in Books
Online :-) ). 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"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 -
> > >
> > >
> >
> >
>
>

Relevant Pages

  • RE: Exchange 2003 & NTBackup Restore problems
    ... Have you considered just mounting an empty store instead of deleting the ... Did you do a FULL backup today?????? ... > can have clean accounts. ... Prepared to perform a restore, from the clean backup, to clean up the ...
    (microsoft.public.exchange.admin)
  • Re: Exchange 2003 & NTBackup Restore problems
    ... > have you tried simply dismounting the mailbox store and deleting the ... > remove all mailbox data from the accounts. ... > time than restoring from backup. ... Prepared to perform a restore, from the clean backup, to clean up the ...
    (microsoft.public.exchange.admin)
  • Re: Exchange database restore question - tg
    ... "The Exchange Information Store automatically redirects all restore ... operations to the Recovery Storage Group (if a Recovery Storage Group ... by NT Backup and my restore be pushed to the RSG? ...
    (microsoft.public.exchange.admin)
  • Re: Exchange 2003 & NTBackup Restore problems
    ... Um - simple question, but if you are trying to clear out all the accounts, ... have you tried simply dismounting the mailbox store and deleting the ... time than restoring from backup. ... Prepared to perform a restore, from the clean backup, to clean up the ...
    (microsoft.public.exchange.admin)
  • Re: mount database with *.edb and all logs Exchange 2007 urgent :>
    ... Can I copy the database *.edb in the original database *.edb? ... Only the store has to be mounted. ... backup files y open teh mailbox that it contein. ... I need restore all mailboxes, i have the backup with the file *.edb and the ...
    (microsoft.public.exchange.admin)