Export (0) Print
Expand All

How to: Restore the Service Master Key

The service master key is the root of the SQL Server encryption hierarchy. It directly or indirectly secures all other keys in the server instance. For this reason, the service master key is the most important key in the server. It is unlikely that you will ever need to restore the service master key. In you do, you should proceed with extreme caution. For more information, see RESTORE SERVICE MASTER KEY (Transact-SQL).

To restore the service master key

  1. Copy the backed-up service master key from the backup medium to a directory on the local file system.

  2. Execute the following Transact-SQL command: RESTORE SERVICE MASTER KEY FROM FILE = '<complete path and file name>' DECRYPTION BY PASSWORD = '<password>' ; GO 

    Where password is the password that was used to encrypt the key for offline storage.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft