Encrypted Backups | Microsoft SQL Server | Business Continuity | Data Science | Techie Vineet
#sqlserver #sqlforbeginners #sqlab #database #databasesystems #sql #sqltips #databaseconcepts #databases #databaseprogramming #databasedevelopment #databaseadmin #ssis #ssms #indexing #backupdata #sqlinterviewquestions #sqltraining #microsoftsqlserver
Encrypted Backups | Microsoft SQL Server | Business Continuity | Data Science | Techie Vineet
This video discusses about Backup Encryption process including encryption algorithm and encryptor (certificate or symmetric key). We also discussed about the importance of backing up certificate and private key to the offsite location so that it can be retrieved during any disasters. If we lose encryption certificate or private key, we won't be able to decrypt the encrypted backup.
We then discussed on the process to restore the backup and we have demonstrated the procedure to take encrypted backup of a database. This includes the following steps:
1. Create a database master key (DMK).
2. Create a backup certificate
3. Create an encrypted database backup.
We then demonstrated the process to restore this encrypted backup:
1. BAC KUP CERTIFICATE in the old database.
2. CREATE MASTER key in the new location master database.
3. CREATE CERTIFICATE from the backup certificate of the old database
imported to a location on the new server.
4. Restore the database to a new location.
We then talked about the benefits of using encrypted databases. We also discussed about the prerequisites and restrictions applicable before taking any encrypted backups. We finally talked about the recommended practices for taking encrypted database backups.
My Channel Page : / @techie-vineet
SQL Server Database Design Playlist : • SQL Server - Database Design - SQL Course ...
Business Continuity Playlist : • Microsoft SQL Server - Business Continuity...
SQL Server Indexing Playlist : • SQL Server - Indexes
SQL Server Performance Tuning Playlist : • SQL Server - Performance Tuning
SQL Server Integration Services Playlist : • SQL Server Integration Services
SQL Server Tables Playlist : • SQL Server - Tables
En esta página del sitio puede ver el video en línea Encrypted Backups | Microsoft SQL Server | Business Continuity | Data Science | Techie Vineet de Duración hora minuto segunda en buena calidad , que subió el usuario Techie Vineet 12 agosto 2024, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 112 veces y le gustó 0 a los espectadores. Disfruta viendo!
