How to Backup SQL Server to Windows Azure

Copy of DestinationsThere are many ways how to make SQL Server database backups, for example, you can perform backups with the help of T-SQL Commands or SSMS. Also, you can choose a destination where your SQL Server backups will be sent for storing, for example, Windows Azure. But how much time does it take to create a backup and then sent it to Window Azure? With the help of SqlBak, you can perform a backup and then send it for storing to Windows Azure in a few minutes.

How to backup SQL Server to Windows Azure

You can create a backup job, which will make backups according to your schedule and then send backups to Windows Azure, by following this simple steps:

  1. Go to the Dashboard page and click “Add new job”, then choose “Add backup job”.How to Backup SQL Server to OneDrive for Business (job)
  2. Select a computer where SQL Server is installed and check for SQL Server connections, then click “Continue to job settings”.How to backup SQL Server to Windows Azure (connection)
  3. At the”Select databases” menu, check off all databases wich you are going to backup. How to backup SQL Server to Windows Azure (databases)
  4. Choose the backup destination in the “Store backups in selected destinations”. How to backup SQL Server to Windows Azure (add backup destination)In the “Add destination” window choose “Windows Azure Storage”. How to backup SQL Server to Windows Azure (Windows Azure)In the opened window specify your Account, Key, and Container, then press “Test” to check the connection to your account and click “Save & Close” to apply all new settings. How to backup SQL Server to Windows Azure (Windows Azure settings)
  5. To create a backup schedule click “Schedule backup (full, diff, tran log)” section and press “Show advanced backup schedule” then set up the schedule as needed. How to backup SQL Server to Windows Azure (schedule)
  6. Press “Create” to apply all changes and start a backup job. How to backup SQL Server to Windows Azure (Create)

Now your backup job is ready, all backups will be made  according to your schedule and then sent to Windows Azure. Also, you find more different settings like E-mail notifications in case of failure or success, Compression and Encryption, you can add some local folders to backup or specify Custom scripts. And this is not the exhaustive list of benefits SqlBak offers.

[Total: 1    Average: 5/5]

Leave a Reply

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