If you are creating an *exact* replica of the original SQL Server, the easiest way is to:
1) stop SQL server on the Source Machine 2) Zip the "data" directory 3) transfer the zip file to the destination machine 4) Install & patch dest machine to exact config as source (don't worry about users or permissions) 5) stop the dest SQL server 6) rename the dest "data" folder 7) unzip file to the dest "data" location 8) start SQL server on dest Job complete w/ an EXACT replica. - j jim.curran technical.director nylon.technology 212.691.1134 [EMAIL PROTECTED] -----Original Message----- From: Brian J. LeRoux [mailto:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 3:36 PM To: CF-Talk Subject: Migrating sqlservers We're moving a client to a new hosting facility and they have a rather large sqlserver db that needs to be copyed over. I'm just reading up on it but I'd like to hear some advice from the pros. Method I should use? Pitfalls? Any advice is muchos appreciated! Thanks in advance, Brian ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
