How To Backup A SQL IaaS Database

Overview

Azure SQL is a set of managed, secure, and intelligent SQL Server database products that run in the Azure cloud.

Support modern cloud applications with an intelligent, managed database solution that incorporates serverless compute in Azure SQL Database.

Azure SQL Managed Instance: With nearly 100 percent feature parity with the SQL Server database engine, modernize your existing SQL Server applications at scale with an intelligent fully managed instance as a service. For the majority of cloud migrations, this is the best option.

SQL Server on Azure VMs allows you to easily lift and transfer SQL Server workloads while maintaining 100 percent SQL Server compatibility and operating system-level access.

Database backups are an essential part of any business continuity and disaster recovery strategy because they protect your data from corruption or deletion.

The process to backup the database is:

1. RDP to the SQL Server where you need to make the backup

2. Open SSMS from the Start Menu on the server – right click it and run it as Administrator.

3. Expand Databases

4. Select the database you want to back up and right click it and select Tasks -> Back Up…

5. In the new window that opens, click Add in the Destination box.  The directory should populate – in most cases should go to a drive other than C to a Backups directory.  Pick a meaningful name that won’t conflict with others and click OK.

6. Click Backup Options and choose Set backup compression to Compress Backup and click OK

7. Ensure the backup completes successfully

Summary

In this article, we have learned how to Backup a SQL IaaS Database. That’s all in this article. Hope you like and enjoy this article.