We have a scheduled BAT file running on our web server each night that updates a database file. The unfortunate thing is we actually down the website to perform the updates and then bring the website back up.
The BAT file looks look this: net stop "WORLD WIDE WEB PUBLISHING SERVICE" C:\Update.exe net start "WORLD WIDE WEB PUBLISHING SERVICE" Randy -----Original Message----- From: Bakken, Kory [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 11:09 AM To: '[EMAIL PROTECTED]' Subject: [KCFusion] Scheduled Datasource Updating I need to schedule maintenance window each night to perform automated repairs and compaction on my main database. I know how to do that, but in order to repair and compact the database, I need to disconnect the datasource that is hitting against it for that period of time. Does anybody know if it is possible to schedule updates to a datasource (i.e.-disconnect and reconnect)? Kory Bakken IT Enterprise Release Management Tools / Process desk: 816.559.4801 pcs: 816.305.5890 ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED] ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED]
