How to backup Custom VM Servers with SQL installed, Where do I backup the Database, What should be the strategy

Abdul Khaliq 0 Reputation points
2023-05-26T08:13:14.9366667+00:00

How to backup Custom VM Servers with SQL installed, Where do I backup the Database, What should be the strategy

Azure Backup
Azure Backup
An Azure backup service that provides built-in management at scale.
1,125 questions
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,127 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. KarishmaTiwari-MSFT 18,442 Reputation points Microsoft Employee
    2023-05-26T14:49:45.7666667+00:00

    @Abdul Khaliq Thanks for posting your query on Microsoft Q&A.

    You can back up SQL Server VMs using two methods.
    For Single SQL Server Azure VM, you can enable backup on your SQL Server VM from the Backup pane in the VM. This method registers the SQL VM with the Azure Backup service to give it access and autoprotects all the SQL Server instances running inside the VM.
    For Multiple SQL Server Azure VMs, you can set up a Recovery Services vault and configure backup for multiple VMs.

    You can also back up a SQL Server database that’s running on an Azure VM to an Azure Backup Recovery Services vault. In this article, you’ll learn how to create and configure a vault, discover databases and set up backups.

    If you still have questions, please let us know in the "comments" and we would be happy to help you. Comment is the fastest way of notifying the experts.

    Please don’t forget to Accept Answer and hit Yes for "was this answer helpful" wherever the information provided helps you. This can be beneficial to other community members for remediation for similar issues.

    User's image

    0 comments