How to Backup SQL Server to FTP Server

Copy of Destinations (3)One of the most popular ways how to create SQL Server database backup is to use SSMS or T-SQL Commands. But  what if your backup plan is full backups twice a day, differential backups every 4 hours and transaction log backups every 30 minutes and you prefer to store all SQL Server database backup on FTP Server. How much time will you spend each day to complete such scenarios? You can simple tune SqlBak backup job just in few minutes, which will make SQL Server database backups according to your schedule and send them to FTP Server.

Backup SQL Server to FTP Server

To create a backup job go at Dashboard page and click “Add new job”, then choose “Add backup job”. Backup SQL Server to FTP Server (job)Select a computer where SQL Server is installed and check for SQL Server connections. When everything is ready, press “Continue to job settings”. Backup SQL Server to FTP Server (connection)Choose databases which you are going to backup from the box. Backup SQL Server to FTP Server (databases)Now you need to select a place where your SQL Server database backups will be stored. To do that press “Add backup destination” link in the “Store backups in selected destinations” menu. Backup SQL Server to FTP Server (add backup destination)In the “Add destination” window select “FTP Server”. Backup SQL Server to FTP Server (FTP)In the “FTP Settings” window specify “Host address”, “User name” and “Password”, to connect to your FTP Server. Press “Test” to check settings and “Save & Close” to apply them. Backup SQL Server to FTP Server (FTP Server)Click “Schedule backup (full, diff, tran log)” to set up backup settings, press “Show advanced backup schedule” and set up the schedule as needed. Backup SQL Server to FTP Server (schedule)To apply all settings and run the backup job press “Create”. Backup SQL Server to FTP Server (Create)Also, you can click “More settings…” at your “Settings of Backup” page to find more different backup settings such as  Encryption and Compression, E-mail notifications in case of failure or success, also add some local folders to backup or add Custom scripts. Backup SQL Server to FTP Server (more settings)As you can see it takes less than 5 minutes to create SqlBak backup job which will make backups according to your schedule and send them to FTP Server.

[Total: 1    Average: 5/5]

Leave a Reply

Your email address will not be published. Required fields are marked *