locked
SQL Server databases backup on Azure VM RRS feed

  • Question

  • I have two questions regarding SQL database backup on Azure VM:

    1. Does "Azure backup for SQL VM" allow backup of databases in SQL Server named instances? 

    If we install two SQL Server instances on same Azure VM, Automated backup does not consider the named instance. So my question is that if "Azure backup for SQL VM" will also follow the same approach.  

    2. I don't see Microsoft backup Server (MABS) and System Center DPM as an option to backup SQL Server on Azure VM. Can't we use them for instances in Azure VM? 

    Wednesday, June 20, 2018 2:22 PM

Answers

  • Yes, it works for named instances. 

    • Proposed as answer by vikranth s Wednesday, June 27, 2018 4:46 PM
    • Marked as answer by stripadba Thursday, June 28, 2018 3:38 AM
    Wednesday, June 27, 2018 12:48 PM

All replies

  • Q1. Does "Azure backup for SQL VM" allow backup of databases in SQL Server named instances? 

    Ans: Yes, The Azure Backup service displays all SQL instances with standalone databases, as well as SQL AlwaysOn availability groups. 

    Q2. I don't see Microsoft backup Server (MABS) and System Center DPM as an option to backup SQL Server on Azure VM. Can't we use them for instances in Azure VM? 

    Ans: You can use Microsoft Azure Backup Server (MABS) to take a backup of instances in Azure VM by installing MABS on Azure VM.  

    “If this answer was helpful, click “Mark as Answer” or Up-Vote. To provide additional feedback on your forum experience, click here

    • Proposed as answer by vikranth s Thursday, June 21, 2018 7:25 PM
    Wednesday, June 20, 2018 3:28 PM
  • Checking in to see if the above response helped to answer your query. Let me know if there are still any additional issues I can help with.

    Thursday, June 21, 2018 7:26 PM
  • Hi Vikranth,

    Thanks for your help.

    I wanted little more clarity on Q1.

    For example, if there is SQL VM SQLVM01 and I install two SQL instances:

    SQLVM01
    SQLVM01\SQL_TST2

    Please confirm if both the instances can be backed with "Azure Backup for SQL VM" especially SQLVM01\SQL_TST2.

    • Edited by stripadba Tuesday, June 26, 2018 3:33 PM
    Tuesday, June 26, 2018 3:31 PM
  • Yes, it works for named instances. 

    • Proposed as answer by vikranth s Wednesday, June 27, 2018 4:46 PM
    • Marked as answer by stripadba Thursday, June 28, 2018 3:38 AM
    Wednesday, June 27, 2018 12:48 PM