2. If the dev server is running then try doing a DTS transfer - open enterprise manager, right click on "databases" and choose "import".
Otherwise i'd go for restoring from backups - you might be able to reattach the data files, but its not something i've ever tried. Similar lack of experiance with migrating accounts and stuff -sorry.
HTH
Bert
On Wed, 11 Aug 2004 08:25:22 -0400, Burns, John D
<[EMAIL PROTECTED]> wrote:
> 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]
