Backup is an important task you should put on the very first priority. This tutorial is going to show you how to backup SQL Server databases using SQLBackupAndFTP. SQLBackupAndFTP is a commercial software but it also offers free version. But, if you need more feature, we recommend to upgrade to SQLBackupAndFTP full version. OK, let’s get started.
Why we love this software
- It allows us to backup both local and remote SQL Server
- Supports local, FTP and many cloud storage for backup destination
- Easy to use and pretty simple
Backup SQL Server Database
First, download and install SQLBackupAndFTP installation file. I run this program on Windows 10 Professional. You may interested to read my review of this SQL backup software for Windows. After install, run the program. On the main window, you need to create a new backup job. Click the + sign on the left to start creating a new backup job. Select Add a New Backup Job from the list.
There are some sections that we need to configure. First, let’s connect to our server. Click the gear icon next to Connect to Server. You can either connect to local SQL Server or remote server.
Don’t forget to test the connection to make sure you can connect to the server. Next, we need to select the database to backup. You can backup more than one databases at once.
Next, we need to configure the backup destination. SQLBackupAndFTP supports many backup destinations including Amazon S3, Google Drive, Dropbox, OneDrive as well as local directory and FTP servers. In this example, I put my backup on a local disk.
With this software, we can easily configure the backup interval. We can set the schedule when the backup will be executed automatically. We can also set the email notification.
To start the backup task, simply click Run Now. Or if you already set the schedule, let the schedule manage your next backup task.