Extra

The top dropdown-list presents you with an overview of all CSI databases which are stored on the SQL server to which you are currently connected. Select the database for which you wish to perform an action.

• Create database user: Creates the CSI db Admin (database user) in the SQL database (the CSI db Admin's password will be extracted from the CSI Accelerator Application configuration file).

• Restore database user: Under some circumstances the default database user (required for connecting) might not be accepted because of security reasons (in environments with a very rigid password policy). In order to circumvent this issue you have the option to create a new database user (at the Connect-tab).
  
  When restoring the backup and this user does not exist at the SQL server, activate this option and the CSI SQL Xchange will automatically add this user to the database.

• Activate recursive triggers: Use this option only when the database uses direct recursive triggers. This option is required for CSI Codification Builder and CSI Controls Organizer.

• Adjust recovery model: Please refer to the Restore topic.

• Delete database: This action deletes the selected database.

• Clear server registration: This action will clear all registration info.
  First you need to enter the reset code (changes every day). You also need to select the common database.
  

• Release all locks: This action releases all locks which are currently active on the selected database.

• Clear logon table: This action clears the logon table (frees up space but keep in mind that you loose the ability to check logon activity).

• Reset administrator password: This action resets the administrator password.

• Reset users' password: This action will clear the password of ALL users.

• Shrink database: When this option is checked, the CSI SQL Xchange will compact the database before restoring the backup. When successful this will reduce both the actual database and the backup file. 

• Clear log: When this option is checked, the CSI SQL Xchange will clear the database log in the backup before restoring the backup. This implies that this log file will not be restored to the SQL server.

• Reset unique database identifier: give this database a new unique key that will be used to re-link the database to the application database. The is related to renaming a database when restoring it.

• Create upgrade permission file: upgrade permissions are given per server. Connect to the server that needs upgrade permissions with a login id that has db create rights or sysadmin rights (The CSI dbAdmin login id can't be used, whatever its rights). Click Create upgrade permission file. Browse to the folder the Accelerator executable is in, because that is the location the permissions file is read from. Click ok. A message will appear confirming the file has been created.