Skip to content

sql-server-vm.md

Latest commit

 

History

History
46 lines (33 loc) · 1.39 KB

sql-server-vm.md

File metadata and controls

46 lines (33 loc) · 1.39 KB
title SQL Server and Azure VM
theme default

Table of Contents

  1. SQL Server and Azure Virtual Machines
  2. When to run a SQL Server on a VM
  3. Backups
  4. Azure Resource Management
  5. Azure Storage

SQL Server and Azure Virtual Machines

NOTE laas are SQL servers running on Azure virtual machines.

When to run a SQL Server on a VM:

  • When there is incompatibility with your projects. For example, if you are working with a third party that is using an older version of a SQL Server.
  • Using other SQL Server Services. Such as:
    Name Service
    SSAS SQL Server Analysis Services
    SSIS SQL Server Integration Services
    SSRS SQL Server Reporting Services

Backups

Sometimes you need to back up your data! There are two services Azure offers:

  • Back up to URL: standard backup syntax
  • Azure Backup: more complete services; offers automated backups

Azure Resource Management

This is a service that allows deployment for cloud services and manages databases. All Azure resources will end up as JSON documents known as Azure Resource Manager templates. It gives all information needed for deployment.

Azure Storage

Four types:

  • Standard
  • Standard SSD
  • Premium SSD
  • Ultra Disk