TO DISK = 'E:\GKKeys\smGKFULLEncrtypted. ,ENCRYPTION BY PASSWORD = 'smGK_BackupCertificate_BACKUP_Password'Ĭreating the backup: BACKUP DATABASE smGK SQL command to restore the database On the command line copy past the following command and click enter. Enter the command: SQLCMD -S SERVERNAME E Change the SERVERNAME with yours and click enter. TO FILE = 'E:\GKKeys\SMGK_BACKUP_CERTIFICATE.cer'įILE = 'E:\GKKeys\SMGK_BACKUP_CERTIFICATE_PRIVATE_KEY.key' Connect using SQLCMD in order to be able to restore the database from command line. I am doing the following steps:Ĭreate and backup database master key in the master database which is going to be used to encrypt our certificates USE MASTER ĮNCRYPTION BY PASSWORD = 'MasterKey_Password' ĮNCRYPTION BY PASSWORD = 'MasterKey_BACKUP_Password' Ĭreate and back up the certificate that is going to be used for encryption: USE MASTER I want to create an encrypted backup on one of the databases and then restore it on the second instance. I have two SQL Server instances on same machine.
0 kommentar(er)
