> This is true the master db does contain info about the DB
> including the security settings and things like that. But I
> think as long as the services are stopped then there should
> not be a problem.
>
> Again I am not sure because the only thing I have done it
> with was a small static DB but it is worth a try.
There's no need to try this. You can easily back up your database to a file,
copy the file to a new server, and restore from that file, without having to
shut down the database server or worry about losing info. I do this quite
often when I have to deploy a new version of a database.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.