locked
Backup of SQL Server database on Azure VM RRS feed

  • Question

  • Hi!

    We created an Azure VM for one of our customers. On that VM we are running a Windows Service that stores data to an SQL Server database. It's very important that the stored data in that DB on that VM is not lost.

    So, how should be backup the DB (files)? Should we prefer a SQL Server DB backup and download this backup or should we create "Capture" the VM via the Azure portal

    Are there any other possibilities or what are the best practices here for our case? (Btw. we are not using availability sets? Should we?)

    Monday, September 1, 2014 9:05 AM

Answers

  • Hi Thomas,

    Please make sure that the two VMs are in the same cloud service since an availability set only supports the VMs in the same cloud service.

    Best regards,

    Susie 

    • Marked as answer by Thomas ET Tuesday, September 2, 2014 8:55 AM
    Tuesday, September 2, 2014 1:40 AM
  • Hi Thomas,

    Thanks for posting your query here.

    I understand that you are using an Azure VM which has data that is used from the SQL server database. Backing up data in SQL Server databases is an important part of the strategy in protecting against data loss due to application or user errors. See Backup and Restore for SQL Server in Azure Virtual Machines

    The AlwaysOn Availability Groups feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring

    See High Availability and Disaster Recovery for SQL Server in Azure Virtual Machines

    To reduce the impact of downtime due to one or more of events like planned maintenance or unplanned maintenance or disasters etc., It is recommended to have the high availability best practices for your virtual machines by :

    1. Configure multiple virtual machines in an Availability Set for redundancy
    2. Combine the Load Balancer with Availability Sets
    3. Avoid single instance virtual machines in Availability Sets

    See Manage the availability of virtual machines.

    Recommend you to go through this blog which talks about understanding availability sets.

    Hope this helps.

    Regards,

    Shirisha Paderu.

    • Proposed as answer by Shirisha Paderu Monday, September 1, 2014 10:54 AM
    • Marked as answer by Thomas ET Monday, September 1, 2014 3:35 PM
    Monday, September 1, 2014 10:54 AM

All replies