SQL SERVER # 004. Secure Your SQL Server Database 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'
SELECT * FROM sys.symmetric_keys
CREATE CERTIFICATE BackupCertificate
WITH SUBJECT ='SQL Server 2014 Backup Encryption'
GO
BACKUP SERVICE MASTER KEY
TO FILE ='C:\SecureBackup\BackupKeys\SQL2014_SMK_Zebra.key'
ENCRYPTION BY PASSWORD='123456'
GO
BACKUP MASTER KEY
TO FILE='C:\SecureBackup\BackupKeys\SQL2014_DMK_Zebra.key'
ENCRYPTION BY PASSWORD='123456'
GO
BACKUP CERTIFICATE BackupCertificate
TO FILE='C:\SecureBackup\BackupKeys\SQL2014_BackupCertificate_Zebra.cer'
WITH PRIVATE KEY
(FILE='C:\SecureBackup\BackupKeys\SQL2014_CertificateKey_Zebra.key',
ENCRYPTION BY PASSWORD='123456')
GO
BACKUP DATABASE ZebraBarcodePrinter
TO DISK='C:\SecureBackup\ZebraBackupWithCert\ZebraSecureBackup.bak'
WITH
COMPRESSION,
ENCRYPTION
(
ALGORITHM=AES_256,
SERVER CERTIFICATE = BackupCertificate
)
GO
Source File:
https://drive.google.com/open?id=1fLh...
Learning .NET in Urdu Language please visit:
/ pkishar
For .NET samples please visit:
and On MSDN please Visit:
http://code.msdn.microsoft.com/site/s...