Backup and restore of encryption keys and restoring

USE master;

/*************************************************************

CREATE YOUR MASTER KEY AND YOUR CERTIFICATE FOR TDE AND ALL OTHER TYPES

OF ENCRYPTION

*************************************************************/
OPEN MASTER KEY DECRYPTION BY PASSWORD = 'Isthis@securePa$word?';

BACKUP MASTER KEY TO FILE = 'c: \work\exportedmasterkey' ENCRYPTION BY PASSWORD = 'abcd@1234';
GO

BACKUP CERTIFICATE MyServerCert TO FILE = 'c: \work\MyServerCert'
WITH PRIVATE KEY (
		FILE = 'c: \work\MyServerCertKey'
		,ENCRYPTION BY PASSWORD = '997jkhUbhk$w4ez0876hKHJH5gh'
		);
GO

/**********************************

DROP CERTIFICATE MyServerCert

DROP MASTER KEY

GO

***********************************/
/**********************************

RESTORING YOUR MASTER KEY AND CERTIFICATE ON ANOTHER SYSTEM

***********************************/
RESTORE MASTER KEY
FROM FILE = 'c: \work\exportedmasterkey' DECRYPTION BY PASSWORD = 'abcd@1234' ENCRYPTION BY PASSWORD = 'Isthis@securePa$word?' FORCE

OPEN MASTER KEY DECRYPTION BY PASSWORD = 'Isthis@securePa$word?';

CREATE CERTIFICATE MyServerCert
FROM FILE = 'c: \work\MyServerCert'
WITH PRIVATE KEY (
		FILE = 'c: \work\MyServerCertKey'
		,DECRYPTION BY PASSWORD = '997jkhUbhk$w4ez0876hKHJH5gh'
		);
GO

OPEN MASTER KEY DECRYPTION BY PASSWORD = 'Isthis@securePa$word?';

USE [master]

RESTORE DATABASE [AirlinePerformanceTuningDB]
FROM DISK = N'G: \Program Files\SQL Server\SQL2019B\MSSQL15.SQL2019B\MSSQL\Backup\TUNINGTDE.BAK'
WITH MOVE 'AirlinePerformanceTuningDB' TO 'G: \Program Files\SQL Server\SQL2019B\MSSQL15.SQL2019B\MSSQL\DATA\tde.mdf'
	,MOVE 'AirlinePerformanceTuningDB_log' TO 'G: \Program Files\SQL Server\SQL2019B\MSSQL15.SQL2019B\MSSQL\DATA\tde.ldf';
GO

Please Consider Subscribing

Subscribe