[cfaussie] Re: Automatic FTP to back up SQL server
> we're looking for a program to install that backs up MS SQL server databases on a nightly basis, and saves them for X number of days This is built in, just setup a maintenance plan which will backup your DB's and save the files for X number of days. Regards Dale Fraser > -Original Message- > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On > Behalf Of Scott Thornton > Sent: Friday, 30 June 2006 1:27 PM > To: cfaussie@googlegroups.com > Subject: [cfaussie] Re: Automatic FTP to back up SQL server > > > Hi, > > MS SQL 2000 Data Transformation Services (DTS) has a FTP task.. Why not > use that? > > >>> [EMAIL PROTECTED] 30/06/2006 12:22 pm >>> > Has any one heard of or used any good automatic FTP backup solutions for > SQL > database (2000 and 2005)? > > we're looking for a program to install that backs up MS SQL server > databases > on a nightly basis, and saves them for X number of days > > Thanks > > Carl > > > > Postal: Po Box 3462 Dural, NSW 2158 > Email: mailto:[EMAIL PROTECTED] > FireFly Internet Phone: 80011777 > > > > > --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Automatic FTP to back up SQL server
Hi, MS SQL 2000 Data Transformation Services (DTS) has a FTP task.. Why not use that? >>> [EMAIL PROTECTED] 30/06/2006 12:22 pm >>> Has any one heard of or used any good automatic FTP backup solutions for SQL database (2000 and 2005)? we're looking for a program to install that backs up MS SQL server databases on a nightly basis, and saves them for X number of days Thanks Carl Postal: Po Box 3462 Dural, NSW 2158 Email: mailto:[EMAIL PROTECTED] FireFly Internet Phone: 80011777 --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---
[cfaussie] Re: Automatic FTP to back up SQL server
Hi Carl, you wrote: > Has any one heard of or used any good automatic FTP backup solutions > for SQL database (2000 and 2005)? > > we're looking for a program to install that backs up MS SQL server > databases on a nightly basis, and saves them for X number of days We use SyncBack (http://www.2brightsparks.com/syncback/syncback-hub.html) all over the place, an excellent tool. A typical use is to run a CF script to dump a DB into a spreadsheet and then FTP it off to the the side of the planet, or the exact opposite! We actually have both of those operations running on one clien'ts server :-) More mundanely doing automated, scheduled backups regimes is just where it is at. Note that copying MS SQL databases directly is not an easy task as they are often locked. The most economic way to manage it from a backup perspective is to schedule MS SQL to do a backup and then grab the backup file immediately afterwards. HTH, Kym K (About 3 months younger than Peter, in terms of CF at least!) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~--~~~~--~~--~--~---