How to Backup SQL Server to Azure Storage

How to backup SQL Server to Azure Storage (logo)You can perform SQL Server database backups in many ways, for example, you can make backups with the help of T-SQL Commands or SSMS. Also, you can choose a destination where your SQL Server backups will be stored, let’s say, Azure Storage. But how much time does it take to create SQL Server backup and then sent it to Azure Storage? With the help of SQLBackupAndFTP, you can perform a backup and then send it for storing to Azure Storage in a few minutes.

How to backup SQL Server to Azure Storage

Follow this simple steps to create a backup job, which will make backups according to your schedule and then send them to Azure Storage automatically:

  1. After you have downloaded and installed SQLBackupAndFTP run it and select all databases which you need to backup. To do it click the gear button at “Select database” section. How to backup SQL Server to Azure Storage (select database)
  2. Go to the “Store backups in selected destinations” and select “Azure Storage” from the list. How to backup SQL Server to Azure Storage (select a destination place)Specify your Azure Storage “Account name”, “Access  Key” and “Container Name” and press “Test” to check the connection. Click “Save & Close” to apply all setting. How to backup SQL Server to Azure Storage (Test destination place)
  3. Turn on “Schedule backups” and press the gear button to set up a schedule for your backup job. How to backup SQL Server to Azure Storage (schedule)
  4. Press “Run Now” to make SQL Server backup immediately.How to Backup SQL Server to Azure Storage (Run Now)
[Total: 7    Average: 4.4/5]

Leave a Reply

Your email address will not be published.