Microsoft SQL Server 2014 Unleashed
by Ray Rankins, Paul Bertucci, Chris Gallelli, Alex T. Silverstein
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access