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