Backup Certificate

From DBArtisan
Jump to: navigation, search

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

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:


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.


Lets you review the objects potentially impacted by this action. For more information, see Dependencies.


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.