> 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?
If you have CFMX Enterprise, you can create an archive file from within the
CF Administrator. You can also just back up the CF configuration files,
which are a bunch of XML files: \cfusionmx\lib\neo-*.xml
> I'm going to need to do the same with MSSQL2K, in case you
> also know how to do that.
If you can shut off the original SQL Server, the easiest way to do this is
to just copy the .mdf and .ldf files for your specific databases and use
sp_attach_db to attach them to the new server. If the new server will be
exactly identical to the old one, you may be able to do the same thing with
the master database as well, which will preserve database server
configuration stuff, but that can be a bit dicey.
Alternatively, you can use the backup and restore functionality to back up
individual databases and restore them to the new server.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
