RE: How can I stop an NT service before backup?
Perhaps this idea will help, its implementation requires only that you can use command-line arguments to halt and restart the server: You have a special script that just backs up the database files that can't be backed up while the server is running. You create a RetroEventhandler.bat halts the server when the special script starts, and restarts the server when the special script finishes. Meanwhile, you have another script that backs up everything except the database files, it runs at any time and doesn't shut down the server. In your case, hopefully the time required to back up a single database wouldn't require too much downtime. Dantz is using this strategy successfully in-house with an NT 4.0 Server and a MySQL database. We're not even shutting down the server, since MySQL has a convenient tool that allows a single command to dump the database to a file without halting the database service. Our RetroEventhandler.bat script simply runs the dump command before backup, the backup script has a custom selector that backs up everything (including the dump) except for the live database files. See the Retrospect 5.1 User's Guide Addendum for a complete discussion of Retrospect scripting events. Best Regards, Paul Mackinney Dantz Development Corporation 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 -- -- 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.
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.
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.
