Hi Jim, Yes.Go to Enterprise Manager
Select the database-->Right Click -->All Tasks -->Backup Select Database - Complete. Add Destination ( where the back up file to be taken) Click Ok. The Backup is created on file selected for backup In Options Tab See that the Following are checked. Verify Backup Upon Completion.(It will ensure after backup is completed successfully). Regards Nagaraj. ----- Original Message ----- From: "Jim Curran" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Saturday, June 15, 2002 6:24 AM Subject: OT SQL SERVER Backup > Is there an easy way to back up all the SQL server DB's and restore them on > a separate Machine? > > - j > > > ______________________________________________________________________ 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