Actually, we do something similar inside a backup procedure, because we can't back up our database while MSSQL7 is running.
Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Dunwiddie, Bruce Sent: Thursday, December 13, 2001 12:19 PM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Scheduled Datasource Updating am I crazy, or this a rediculous solution in the age of providing worldwide services in all timezones? and I can only assume that this maintenance is necessary because you're using an access db? -----Original Message----- From: Ellis, Randy [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 11:40 AM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] Scheduled Datasource Updating 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]
