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”. Select a computer where SQL Server is installed and check for SQL Server connections. When everything is ready, press “Continue to job settings”. Choose databases which you are going to backup from the box. 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. In the “Add destination” window select “FTP Server”. 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. Click “Schedule backup (full, diff, tran log)” to set up backup settings, press “Show advanced backup schedule” and set up the schedule as needed. To apply all settings and run the backup job press “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. 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.