RESTORE SERVICE MASTER KEY

Import a service master key from a backup.

Syntax:
       RESTORE SERVICE MASTER KEY FROM FILE = 'path_to_file' 
          DECRYPTION BY PASSWORD = 'password' [FORCE]

During a restore, SQL Server will decrypt all the keys and secrets with the current service master key, and then encrypt them with the restored service master key.
If any one of the decryptions fails, the restore will fail. You can use the FORCE option to ignore errors and replace the service master key, but this option will cause the loss of any data that cannot be decrypted.

Example

 RESTORE SERVICE MASTER KEY FROM FILE = 'c:\backups\service_master_key' 
    DECRYPTION BY PASSWORD = 'key_P@ssw0rdGqw0956565';
 GO

"But I have learned a thing or two; I know as sure as fate,
When we lock up our lives for wealth, the gold key comes too late" ~ Will Carleton

Related Commands:

ALTER SERVICE MASTER KEY
BACKUP SERVICE MASTER KEY


© Copyright SS64.com 1999-2014
Some rights reserved