I've only found that Access DBs can be corrupted by abrupt events, such as dropping connectivity or killing the service. SQL DBs are usually good in taking care of themselves. I've never had a problem with MSSQL2K.
The net stop command should at least get the Witango service to stop answering queries, even if it doesn't stop the service all together, you might want to check to see if that's the case. Also, read the witangoevents.log to see how far the stop command gets, and review the Witango.log to see what it's doing. Also check @SERVERSTATUS to see if you have hung threads. The service might not eventually shutdown, there is a timeout in your .ini file you can adjust. But if there is a hung thread it might never stop. Make sure you are running the latest version of the server, it's the best to date with these situations. Robert -----Original Message----- From: Fogelson, Steve [mailto:[EMAIL PROTECTED] Sent: Thursday, March 11, 2004 9:48 AM To: '[EMAIL PROTECTED]' Subject: RE: Witango-Talk: Witango Maintenance Restart in the middle of the night Thanks Mike and John Just out of curiosity, would either of these programs have the potential of corrupting and databases that Witango may be accessing (writing to) at the time they were executed? If so, are there any recommendations to stopping db access or something similar prior to killing the service? Would the Witango service eventually shut down when the net stop command is issued on a busy server? Thanks Steve -----Original Message----- From: John McGowan [mailto:[EMAIL PROTECTED] Sent: Thursday, March 11, 2004 8:40 AM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: Witango Maintenance Restart in the middle of the night Also, the NT resource kit (and I assume the 2000 one as well) has a kill.exe executable which does a very nice job of killing a stubborn (busy) process instead of waiting for it to shut down nicely. I have a batch file on the desktop of each of my Witango boxes that kills and restarts the Witango process so I can just double click on that batch file if the Witango process locks up. (Which is a problem that I'm having whenever I clear the cache on a busy server) /John Willochell, Mike wrote: >Steve, > >As part of the persistent restart program I created, I use a free product called PSKILL which I call in the event that the NET STOP command does not complete successfully. PSKILL is the equivalent of ending the task through the Task Manager. You can find it at: http://www.sysinternals.com/ntw2k/freeware/psservice.shtml > >They have very good command oriented tools for the developer. > >Mike > >-----Original Message----- >From: Fogelson, Steve [mailto:[EMAIL PROTECTED] >Sent: Wednesday, March 10, 2004 11:44 PM >To: Witango User Group (E-mail) >Subject: Witango-Talk: Witango Maintenance Restart in the middle of the >night > > >Per suggestions on this list I started stopping Witango, coping Db's to >another location for backup and restarting Witango. This is a batch file >that is started by the Windows scheduler. I use the Net stop "witango server >5" > >About a week ago, I added a site that has quite a bit of traffic. Now the >service doesn't stop and restart. Also when I manually stop the service, it >doesn't stop and I have to use the Task manager to stop it. > >Is there a way I can "force" the stop in my batch file? > >Thanks > >Steve Fogelson >Internet Commerce Solutions >_______________________________________________________________________ _ >TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > >_______________________________________________________________________ _ >TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
