How to auto-upload MSSQL backups to FTP

Ask questions about dedicated servers here and we and other users will do our best to answer them. Please also refer to the self-help section for tutorials and answers to the most commonly asked questions.
Post Reply
Nada
New to forums
New to forums
Posts: 6
https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
Joined: Fri Feb 20, 2015 6:23 am

How to auto-upload MSSQL backups to FTP

Post by Nada »

Hi, does someone know how to auto-upload the lastest MSSQL backups to an FTP everyday?

Thanks you in advance.
User avatar
soja
This is my homepage
This is my homepage
Posts: 2389
Joined: Fri May 18, 2012 3:20 pm

Re: How to auto-upload MSSQL backups to FTP

Post by soja »

I use rsync on Linux, you may be able to make a bash script to download a FTP directory in intervals. This would require a linux client machine.
Not a NFO employee
Nada
New to forums
New to forums
Posts: 6
Joined: Fri Feb 20, 2015 6:23 am

Re: How to auto-upload MSSQL backups to FTP

Post by Nada »

Im using Windows Server 2008 R2, it is a dedicated server i want to auto-backup MSSQL databases and then upload them everyday to my FTP to store them outside the machine. Does someone know how to program auto-backup for MSSQL and the auto-upload to my FTP?
User avatar
soja
This is my homepage
This is my homepage
Posts: 2389
Joined: Fri May 18, 2012 3:20 pm

Re: How to auto-upload MSSQL backups to FTP

Post by soja »

Does MSSQL provide remote backup tools? I know I can mysqldump from a remote machine and store the .sql files locally.
Not a NFO employee
Post Reply