Azure

How To Backup A SQL IaaS Database

Overview

Azure SQL is a set of managed, safe, and clever SQL Server database merchandise that run within the Azure cloud.

Assist trendy cloud purposes with an clever, managed database answer that comes with serverless compute in Azure SQL Database.

Azure SQL Managed Occasion: With practically 100 % function parity with the SQL Server database engine, modernize your current SQL Server purposes at scale with an clever absolutely managed occasion as a service. For almost all of cloud migrations, that is the best choice.

SQL Server on Azure VMs means that you can simply elevate and switch SQL Server workloads whereas sustaining 100 % SQL Server compatibility and working system-level entry.

Database backups are a necessary a part of any enterprise continuity and catastrophe restoration technique as a result of they shield your knowledge from corruption or deletion.

The method to backup the database is:

1. RDP to the SQL Server the place you might want to make the backup

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

3. Increase Databases

4. Choose the database you wish to again up and proper click on it and choose Duties -> Again Up…

5. Within the new window that opens, click on Add within the Vacation spot field.  The listing ought to populate – generally ought to go to a drive aside from C to a Backups listing.  Choose a significant identify that gained’t battle with others and click on OK.

6. Click on Backup Choices and select Set backup compression to Compress Backup and click on OK

7. Make sure the backup completes efficiently

Abstract

On this article, now we have discovered Backup a SQL IaaS Database. That’s all on this article. Hope you want and revel in this text.

Tags
Show More

Related Articles

Leave a Reply

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

Close