Thread: SQL Server 2005
View Single Post
  #12 (permalink)  
Old 10-16-2007, 01:39 AM
kingmaker kingmaker is offline
D-Web Genius
 
Join Date: Jun 2007
Posts: 882
kingmaker is on a distinguished road
Send a message via Yahoo to kingmaker
Default BACKUP CERTIFICATE SQL Server 2005

BACKUP CERTIFICATE

Export a certificate to a file.

Syntax:
BACKUP CERTIFICATE certname TO FILE = 'pathname'
[ WITH PRIVATE KEY
(
FILE = 'path_to_private_key_file' ,
ENCRYPTION BY PASSWORD = 'encryption_password'
[ , DECRYPTION BY PASSWORD = 'decryption_password' ]
)
]

If the private key is encrypted with a password in the database, then that decryption password must be specified.
When you back up the private key to a file, encryption is required.

Example

BACKUP CERTIFICATE MyCert TO FILE = 'c:\certs\MyCert'
WITH PRIVATE KEY ( FILE = 'c:\keys\Mykey' ,
ENCRYPTION BY PASSWORD = 'thisisa1ongpassw0rd' );
GO
__________________
The KINGMAKER
Makes Every Thing Possible

Stuffs (My Blog)
Reply With Quote