Scenario: You want to create and configure NDB on the Server and link it to the project so that the data (recipients, incidents, and notifications) is logged in the NDB.
This same step is followed for the History Database. Refer to the Scan and Link an SQL Server Instance step in the Creating History Infrastructure topic.
The destination folder where the NDB data and log files will be stored, typically GMSDatabases, is not compressed. NOTE: For more information on the expanders, refer to the Notification Database Configuration topic.
In the SMC tree, select Database Infrastructure > [SQL Server Name].
Click Add and select Create Notification Database.
The Add Notification DB screen displays.
Open the Database Information expander and enter data into the following fields:
DB name: Enter the name of the new Notification database. The database name must be unique on the targeted SQL Server (do not use special characters).
Database size: Set the size of the NDB (Maximum 10 GB for SQL Server Express).
Recovery model: Select the type of recovery either Full or Simple. The default value is Full (For more information, see Recovery Models).
SQL server: Displays the SQL Server address on which the new database will be created. Notification supports local as well as remote SQL servers.
T-log size: Represents the transaction log size.
Select the Files and Paths expander and enter the following data:
Data file:C:\Gmsdatabases\NDB.mdf
Log file:C:\Gmsdatabases\NDB.ldf
Backup file:C:\Gmsdatabases\Backups\NDB.bak
Recovery log path:C:\Gmsdatabases\Backups\RecoveryLog NOTE: If you do not use the standard paths in the Data file, Log file, Backup file, and Recovery log path fields and if the SQL Server is on a different computer, you must first create the folders before you click Save.
Select the Security expander and check the displayed user names. a. DB owner: Enter the database owner details. The NDB owner must be different from the NDB user and the NDB service user. b. DB user: Displays the database user details. c. DB service user: Displays the database service user details.
Click Save.
Click Yes.
The NDB is created and displays in the SMC tree.
The NDB starts automatically.
Notification data is logged after linking to the project.
In the SQL Server Details expander, select the NDB from the Linked NDB drop-down list. NOTE1: The NDB status is displayed in Linked NDB state field. The NDB states are same as the HDB states. For more information, refer to the Server Project Information Expander section in the Project Modification Settings topic. NOTE2: The Encrypted check box is enabled only when the Notification database that you have linked to the project is on the remote computer (SSL on TCP/IP connection). NOTE3: Encrypting the communication between Server project and remote SQL Server slows down the performance. For more information on the steps to configure secure communication between Notification server and Database server including certificate creation, refer to prerequisites and Set the Encryption in the SQL Server Configuration Manager section in Setting up Server Project with Remote HDB (SQL Server). NOTE4: You need to manually disable TCP/IP protocol for the SQL instance in the SQL Server Configuration Manager dialog box for making the SQL server ‘locally bound’.
Click Save.
The NDB is linked with the project. NOTE: If a project 'A' is linked to NDB 'A' and you try to link another NDB 'B' to the same project 'A', a prompt displays stating "selected NDB 'B' does not belong to Project 'A', do you still want to connect". When you select yes, the Project A is linked to the NDB 'B' and NDB ‘A’ is no longer linked to project ‘A’.
and select Create Notification Database.
.
