NEXUS Administration Tasks

The following sections describe common administration tasks around the deployment and maintenance of NEXUS IC.

Regular Backups

Daily scheduled SQL backups should be performed by an SQL Maintenance job. Retention policy is at your discretion.

Ad Hoc Backups

Standard NEXUS users can take backups as and when required using Database ‣ Backup menu item. Backups are recommended prior to imports or large scale database changes. For more information, see Create a Backup.

Database Restores

Database restores must be performed by the NEXUS SQL Admin. We recommend using the NEXUS application to perform database restore of the proprietary .nexus-backup (or .aimbak for older versions) files. If restoring from the daily backup then restore should be performed using SQL tools. Confirm that the User Group has [dbowner] permissions on any restored databases.

Restore a Database

Set up a shared network folder, which is accessible to both the database server and to NEXUS IC. This may be a UNC path (like ‘\\MyServer\MyShare’) or, if the database server and NEXUS IC are running on the same machine, it may be a Windows path (like ‘C:\Database Backups’). Copy the NEXUS IC database backup file into this folder.

Note

When restoring the NEXUS IC Database to the SQL Server, you may not have sufficient permissions to create databases on the SQL Server. In this case, contact your SQL Administrator to restore the database using SQL Management Studio (or similar).

Add a User

There are two steps to adding a new user to the NEXUS database:

  1. In Active Directory, add the user to NEXUS Users Group.

  2. In NEXUS IC, go to Database ‣ Security and add a new user as described in Create a New User.

Edit User’s NEXUS Permissions

In NEXUS IC, go to Database ‣ Security and set up permissions as described in Set Up Permissions for User/User Group.

Remove a User

Although it is possible in NEXUS we do NOT recommend deleting a user because this will delete all audit history associated with that user. To disable a user:

  1. In NEXUS IC, go to Database ‣ Security and edit the user profile. On the Login tab, deselect the enabled checkbox.

  2. In Active Directory, remove the user from the NEXUS Users Group (or disable the user account).

Refresh or Update Software License

If the database name or SQL server name change, then the NEXUS licensing will become invalidated. To refresh the license, proceed as follows:

  1. Navigate to Database ‣ Properties (see Properties Dialog).

  2. Go to the License tab.

  3. Enter the unique license key, overwriting whatever text is presently there.

  4. Press the Request License button.

    License information will be retrieved over the internet within a minute or so.