Re: OT SQL SERVER Backup

2002-06-15 Thread nagraj
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

RE: OT SQL SERVER Backup

2002-06-15 Thread Jim Curran
SQL SERVER Backup Which version of SQL Server...SQL2000 has a copy database wizard that can create a DTS package that you can save and run later. At 08:54 PM 6/14/2002 -0400, you wrote: Is there an easy way to back up all the SQL server DB's and restore them on a separate Machine? - j

RE: OT SQL SERVER Backup

2002-06-15 Thread Dave Watts
Is there an easy way to back up all the SQL server DB's and restore them on a separate Machine? ... I have SQL server 2K and thiry + databases ... I know how to backup each one, but was wondering if there is a bulk backup of the entire server. There are a couple of options that

RE: OT SQL SERVER Backup

2002-06-15 Thread Joshua Tipton
: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 15, 2002 7:01 PM To: CF-Talk Subject: RE: 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? ... I have SQL server 2K and thiry + databases ... I know how to backup

RE: OT SQL SERVER Backup

2002-06-15 Thread Stephen Hait
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

Re: OT SQL SERVER Backup

2002-06-14 Thread Marlon Moyer
Which version of SQL Server...SQL2000 has a copy database wizard that can create a DTS package that you can save and run later. At 08:54 PM 6/14/2002 -0400, you wrote: Is there an easy way to back up all the SQL server DB's and restore them on a separate Machine? - j