Exporting Databases
ASD includes built-in capabilities for exporting databases to Azure Blob storage, and for creating ASD databases from these stored export results (a.k.a. BACPAC files, covered in the later section “Using BACPAC Files for Backup and Restore”). You can think of the Azure Export Service as a fully cloud-based, lightweight backup solution, however, because it relies on the uptime of different Azure service, it is not necessarily considered to be as reliable as the automatic, geo-replicated backups built into ASD. (The latter allows you to perform point-in-time restore [covered in the next section], while the former does not.) Let’s take a quick look at how to perform an ASD export.
The first step is to create an Azure Storage ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
