How to Backup SQL Server to Amazon S3

How to Backup SQL Server to Amazon S3 (logo)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.

Open your Dashboard page and click “Add new job”, then choose “Add backup job”. How to Backup SQL Server to Amazon S3 (job)

Select the computer where SQL Server is installed and check your connection to SQL Server, then press “Continue to job settings”. How to Backup SQL Server to Amazon S3 (connection)

Choose the databases from the “Select databases” section, which you are going to backup. How to Backup SQL Server to Amazon S3 (databases)

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. How to Backup SQL Server to Amazon S3 (add backup destination)

Select “Amazon S3” in the “Add destination” window. How to Backup SQL Server to Amazon S3 (destination)

In the “Amazon S3 Settings” window specify “Access key”, “Secret key”, and “Bucket”, to apply all settings  press “Save & Close”. How to Backup SQL Server to Amazon S3 (settings)

Click “Schedule backup (full, diff, tran log)”  and then press “Show advanced backup schedule” and set up the SQL Server backup schedule as needed. How to Backup SQL Server to Amazon S3 (schedule)

All necessary backup job settings are done, press “Create” to save them and run the SQL Server backup job. How to Backup SQL Server to Amazon S3 (create)

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.
How to Backup SQL Server to Amazon S3 (more settings)

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.

[Total: 2    Average: 5/5]

Leave a Reply

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