SQL Server #005: How to Securely Restore Your Database from Backup 🔒

Secure Your Database Backup STEP To create Backup Step 1. Create Database Master Key Step 2. Create Certificate Step 3. Backup Service Master Key Step 4. Backup Database Master key Step 5. Backup Certificate with Private Master Service Key Step 6. Backup your DB with certificate STEP To restore Backup to (new System or existing System) Step 1. Create Database Master Key with Same Passowrd Step 2. Drop Existing and Restore BackupCertificate Step 3. Create Database 'ZebraBarcodePrinter' Step 4. Restore database with secure backup file. SQL Script: CREATE MASTER KEY ENCRYPTION BY PASSWORD='123456' GO OPEN MASTER KEY DECRYPTION BY PASSWORD='123456' GO DROP CERTIFICATE BackupCertificate GO OPEN MASTER KEY DECRYPTION BY PASSWORD='123456' GO CREATE CERTIFICATE BackupCertificate FROM FILE='C:\SecureBackup\BackupKeys\SQL2014_BackupCertificate_Zebra.cer' WITH PRIVATE KEY ( FILE='C:\SecureBackup\BackupKeys\SQL2014_CertificateKey_Zebra.key', DECRYPTION BY PASSWORD='123456', ENCRYPTION BY PASSWORD='123456' ) GO OPEN MASTER KEY DECRYPTION BY PASSWORD='123456' GO ALTER CERTIFICATE BackupCertificate WITH PRIVATE KEY(DECRYPTION BY PASSWORD='123456') GO RESTORE DATABASE ZebraBarcodePrinter FROM DISK='C:\SecureBackup\ZebraBackupWithCert\ZebraSecureBackup.bak' WITH REPLACE, STATS=10 GO ALTER CERTIFICATE BackupCertificate WITH PRIVATE KEY(ENCRYPTION BY PASSWORD='123456') GO Source File: https://drive.google.com/drive/folders/1fLhvw8Sv3LiWlS5mDAWePZG7HHer0N_8?usp=sharing Secure Database Backup Link https://youtu.be/HBchUyLIDXc Learning .NET in Urdu Language please visit: http://www.youtube.com/user/pkishar For .NET samples please visit: http://www.a1vbcode.com/author.asp?name=Ishtiaq+Ahmed and On MSDN please Visit: http://code.msdn.microsoft.com/site/search?f%5B0%5D.Type=User&f%5B0%5D.Value=IsharPK