Backup a service master key.
Syntax: BACKUP SERVICE MASTER KEY TO FILE = 'path_to_file' ENCRYPTION BY PASSWORD = 'password'
Specify the complete UNC or local path, including file name, for the file to which the service master key will be exported.
If password complexity is enforced, the password must be > 8 chars and contain upper/lower case and numeric/ Non-alphanumeric characters.
Backup the service master key as soon as it is created, and store the backup in a secure, off-site location.
BACKUP SERVICE MASTER KEY TO FILE = 'c:\backups\service_master_key' ENCRYPTION BY PASSWORD = 'key_P@ssw0rdGqw0956565';
"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
CREATE MASTER KEY
ALTER MASTER KEY
DROP MASTER KEY
RESTORE MASTER KEY