Home Library Learn Downloads Support Community
Sign in | United States - English | |
0 out of 1 rated this helpful - Rate this topic

BACKUP SERVICE MASTER KEY (Transact-SQL)

SQL Server 2008

Exports the service master key.

Topic link iconTransact-SQL Syntax Conventions

Copy 

BACKUP SERVICE MASTER KEY TO FILE ='path_to_file' 
    ENCRYPTION BY PASSWORD ='password'
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.

The service master key should be backed up and stored in a secure, off-site location. Creating this backup should be one of the first administrative actions performed on the server.

Requires CONTROL SERVER permission on the server.

In the following example, the service master key is backed up to a file.

Copy 
BACKUP SERVICE MASTER KEY TO FILE = 'c:\temp_backups\keys\service_master_key' ENCRYPTION BY PASSWORD = '3dH85Hhk003GHk2597gheij4';
Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ