Monday, September 11, 2017

Backup Master Key for Encryption - DB Related

USE DBName
BACKUP MASTER KEY TO FILE = 'c:\masterkey'
    ENCRYPTION BY PASSWORD = 'Myw0rld123'

--RESTORE MASTER KEY
--    FROM FILE = 'c:\masterkey'
--    DECRYPTION BY PASSWORD = 'Myw0rld123'
--    ENCRYPTION BY PASSWORD = 'Myw0rld123'

--FORCE

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home