Additional information

Application server

Detecting whether there is encryption scheme information on the application server (and whether they are stored in separate files)

Encryption scheme information can be configured to be stored within the database or the application server (recommended). To see if any encryption scheme information is configured to be stored on the application server:

  1. Open BPServer.exe and edit the appropriate profile.
  2. Click Key Store.
  3. If there are any entries, then encryption scheme information is stored on the application server.
  4. If the option Store keys separately in individual files is selected and a folder path displays, then the encryption scheme information will be stored away from the default file in the specified folder path.

Locating the certificate used to protect the application server configuration file

A feature introduced in Blue Prism v6.7 allows users to select to encrypt the Blue Prism application server configuration using a deployed certificate. To detect whether this has been configured:

  1. Open BPServer.exe and click Encryption Settings.
  2. If the option Use own certificate is selected, then encryption is applied and the thumbprint will indicate which certificate in the local store is used.
  3. Use the thumbprint in the search utility in the device’s local certificate store to find the certificate. (Search based on the SHA1 Hash field.)

Database

Backing up a SQL Server Database

To back up a SQL Server database, follow the instructions provided by Microsoft:

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/create-a-full-database-backup-sql-server?view=sql-server-ver15

Restoring a SQL Server Database

To restore a SQL Server database using SQL Server Management Studio, follow the instructions provided by Microsoft:

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-a-database-backup-using-ssms?view=sql-server-ver15