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.
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
ALTER SERVICE MASTER KEY
BACKUP SERVICE MASTER KEY
© Copyright SS64.com 1999-2013
Some rights reserved