RE: OT SQL SERVER Backup
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. 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
RE: OT SQL SERVER Backup
To backup all databases use a database maintenance plan to backup them up to the local server then have it run a script on completion to copy the files to the other server then when that job is finished have it run the restore of the databases. Joshua Tipton -Original Message- From: 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 each one, but was wondering if there is > a bulk backup of the entire server. 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. Alternatively, you can use T-SQL to automate the backup and restore process; on the source database server, run the BACKUP DATABASE command through any database. OSQL is a handy command-line client for doing this sort of stuff. Since you want to backup the entire server, you'll probably want to write a T-SQL batch to query the master database to find out about each database, then loop over that information. I'll bet you can find a useful script for that here: http://www.swynk.com/sqlscripts/backuprest7.asp Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Get the mailserver that powers this list at http://www.coolfusion.com 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
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 each one, but was wondering if there is > a bulk backup of the entire server. 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. Alternatively, you can use T-SQL to automate the backup and restore process; on the source database server, run the BACKUP DATABASE command through any database. OSQL is a handy command-line client for doing this sort of stuff. Since you want to backup the entire server, you'll probably want to write a T-SQL batch to query the master database to find out about each database, then loop over that information. I'll bet you can find a useful script for that here: http://www.swynk.com/sqlscripts/backuprest7.asp Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
RE: OT SQL SERVER Backup
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. - j > -Original Message- > From: Marlon Moyer [mailto:[EMAIL PROTECTED]] > Sent: Saturday, June 15, 2002 12:24 AM > To: CF-Talk > Subject: Re: OT 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 > > > > > > > __ 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
Re: OT SQL SERVER Backup
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
Re: OT 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 > > > __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
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 __ Get the mailserver that powers this list at http://www.coolfusion.com 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