whoa, interesting idea. I was thinking more allong the lines of copying the db via enterprise manager. Is this a bad idea?
-----Original Message----- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 1:06 PM To: CF-Talk Subject: RE: Migrating sqlservers 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 ______________________________________________________________________ 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
