There are many ways of making SQL Server database backups and there are as many methods as to how and where to store them. But are you sure that your method really convenient for you? What if you database backup plan is: a full backup twice a day, differential every four hours and transaction log backups every 30 minutes, and all these backups you need to send to Amazon S3. How much time will you spend every day to make all these backup? Fortunately, you can create a backup job with the help of SqlBak in a few minutes, which will make all backups according to your schedule and send them to Amazon S3.
How to Backup SQL Server to Amazon S3
Follow this simple steps and create a backup job which will make SQL Server backups and send them to Amazon S3 automatically.
Select the computer where SQL Server is installed and check your connection to SQL Server, then press “Continue to job settings”.
Choose the databases from the “Select databases” section, which you are going to backup.
To choose a destination place where your SQL Server database backups will be stored press “Add backup destination” in the “Store backups in selected destinations” section.
Select “Amazon S3” in the “Add destination” window.
In the “Amazon S3 Settings” window specify “Access key”, “Secret key”, and “Bucket”, to apply all settings press “Save & Close”.
Click “Schedule backup (full, diff, tran log)” and then press “Show advanced backup schedule” and set up the SQL Server backup schedule as needed.
All necessary backup job settings are done, press “Create” to save them and run the SQL Server backup job.
You can add additional job settings like Encryption and Compression, E-mail notifications in case of failure or success, also you can add Custom scripts or add some local folders to backup. To make such settings press “More settings…” at your “Settings of Backup” page.
As you can see it takes less than 5 minutes to create new SqlBak backup job which will make SQL Server database backups according to your schedule and send them to Amazon S3.