An off-list post from Bernie Walker has led me to a thought about shutting down the DB in advance of the system restart. Does anyone have a command verison of _mprshut.exe (such as I use for ProMon) that will do the equivalent of an Option 8-2 (unconditional shutdown)? Something I could put in a batch file and then wait a bit before doing the shutdown command.
Thanks,
-Todd C.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Todd Caughey
Sent: Tuesday, January 08, 2008 1:00 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [semi-OT] Automated/Scheduled Server Restart
Good idea on the backup. Rather than seperately schedule for midnight (as intended) but before the backup runs I could run a seconday batch process after the already scheduled nightly backup runs. Then control when I want it to run or not by putting a "rem" on the line (or taking it off). This way the restart would happen after the backup.
On the shutdown itself the more I read the more I find the /r part is the same as manually clicking on Start-Shutdown-Restart which has never seemed to bother Vantage.
Thanks,
-Todd C.
-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Carey S
Sent: Tuesday, January 08, 2008 12:51 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] [semi-OT] Automated/Scheduled Server Restart
Todd,
To be sure, you can schedule the run of a bat file that would stop the service. Something like net stop "service name".
You could secondarily call for a shutdown.
Rebooting would allow the service to restart automatically.
Just thinking off of the top of my head, I would like to get the latest backup possible, so maybe start the script with the probkup or something to do a backup and then proceed with the rest.
Carey
To: vantage@yahoogroups.comFrom<mailto:vantage%40yahoogroups.comFrom>: caugheyt@...<mailto:caugheyt%40harveyvogel.comDate>: Tue, 8 Jan 2008 09:11:09 -0600Subject: [Vantage] [semi-OT] Automated/Scheduled Server Restart
I need to reboot our Vantage server occasionally and remoting in from home at midnight after the 2nd shift has gone is a PITA...not to mention the ugly look from my wife for waking her up. ;)Can I safely use a scheduled "Shutdown /r /f" command on the Win2003 server that runs Vantage? Will this properly (safely) stop the Vantage Progress DB (9.1D)? Admin service is Automatic and the DB is set to restart when the service starts so that side already works OK.Thanks,Todd CaugheyHarvey Vogel Mfg. Co.[Non-text portions of this message have been removed]
__________________________________________________________
Make distant family not so distant with Windows Vista(r) + Windows Live(tm).
http://www.microsoft.com/windows/digitallife/keepintouch.mspx?ocid=TXT_TAGLM_CPC_VideoChat_distantfamily_012008
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
[Non-text portions of this message have been removed]
Thanks,
-Todd C.
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Todd Caughey
Sent: Tuesday, January 08, 2008 1:00 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [semi-OT] Automated/Scheduled Server Restart
Good idea on the backup. Rather than seperately schedule for midnight (as intended) but before the backup runs I could run a seconday batch process after the already scheduled nightly backup runs. Then control when I want it to run or not by putting a "rem" on the line (or taking it off). This way the restart would happen after the backup.
On the shutdown itself the more I read the more I find the /r part is the same as manually clicking on Start-Shutdown-Restart which has never seemed to bother Vantage.
Thanks,
-Todd C.
-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Carey S
Sent: Tuesday, January 08, 2008 12:51 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] [semi-OT] Automated/Scheduled Server Restart
Todd,
To be sure, you can schedule the run of a bat file that would stop the service. Something like net stop "service name".
You could secondarily call for a shutdown.
Rebooting would allow the service to restart automatically.
Just thinking off of the top of my head, I would like to get the latest backup possible, so maybe start the script with the probkup or something to do a backup and then proceed with the rest.
Carey
To: vantage@yahoogroups.comFrom<mailto:vantage%40yahoogroups.comFrom>: caugheyt@...<mailto:caugheyt%40harveyvogel.comDate>: Tue, 8 Jan 2008 09:11:09 -0600Subject: [Vantage] [semi-OT] Automated/Scheduled Server Restart
I need to reboot our Vantage server occasionally and remoting in from home at midnight after the 2nd shift has gone is a PITA...not to mention the ugly look from my wife for waking her up. ;)Can I safely use a scheduled "Shutdown /r /f" command on the Win2003 server that runs Vantage? Will this properly (safely) stop the Vantage Progress DB (9.1D)? Admin service is Automatic and the DB is set to restart when the service starts so that side already works OK.Thanks,Todd CaugheyHarvey Vogel Mfg. Co.[Non-text portions of this message have been removed]
__________________________________________________________
Make distant family not so distant with Windows Vista(r) + Windows Live(tm).
http://www.microsoft.com/windows/digitallife/keepintouch.mspx?ocid=TXT_TAGLM_CPC_VideoChat_distantfamily_012008
[Non-text portions of this message have been removed]
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
[Non-text portions of this message have been removed]