From the course: SQL Server 2016: Administer a Database Infrastructure
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Implement backup encryption - SQL Server Tutorial
From the course: SQL Server 2016: Administer a Database Infrastructure
Implement backup encryption
- [Instructor] If your physical servers are secure and users are connecting through trusted channels, you might not have a need to encrypt your data within the server itself. But if you perform backups and subsequently store those backups offsite, such as on a removable drive or in the cloud, then you might consider encrypting the backups before they leave the security of your on-premises location. We can do this by creating a certificate to encrypt the backup files. The certificate will stay under your control while the backup files can safely be stored offsite. Let's see how to do this by creating a new database and I'll call it Backup Example DB, but then we're actually just going to stay right inside of the master database. Then, inside of the master database, we'll create a master key. We'll use the encryption by password method and we'll supply the password of One Strong Password. Next, we'll create a certificate called Backup DB Cert. We'll add the subject line The Example DB…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.