Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2008
Database Engine
Technical Reference
 BACKUP SERVICE MASTER KEY (Transact...

  Switch on low bandwidth view
Community Content
In this section
Statistics Annotations (0)
Other versions are also available for the following:
SQL Server 2008 Books Online (June 2009)
BACKUP SERVICE MASTER KEY (Transact-SQL)

Exports the service master key.

Topic link icon Transact-SQL Syntax Conventions

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.

BACKUP SERVICE MASTER KEY TO FILE = 'c:\temp_backups\keys\service_master_key' ENCRYPTION BY PASSWORD = '3dH85Hhk003GHk2597gheij4';
Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker