How to Backup SQL Server Databases with SQLBackupAndFTP
SQLBackupAndFTP is a software that backups SQL Server, MySQL, and PostgreSQL Server databases, performs regular full, differential, and transaction log backups, runs file/folder backup, zips and encrypts the backups, stores them on a network or on an FTP server or in the cloud (Amazon S3 and others - we're constantly adding more), removes old backups, and sends an e-mail confirmation on the job's success or failure[^1^].
In this article, we will show you how to backup SQL Server databases with SQLBackupAndFTP in a few simple steps.
Step 1: Download and Install SQLBackupAndFTP
You can download SQLBackupAndFTP from here. The download size is about 25 MB and it requires .NET Framework version 4.7.2 or above[^2^]. Once downloaded, run the installer and follow the instructions to complete the installation.
After installing SQLBackupAndFTP, launch the application and click on the \"New Backup Job\" button. You will see a window like this:
Here you can specify the name of the backup job, the SQL Server instance and database(s) you want to backup, the backup type (full, differential, or transaction log), the backup schedule, and the backup destination. You can also enable compression, encryption, verification, and cleanup options for your backups.
Step 3: Choose a Backup Destination
SQLBackupAndFTP allows you to store your backups on a network or on an FTP server or in the cloud. You can choose one or more destinations for your backups by clicking on the \"Add backup destination\" button. You will see a list of supported destinations like this:
Depending on the destination you choose, you may need to provide some additional information such as credentials, folder name, bucket name, etc. For example, if you choose Amazon S3 as your destination, you will need to enter your access key ID, secret access key, region, and bucket name.
Step 4: Configure Email Notifications
SQLBackupAndFTP can send you an email confirmation on the job's success or failure. To enable this feature, click on the \"Email confirmations\" tab and enter your email address. You can also customize the email subject and body, and choose when to receive email notifications (on success, on failure, or always).
Step 5: Run or Schedule the Backup Job
Once you have configured all the settings for your backup job, you can either run it manually by clicking on the \"Run Now\" button or schedule it to run automatically by clicking on the \"Schedule\" button. You can also edit or delete your backup job at any time by right-clicking on it in the main window.
SQLBackupAndFTP is a simple and reliable software that backups SQL Server databases with ease. It supports various backup types, destinations, options, and notifications. It also has a user-friendly interface and a comprehensive help section. You can download SQLBackupAndFTP from here and try it for free for 14 days. After that, you can upgrade it to Lite, Standard or Professional edition by purchasing a license key[^2^]. 0efd9a6b88