70-90 on our dev server. That is a major pain to re-setup on a new server or
to rebuild a damaged server. I wrote a simple script that found the
application.cfm for each client then parsed out the DSN name and displayed
all of them on a webpage. I then put one of the "out of work" (one of the
guys waiting for me to rebuild the server) developers to work recreating the
DSN while I did something else.
Detaching and Attaching does work well. I found that it stuck "_data" in
some of the database names last I did it.
Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
Vivid Media
[EMAIL PROTECTED]
www.vividmedia.com <http://www.vividmedia.com/>
608.270.9770
_____
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 11, 2004 8:46 AM
To: CF-Talk
Subject: RE: Server Rebuild Questions
No, because some stuff is screwed up on the Dev server and we need to make
sure it's working corrrectly. Plus, this is a good excuse to upgrade to
Windows 2k3. By the way, I found out that Detaching and Attaching works
pretty well for moving the databases. Found that info on a MS technote.
John
________________________________
From: Ken Ferguson [mailto:[EMAIL PROTECTED]
Sent: Wed 8/11/2004 9:21 AM
To: CF-Talk
Subject: RE: Server Rebuild Questions
Can you just make an image of the prod server and use that to build the
dev server?
--Ferg
_____
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 11, 2004 7:25 AM
To: CF-Talk
Subject: Server Rebuild Questions
Our main dev server went nuts yesterday and I've been tasked to rebuild
it. I'm trying to build another server just like the original as fast as
possible so all of our developers aren't dead in the water without the
dev server. I've run into a few questions/problems that I'd like to see
if the list can help with.
1. Where can I download a 6.1 installer so I can install straight to 6.1
without installing from the CD first and then upgrading? I tried
downloading the one on the 6.1 upgrade page but when I try to run it it
says "Please extract the installer to a different directory" and I've
tried moving it to all kinds of directories with no luck, so I'm
guessing that the installer wants to be extracted to the directory where
CFMX 6.0 already exists? This is a brand new Dell with Windows 2003
Server (I already know the gotchas for installing 6.1 on Win2k3 with
IIS).
2. Our dev server also is running an instance of SQL server with
approximately 15 databases inside. What's the best way to move all of
the databases (and, if possible, the SQL settings and logins and
security) from one server to the next. I wasn't sure if I could just
copy the data files over or if I needed to run backups on each database
to get those files. Any tips or tricks would be extremely helpful.
3. We also have an instance of MySQL installed, which I'm not 100% sure
needs to be on the new server, but if it does, any tips or tricks for
moving that over?
Thanks in advance for the help!
John Burns
_____
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
