Database Backup Location is AZURE!
Introduction
SQL Server backups are an essential part of every good disaster recovery strategy. But setting up such backups to run effortlessly, is the goal. In this article, we will show you how schedule backups automatically setting up SQL Server backups on a schedule to Azure Storage Account.
This method is suitable for SQL Server and Azure SQL Managed Instance.
Prerequisites
· Azure Storage Account
· sysadmin role on the login role
· Sample AdventureWorks Database
· SQL Server Any Edition and SSMS
Steps to setup the environment –
Step 1 — Create an Azure Storage Account and a Container
Step 2 — Connect your SQL Server with SSMS
Step 3 — Expand and Right Click Management and open Management Plan Wizard
Step 4 — Fill the details and select the Scheduling Time. I schedule it to run this Job every 1 hour, Daily.
Step 5 — Select the Database Backup Type
Step 6 — Select the required Database name and Backup to URL option
Step 7 — Go back to Server, Expand Security -> Right Click on Credentials and select New Credential
Step 8 — Write Azure Storage Account Name in Identity Box. Paste Storage Account Access Keys in Password
Step 9 — Select the SQL Credentials which we have created in previous Step. Write Storage Container name in the next field. Verify the URL Prefix and backup extension type.
Step 10 — Click on Next and Finish the Management Wizard.
Step 11 — Expand Maintenance Plan and you can see a backup job is created. Right Click on the Job and click on execute
Step 12- After the job ran successfully, you can monitor your job by clicking on View History.