Backup Certificate

Go Up to Available object actions by DBMS

The Backup Certificate object action builds and submits a BACKUP CERTIFICATE... TO FILE statement with optionally, a WITH PRIVATE KEY clause. This lets you back up a certificate to file.

Platform Availability

• SQL SVR

To write a certificate to disk

1. Initiate a Backup Certificate action against a certificate. For more information see Initiating an object operation.

   The Attach Database File(s) dialog box opens.

2. Use the following table as a guide to understanding and modifying settings in the dialog:

Step	Settings and tasks
Action options	Lets you work with the following settings:
	File	The full path and filename (local or UNC) of the file to which the certificate is to be written.
	Private Key File	The full path and filename (local or UNC) of the file to which the private key is to be written.
	Encryption Password	The password used to encrypt the private key before writing the key to the backup file.
	Decryption Password	The password used to decrypt the private key before backing up the key.
Dependencies	Lets you review the objects potentially impacted by this action. For more information, see Dependencies.
Preview	Preview the DDL generated for the operation and when ready, use the Schedule or Execute button to perform this action.

3. Finally, use the Execute button to create the object.

Topics

• Add Private Key