Have your Desktop computer login to your server and retrieve your backup files while you sleep
The ides is to use WinSCP to do this for us:
First we need to create a windows user with limited privileges on a Windows 7 :
Go to Control Panel, Click "add or Remove User Accounts", Then "Create a new Account" and select "Standard User", name it Backup (or anything else)
once that's done create a password for this new user : Click on it then "create a new password"
3. Click Start ---> under "shut down" click switch user and logon to your newly created backup user : This will automatically create a backup folder C:\Users\backup : and this is where we are going to store our (daily | weekly | monthly) backups
Now click Start --- > switch accounts again and logon under the main Administrator account … Click
computer ---> Local Disk C: ---> users ----> backup , Grant yourself to permanently access this folder. We are done with this Step. Next we are goint to download and install WinSCP:
http://winscp.net/eng/download.php#download2 Dowanload the latest installer
The next step involves writing a small script for WinSCP like so :
Open NotePad and copy paste this Script and replace the relevant bits with your own informations :
HTML:
option batch on
option confirm off
# Here goes your sever ftp login information The formatis user:assword@host
open YOUR_BACKUP_USERNAME:YOUR_BACKUP_PASSWORD@YOUR_IP_ADDRESS
# This is the path where your backup zipped file is stored on your remote server. It must be under /home/your_user_name/ directory
cd /home/your_user_name
# Force binary mode transfer
option transfer binary
# Download backup file (this is your compressed public directory backup) to the local directory
get backup.gz C:\Users\backup\
# Download backup MySQL (This is your compressed Mysql Dump file) to the local directory
get Mysql.sql.gz c:\users\backups\
# Disconnect
close
# Exit WinSCP
exit
Save this file and name it automate.txt under c:\users\backup
switch users again to backup : click start ---> switch users and select the backup user
Once logged in click start, type in CMD in that little search box : you will get a command prompt window
Type in the command line : C:\Program Files\WinSCP\winscp.exe" /console /script=c:\users\backup\automate.txt
Click Yes to accept the key
The next step is to tell Windows to wake up daily | weekly | monthly | to run the script we just created to download our backup files
Go to the Start button
Select Settings > Control Panel
Select Scheduled Tasks to open the Scheduled Task Wizard
Select Add Scheduled Task and click Next
Locate and select WinSCP on the program list and click Next
Enter a name for the task (anything really but name it something that makes sense to you), select the task frequency ( this should be set based on the frequency your server cron job is backing up your data), click Next
Enter and confirm your Windows user account password for the task's RunAs credentials (This is the backup user/password we created above) and click Next
Check the Open advanced properties for this task when I click Finish box
Click Finish to exit the Scheduled Task Wizard and open the task's properties dialog
Add /console /script=c:\users\backup\automate.txt
Click Finish to exit the Scheduled Task Wizard and open the task's properties dialog
Click Apply and confirm your Windows user account password if prompted
Click OK to exit the task's properties dialog
From the Scheduled Tasks window, right-click on your WinSCP backup task and select Run to test the new task
That's it we're done
Make sure your server is taking backups daily for WinSCP to logon and grab those files for you
