sp_attach_db
sp_detach_db
1. you stop the mssql server service
2. restart it
3. run the detach version (im not sure of the parameters right off of the
top of my head, but they are simple)
4. move the physical file, the .mdb file to the new machine/directory
5. run the attach version, and it should create a new .ldb (log file) for
the database, if not just
move that too, and specify in your attach sp the location of both.
look in the t-sql help included with mssql server 2000 for more help on
this...but this is fairly well documented, so you shouldn't have too much
trouble getting help.
good luck!
also, I think the cfmx server's settings are stored in an xml file...someone
here will chime in!
later.
tony
-----Original Message-----
From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 20, 2004 8:20 AM
To: CF-Talk
Subject: cfmx 6.1 (and mssql2k) server migration
I will need to move my cfmx server to another machine in the coming weeks.
Does anyone have any tips, or URL's which might assist me in backing up the
cfserver settings to replicate the setup on the new server?
I'm going to need to do the same with MSSQL2K, in case you also know how to
do that.
Thanks in advance...
-DBK
--------------------------------------------------------
NOTICE: If received in error, please destroy and notify sender. Sender does
not waive confidentiality or privilege, and use is prohibited.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
