First off have an id created that is on the new and the old server. Then delete out all ids with the exception of that db and make that id dbo of the database via sp_changedbowner oldowner, newowner
Then have a complete backup of the db zipped up and sent to you then use sp_detachdb to detach the database from that server have that also sent to you. First try to restore the full backup if the does not work then use sp_attachdb on the new server. Joshua Tipton -----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 ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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
