Dave Watts wrote: > There are a couple of options that might work for you. If this is a > one-time thing, and you can stop the source database server, you can > simply copy the database and log files to the new server, and use > sp_attach_db to attach each to the new server. <snip>
Another alternative if you don't need to move the log files is to look into the command (see Books Online for syntax): sp_attach_single_file_db This allows you to attach just using the .MDF file. Stephen ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists