Join Martin Guidry for an in-depth discussion in this video Backing up to the cloud, part of Microsoft SQL Server 2014: Backup and Recovery.
- [Voiceover] In this section, I'm going to talk about…backing up Microsoft SQL Server to the cloud,…specifically, the Microsoft Azure cloud.…This functionality was added in SQL Server 2012…and then has been improved in 2014.…Before we perform the backup,…I'll need to do a little prep work in Azure,…make sure my Azure account is ready to receive the backup.…Most of this stuff are things…you would only need to do once.…Then once your account is prepared to receive SQL backups,…you could just run the backups over and over.…
The first step, we're going to create a…storage account in Azure.…In that storage account, we'll configure BLOB storage.…Then in SQL Server,…we'll need to need to create a set of credentials…that will allow it to log in to my Azure account.…And in the last step,…we'll actually perform the backup to the cloud.…That step is really the easiest.…It's very similar to all the other backups we've done,…just a few more options to configure.…First, let's create a storage account in Azure.…I have the Azure portal pulled up here.…
- Types of backups
- Media sets and backups
- Performing a basic backup using the GUI or command line
- Performing a basic restore using the GUI or command line
- Backing up and restoring logs
- Doing partial backup and restores
- Automating backups
- Using encryption and compression
Skill Level Intermediate
SQL Server 2014 Essential Trainingwith Martin Guidry3h 51m Intermediate
SQL Server 2014: Installation and Administrationwith Ron Davis3h 40m Intermediate
Migrating Access Databases to SQL Serverwith Adam Wilbert2h 38m Intermediate
1. Backups in General
4. Partial Backups and Restores
5. Other Backup Topics
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.