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
, 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
, 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
]]
Sent: Thursday, December 13, 2001 1:00 PM
To: [EMAIL PROTECTED]
Subject:RE: [KCFusion] Scheduled Datasource Updating
Keith,
You can't backup your MS SQL 7 DB while it is running? That's
strangeI know that you might have problems
PM
To: '[EMAIL PROTECTED]'
Subject: RE: [KCFusion] Scheduled Datasource Updating
Bruce:
Yes. I inherited an Access DB that we are running a large intranet
application against. It works fine for the 200+ users that use it, and it
is actually faster than most of our counterparts that use
Kirkbride
Sent: Thursday, December 13, 2001 1:04 PM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] Scheduled Datasource Updating
Are you using NT backup? I think Backup Exec will back up a SQL Server on
the fly, but NT backup won't.
Mark Kirkbride
Information System Specialist
FBD Consulting, Inc.
(913
Gentlemen, (a term used loosely at the moment)
Is this discussion not a testament to why we are all in this game of CF/Web
development to begin with?
We choose ColdFusion because it is a multi-platform, multi-database system
which allows HUGE flexibility with regard to the solutions we design.
: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
Thank you, Robin. That makes complete sense.
-Original Message-
From: Greenhagen, Robin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 2:21 PM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] Scheduled Datasource Updating
OK, If you are running MS Access as your DB, and you