| TIP: Click on subject to list as thread! | ANSI |
| echo: | |
|---|---|
| to: | |
| from: | |
| date: | |
| subject: | Re: Veritas BackupExec with SQL Server 2000? |
From: "Robert Comer"
> OK, stupid question time, if I make a .BAT file and each line kicks off
> an executable, does each next line wait until the previous process
> finishes?
Yes, it waits. (unless you use START to launch something that is.)
- Bob Comer
"Ellen K." wrote in message
news:rkm42v0iq0e0b90sbh9f2oj3js445kcp4c{at}4ax.com...
> OK, stupid question time, if I make a .BAT file and each line kicks off
> an executable, does each next line wait until the previous process
> finishes?
>
> On Mon, 13 Jan 2003 00:03:23 -0500, "Robert Comer"
> wrote in message :
>
> >> Well so if it's scheduled events... can you schedule a SET of events,
so
> >> each one runs after the previous one completes?
> >
> >Sure, just make a good old DOS .BAT file. (actually it's a NT cmd file,
but
> >close enough.)
> >
> >>I could put a little
> >> app on the backup box that would run my purge and archive routines, IF
> >> there's a way to tell it to run that AFTER the log and database backups
> >> complete, and then to run another log backup after that...
> >
> >You should be able to do that, return codes might be a problem and you
might
> >have to do a little coding in VB or something to interpret things. Most
of
> >my scheduled events are kind of one sided, just submit and forget type
> >things on the NT side.
> >
> >- Bob Comer
> >
> >
> >
> >"Ellen K." wrote in message
> >news:j5942v80j9cjndriah112opuij5p46h7al{at}4ax.com...
> >> Well so if it's scheduled events... can you schedule a SET of events,
so
> >> each one runs after the previous one completes? I could put a little
> >> app on the backup box that would run my purge and archive routines, IF
> >> there's a way to tell it to run that AFTER the log and database backups
> >> complete, and then to run another log backup after that...
> >>
> >> On Sun, 12 Jan 2003 17:31:15 -0500, "Robert Comer"
> >> wrote in message
:
> >>
> >> >> So I would use this on the Veritas box to send
commands to the SQL
> >> >> Server one?
> >> >
> >> >Possibly.
> >> >
> >> >>Does it know when the operation started by the sent
> >> >> command finishes?
> >> >
> >> >Good status messages between them would be a bit of a problem,
probably
> >have
> >> >to cobble some kind of message passing to get detailed type stuff.
Most
> >of
> >> >the time I use our AS/400 to send remote commands to PC's
and with it
I
> >get
> >> >a full stdout from whatever command I run so it's easy, don't know
what
> >I'd
> >> >do if it were NTS to NTS. Personally I don't use remote command to
back
> >up
> >> >my SQL server, I just use scheduled events, on both the
backup and the
> >SQL
> >> >server PC's, to arrange things so the right thing gets
backed up when.
> >> >
> >> >- Bob Comer
> >> >
> >> >
> >> >"Ellen K."
wrote in message
> >> >news:u4p32v454b4tclu2i507v10gimtef1ibj1{at}4ax.com...
> >> >> So I would use this on the Veritas box to send
commands to the SQL
> >> >> Server one? Does it know when the operation
started by the sent
> >> >> command finishes?
> >> >>
> >> >> On Sun, 12 Jan 2003 15:26:49 -0500, "Robert Comer"
> >> >> wrote in message
:
> >> >>
> >> >> >Remote command. It's for sending remote
commands to another
machine.
> >> >> >
> >> >> >- Bob Comer
> >> >> >
> >> >> >
> >> >> >"Ellen K."
wrote in message
> >> >> >news:04d32vs5d5enokpkpe0jobtobj046d1os6{at}4ax.com...
> >> >> >> What's rexec?
> >> >> >>
> >> >> >> On Sun, 12 Jan 2003 08:53:58 -0500,
"Robert Comer"
> >> >> >> wrote in message
:
> >> >> >>
> >> >> >> >> but the commands run on the local
machine and not a remote
> >machine.
> >> >And
> >> >> >> >> Ellen's SQL server is the remote
machine in this scenario I
> >guess.
> >> >> >> >
> >> >> >> >I don't see why it couldn't use rexec...
> >> >> >> >
> >> >> >> >- Bob Comer
> >> >> >> >
> >> >> >> >
> >> >> >> >"Peter Sawatzki"
wrote in message
> >> >> >>
>news:MPG.188b8fc1b78282c49896da{at}news.barkto.com...
> >> >> >> >> In article
,
> >> >> >> >> mnice{at}spamcop.net says...
> >> >> >> >> > On Sat, 11 Jan 2003 19:13:57
-0800, Ellen K.
> >> >> >
> >> >> >> >wrote:
> >> >> >> >> >
> >> >> >> >> > >Neither you nor George
addressed my other question, which
is
> >very
> >> >> >> >> > >important, i.e. I want to
make the backing up part of a
larger
> >> >> >> >> > >"housekeeping"
routine, how would that work?
> >> >> >> >> >
> >> >> >> >> > The full version of
Veritias Backup Exec has the option
of
> >> >> >commands
> >> >> >> >to run before and after the
> >> >> >> >> > backup job.
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >>
> >> >> >> >> but the commands run on the local
machine and not a remote
> >machine.
> >> >And
> >> >> >> >> Ellen's SQL server is the remote
machine in this scenario I
> >guess.
> >> >> >> >>
> >> >> >> >> PEter
> >> >> >> >
> >> >> >>
> >> >> >
> >> >>
> >> >
> >>
> >
>
--- BBBS/NT v4.01 Flag-4
* Origin: Barktopia BBS Site http://HarborWebs.com:8081 (1:379/1.45)SEEN-BY: 633/267 270 @PATH: 379/1 633/267 |
|
| SOURCE: echomail via fidonet.ozzmosis.com | |
Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.