SiteMonitoringString

Cloud backup and recovery

Decrease downtime and protect your on-premises SQL Server data at low cost using Microsoft Azure

Cloud backup and disaster recovery can be set up and managed directly within SQL Server Management Studio, leveraging your existing skills and tools.

Download Backup to Microsoft Azure Tool for all versions of SQL ServerRead Cloud Backup and Disaster Recovery White Paper Download the SQL Server 2014 trialTry Microsoft Azure
Cloud backup and recovery

Together with Microsoft Azure, SQL Server can help you reduce costs, lower RTO and improve your backup and disaster recovery capabilities. SQL Server Backup to Microsoft Azure enables you to configure your backups to be stored in the cloud. The backup files can be compressed and encrypted for fast, secure storage. This enables greater data protection in addition to on-premises backup, or to cost-effectively scale your back-ups to additional applications. You also gain the benefits of Microsoft Azure, with global datacenters which offer geographically redundant storage at a lower cost than maintaining additional hardware.

New in SQL Server 2014, Managed Backup to Microsoft Azure schedules, performs and maintains backups based on the activity of the data, eliminating the need for custom code and manual backups. For older database versions, the standalone SQL Server Backup to Microsoft Azure Tool enables you to take advantage of encrypted and compressed backups to Microsoft Azure across your SQL Server environment.

In addition, you can achieve high availability and faster recovery using active AlwaysOn replicas in the cloud. With SQL Server 2014, you easily create asynchronous replicas using a Microsoft Azure Virtual Machine as part of your AlwaysOn solution. You can also use multiple Microsoft Azure Virtual Machines as replicas for backup or reporting purposes.

Also in SQL Server 2014, you can move your database files to Microsoft Azure while keeping your applications on premises for bottomless storage in the cloud and greater availability. The SQL Server Data Files in Microsoft Azure configuration also provides an alternative storage location for your database backup files by allowing you to restore from or to Microsoft Azure Storage.

Benefits

  • Take the work out of backup and recovery planning
  • Lower total cost of ownership through decreased CAPEX and OPEX
  • Reduce recovery times and come back quickly from database outages
  • Help secure backups with encrypted backups to Microsoft Azure
  • Achieve greater data protection using Microsoft Azure’s geographic redundancy
  • Extend data anywhere with SQL Server Data Files in Microsoft Azure