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
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
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,
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 an Oracle DB.
However, it requires frequent maintenance. I know that no user will be
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) 319-8836
[EMAIL PROTECTED]
-Original Message-
From: Ryan Hartwich [SMTP:[EMAIL
By definition in quite a few languages that I know of, sentences ending in a
? are deamed questions. your answer and the other couple back in this
thread are actually what I was looking for. I'm so sorry that people in this
country are allowed to ask questions instead of just answer the question
I confess, I was only repeating what our in-house MSSQL expert told me.
While I watched, he went into Enterprise Manager and then into a dialog
window (exact name forgotten) dedicated to backups. He added a short line of
code that turns off the service to accommodate the backup, then turns the
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.
OK, If you are running MS Access as your DB, and you need the ODBC
drivers to let go of it so that you can hit it with your backup or
optimize routine, then the easiest way is to cause an ODBC error on
purpose. This will release the connections to the .MDB until the next
query hits that asks for
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
10 matches
Mail list logo