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 -~----------~----~----~----~------~----~------~--~---