Re: OT SQL SERVER Backup

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

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

OT SQL SERVER Backup

2002-06-14 Thread Jim Curran
Is there an easy way to back up all the SQL server DB's and restore them on a separate Machine? - j __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq

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