Join Martin Guidry for an in-depth discussion in this video Encryption, part of SQL Server 2014 Backup and Recovery.
- [Voiceover] In this section, we'll talk about…encrypting backups in Sequel Server.…Encrypting a backup is certainly a good idea…for backups that leave your possession.…If you move your backup tapes off-site,…certainly there could be some security concerns.…We can alleviate most of these concerns…by encrypting the backup.…In order to encrypt the backup, we will need a certificate.…And, in order to create a certificate,…we will need a master key for the database.…So, if you don't already have a master key,…I'll show you how to create one.…
If you already have one, you don't need another one.…We'll need to create this key in the master database.…So, the syntax is "Use Master"…to make sure we do it in the master database.…Create master key by password, then the equal sign,…then in single quotes you give it a password.…Obviously, you want to use something long and complex.…I'll hit "Execute."…Commands completed successfully, that's great!…Now, we'll create a certificate also in the master database…so the syntax will be "Use Master,"…
- 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
Installing and Administering Microsoft SQL Server 2014with Ron Davis3h 41m Intermediate
SQL Server 2014 Essential Trainingwith Martin Guidry3h 51m Intermediate
Migrating Access Databases to SQL Serverwith Adam Wilbert2h 39m 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.