Unfortunately, I don't use SQL but I do back up a FMP server by stopping
it's services and then restarting them after the backup.  The services only
gets stopped when that machine is being backed up so the "down-time" is
minimal.  I used the Exchange Server script as a base and just took out the
existing "net stop" and "net stop" services and replaced them with the FMP
services.

I would imagine all you would have to do is find out which services are
associated with SQL and replace them in the Exchange script.  It should also
be noted that now Dantz has a free backup utility that will backup a live
Exchange database.  I use it and LOVE it.  Veritas wants about $600 for such
a utility.  Thanks guys!

J.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf
Of Kraut, David
Sent: Tuesday, October 31, 2000 3:02 PM
To: 'retro-talk'
Subject: RE: How can I stop an NT service before backup?


Thanks Ben but like I mentioned, my backups sometimes start at 7:00PM and
are still running the next morning when I come in!  I am backing up 10+
servers to a tape library and I can't leave the service down for that long
of a time ....

 -----Original Message-----
From:   Ben Mihailescu [mailto:[EMAIL PROTECTED]]
Sent:   Tuesday, October 31, 2000 5:20 PM
To:     retro-talk
Subject:        Re: How can I stop an NT service before backup?

How about you run an AT job with "net stop service" before your backup
starts
and then you run an AT job with "net start service" after retrospect is
done.

HTH, Ben

"Kraut, David" wrote:

> I have a backup job that backs up several servers during the night.  One
of
> these servers has a SQL database that will not back up properly unless the
> NT SQLBase service is stopped first.  I went thru the support docs and
they
> all talk about external scripting?  Is there a simple way that I can stop
a
> Windows NT service prior to backup of this server and then start it up
again
> after backup.  I know about the "net stop service" command but have no
clue
> how to implement within retrospect.  Also, I'm backing up 10 servers in
this
> script so it would best if I could stop this service immediately before
> backing the SQL server and then start the service immediately after backup
> of this server is complete.  Sometimes my backup jobs run into the morning
> hours so I can't afford to have this service stopped during the entire
> script.
>
> Any ideas??
>
> TIA!!
>
> David
>
> --
> ----------------------------------------------------------
> To subscribe:    [EMAIL PROTECTED]
> To unsubscribe:  [EMAIL PROTECTED]
> Archives:        <http://list.working-dogs.com/lists/retro-talk/>
>
> For urgent issues, please contact Dantz technical support directly at
> [EMAIL PROTECTED] or 925.253.3050.



--
----------------------------------------------------------
To subscribe:    [EMAIL PROTECTED]
To unsubscribe:  [EMAIL PROTECTED]
Archives:        <http://list.working-dogs.com/lists/retro-talk/>

For urgent issues, please contact Dantz technical support directly at
[EMAIL PROTECTED] or 925.253.3050.


--
----------------------------------------------------------
To subscribe:    [EMAIL PROTECTED]
To unsubscribe:  [EMAIL PROTECTED]
Archives:        <http://list.working-dogs.com/lists/retro-talk/>

For urgent issues, please contact Dantz technical support directly at
[EMAIL PROTECTED] or 925.253.3050.


__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com



--
----------------------------------------------------------
To subscribe:    [EMAIL PROTECTED]
To unsubscribe:  [EMAIL PROTECTED]
Archives:        <http://list.working-dogs.com/lists/retro-talk/>

For urgent issues, please contact Dantz technical support directly at
[EMAIL PROTECTED] or 925.253.3050.

Reply via email to