> I know how to backup/migrate one particular DB of a SQL > Server install, but does anyone know a way to migrate the > entire set?
Here's an unusual solution, but it worked for us when we had to move servers Stop the SQL Server engine, copy all of the .mdf and .ldf files to the other server "exec sp_attach_db" all of the databases using the correct files; exec sp_attach_db @dbname='Database', @filename1='d:\sqldata\database.mdf', @filename2='d:\sqldata\database.ldf' The only problem with this is that you have to be on the same Unicode character set, but it works (and is tons faster)! Philip Arnold Technical Director Certified ColdFusion Developer ASP Multimedia Limited Switchboard: +44 (0)20 8680 8099 Fax: +44 (0)20 8686 7911 www.aspmedia.co.uk www.aspevents.net An ISO9001 registered company. ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
