Server backup via FTP - Tilted Forum Project Discussion Community

j0hnb · 02-11-2006, 06:45 PM

I am trying to set up a windows server 2003 to backup via FTP. Windows doesn't have any built in automated FTP client, so I was looking into using a 3rd party application to handle this. Is this the best approach or how would you suggest that I do this. Should I write a server script to handle this? And if so can you please give me a good reference in order for me to do this myself. Sorry I am new to this side of servers so I would gladly do it myself, I just wanted to make sure I am taking the right approach to it. Thanks.

sailor · 02-12-2006, 04:35 AM

You should be able to write a pretty easy batch script to do it. FTP is pretty easy to control from the command line.

j0hnb · 02-12-2006, 05:00 AM

are there any good resource sites that you would suggest? Sorry I am new to this side of it. On linux I would know where to go but with a windows server I am a little behind.

asshopo · 02-12-2006, 09:19 AM

SyncBack (the freeware versoin, not the "I cost money" version) is a good utility that I use at work. It will allow you to setup directories. You can zip each directory, or whatever selection of directories you are backing up (the zip each directory is nice when you have TONS and TONS of files). You can then copy to a network share or ftp server. Then you can set a schedule for it to run at 3am or whatever.

Again, I use this at work to sync our file shares and cross-backup files from server to server. I then, being paranoid (or smart), burn DVDs of the stuff every so often and get them off site.

MikeSty · 02-12-2006, 09:21 AM

Looks neato, but what about registry items?

asshopo · 02-12-2006, 09:28 AM

Don't know of any off the top of my head, but you could write a batch/VBS file to basicly do:

REGEDIT.EXE [ /L:system ¦ /R:user ] /E exportfile "registry_key"

On the exportfile, append the date, run it once a day via the scheduler. Then have a cleanup VBS script to prune files older than x days/weeks/months.

I do some stuff like this on my Windows server that has mysql. I do mysql-dump and append the date. Use the DelOldFiles.VBS script to prune anything older than 7 days.

I can post example VBS scripts if anyone wants them, but I will not be liable if something goes wrong

. I know they work, I use them in production environments, but if someone makes a mistake setting it, it's not my fault, ya know?

kofspades · 02-12-2006, 02:41 PM

You could use Apache Ant. I know it's meant to be a Java (and other) build tool, but you can do quite a bit of different scripting with it. Just another option.

Dilbert1234567 · 02-13-2006, 09:07 PM

windows has a nice backup utility built right in, set up a shared folder on the server and have your system routinely backup to the folder.

http://www.microsoft.com/windowsxp/u..._03july14.mspx

asshopo · 02-14-2006, 06:05 AM

Dilbert,

I personally hate that software.. Ive tried a few times to get it to work properly and when I goto recover, I get files of 0 bytes. But, I prolly did something wrong, I know MS wouldn't blatantly put something THAT buggy out

.

Dilbert1234567 · 02-14-2006, 08:59 PM

heh, its not as powerful as professional options, but for basic data backup, it works great for me and my clients.

Nimetic · 02-16-2006, 02:50 AM

Windows has a command line FTP tool - I've used it to automate file transfers in the past (long time back). It was a bit of a hassle actually because the parameters differ slightly from UNIX.

I take it that you've looked at it and found it less than satisfactory?

In that case I was invoking the routine from SQL Server. These days I'd probably use the windows scheduler (via "explorer" or "at").

I'm not sure though that this is the right track. Why are you using FTP in the first place? No local backup options? What sort of machine are you FTP'ing to?

j0hnb · 02-16-2006, 04:58 AM

I don't mind doing it through command line FTP, I just don't know how to set that up to automatically run at a set time with a set set of values. Like the directory to upload, the FTP server and dir to put it in and all the login info.

There is a local backup, but with the fail being only 200 MB, it is no big deal to be extra safe and put it on a remote server.

02-11-2006, 06:45 PM	#1 (permalink)
j0hnb Crazy Location: Arnold, MD	Server backup via FTP I am trying to set up a windows server 2003 to backup via FTP. Windows doesn't have any built in automated FTP client, so I was looking into using a 3rd party application to handle this. Is this the best approach or how would you suggest that I do this. Should I write a server script to handle this? And if so can you please give me a good reference in order for me to do this myself. Sorry I am new to this side of servers so I would gladly do it myself, I just wanted to make sure I am taking the right approach to it. Thanks.

02-12-2006, 04:35 AM	#2 (permalink)
sailor beauty in the breakdown Location: Chapel Hill, NC	You should be able to write a pretty easy batch script to do it. FTP is pretty easy to control from the command line. __________________ "Good people do not need laws to tell them to act responsibly, while bad people will find a way around the laws." --Plato

02-12-2006, 09:19 AM	#4 (permalink)
asshopo Insane Location: Michigan	SyncBack (the freeware versoin, not the "I cost money" version) is a good utility that I use at work. It will allow you to setup directories. You can zip each directory, or whatever selection of directories you are backing up (the zip each directory is nice when you have TONS and TONS of files). You can then copy to a network share or ftp server. Then you can set a schedule for it to run at 3am or whatever. Again, I use this at work to sync our file shares and cross-backup files from server to server. I then, being paranoid (or smart), burn DVDs of the stuff every so often and get them off site. __________________ Patterns have a habit of repeating themselves.

02-12-2006, 09:28 AM	#6 (permalink)
asshopo Insane Location: Michigan	Don't know of any off the top of my head, but you could write a batch/VBS file to basicly do: REGEDIT.EXE [ /L:system ¦ /R:user ] /E exportfile "registry_key" On the exportfile, append the date, run it once a day via the scheduler. Then have a cleanup VBS script to prune files older than x days/weeks/months. I do some stuff like this on my Windows server that has mysql. I do mysql-dump and append the date. Use the DelOldFiles.VBS script to prune anything older than 7 days. I can post example VBS scripts if anyone wants them, but I will not be liable if something goes wrong . I know they work, I use them in production environments, but if someone makes a mistake setting it, it's not my fault, ya know? __________________ Patterns have a habit of repeating themselves.

02-12-2006, 02:41 PM	#7 (permalink)
kofspades Crazy	You could use Apache Ant. I know it's meant to be a Java (and other) build tool, but you can do quite a bit of different scripting with it. Just another option. __________________ Even if you stop the clock, it gives the right time twice a day. Once we get out of the eighties, the nineties are going to make the sixties look like the fifties.

02-12-2006, 05:00 AM	#3 (permalink)
j0hnb Crazy Location: Arnold, MD	are there any good resource sites that you would suggest? Sorry I am new to this side of it. On linux I would know where to go but with a windows server I am a little behind.

02-12-2006, 09:21 AM	#5 (permalink)
MikeSty The Computer Kid :D Location: 127.0.0.1	Looks neato, but what about registry items?

02-13-2006, 09:07 PM	#8 (permalink)
Dilbert1234567 Devils Cabana Boy Location: Central Coast CA	windows has a nice backup utility built right in, set up a shared folder on the server and have your system routinely backup to the folder. http://www.microsoft.com/windowsxp/u..._03july14.mspx __________________ Donate Blood! "Love is not finding the perfect person, but learning to see an imperfect person perfectly." -Sam Keen

02-14-2006, 06:05 AM	#9 (permalink)
asshopo Insane Location: Michigan	Dilbert, I personally hate that software.. Ive tried a few times to get it to work properly and when I goto recover, I get files of 0 bytes. But, I prolly did something wrong, I know MS wouldn't blatantly put something THAT buggy out . __________________ Patterns have a habit of repeating themselves.

02-14-2006, 08:59 PM	#10 (permalink)
Dilbert1234567 Devils Cabana Boy Location: Central Coast CA	heh, its not as powerful as professional options, but for basic data backup, it works great for me and my clients. __________________ Donate Blood! "Love is not finding the perfect person, but learning to see an imperfect person perfectly." -Sam Keen

02-16-2006, 02:50 AM	#11 (permalink)
Nimetic Junkie Location: Melbourne, Australia	Windows has a command line FTP tool - I've used it to automate file transfers in the past (long time back). It was a bit of a hassle actually because the parameters differ slightly from UNIX. I take it that you've looked at it and found it less than satisfactory? In that case I was invoking the routine from SQL Server. These days I'd probably use the windows scheduler (via "explorer" or "at"). I'm not sure though that this is the right track. Why are you using FTP in the first place? No local backup options? What sort of machine are you FTP'ing to?

02-16-2006, 04:58 AM	#12 (permalink)
j0hnb Crazy Location: Arnold, MD	I don't mind doing it through command line FTP, I just don't know how to set that up to automatically run at a set time with a set set of values. Like the directory to upload, the FTP server and dir to put it in and all the login info. There is a local backup, but with the fail being only 200 MB, it is no big deal to be extra safe and put it on a remote server. Last edited by j0hnb; 02-16-2006 at 05:01 AM..