BACKUP SERVICE MASTER KEY (Transact-SQL)
Exports the service master key.
- FILE = 'path_to_file'
Specifies the complete path, including file name, to the file to which the service master key will be exported. This may be a local path or a UNC path to a network location.
- PASSWORD = 'password'
Is the password used to encrypt the service master key in the backup file. This password is subject to complexity checks. For more information, see Password Policy.
In the following example, the service master key is backed up to a file.
BACKUP SERVICE MASTER KEY TO FILE = 'c:\temp_backups\keys\service_master_key' ENCRYPTION BY PASSWORD = '3dH85Hhk003GHk2597gheij4';