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

Reply via email to