Terminologies of Notification Database
Following are the important terminologies used in the Notification database.
Two types of recovery are possible to back up the Notification Database:
- Simple Notification Database backup
- Full Notification Database backup
The following table shows a summary of the advantages and disadvantages of both recovery models. The backup mode you choose depends on how important historical data is for traceability purposes.
Recovery Models | ||
| Simple | Full |
Automatic data backup based on saved data volume | No | Yes |
Automatic data backup via scheduler program | Yes | Yes |
Small or no loss of data following SQL Server failure | No | Yes |
Simple restore of backed-up data by customer, engineer | Yes | No |
Restore backed up data requires SQL Server Management Studio (trained SQL Server administrator required) | No | Yes |
Installation and maintenance costs for data backup | Low | Higher |
PC performance required for data backup | Normal | High |
Individual databases can be distributed across several servers or storage media to allow for restoration of all data following an SQL Server failure. This is the optimum system topology.
Abbreviation of the Data Files | ||
Abbrev. | Short Description | Description |
BAK | Backup File | Backup file of MDF file |
LDF | Log Data File | Microsoft SQL Server transaction log file |
MDF | Master Data File | Microsoft SQL Server database |
NDB | Notification Database | Includes all logged notification data |
System | System Desigo CC | Program and project data files of Desigo CC |
OS | Operating System |
|
NOTE:
The saved *.BAK files have the same data content for simple and full notification backup.
The simple system topology shown below (for example, for cost considerations, simple IT installation, small project) can easily be implemented. However, it is not optimal for notification data backup that requires a high level of data security because server failure means that all data up to the last data backup (backed up on DVD or external storage media) is lost.
Abbreviation of the Data Files | ||
Abbrev. | Short Description | Description |
BAK | Backup File | Backup file of MDF file |
LDF | Log Data File | Microsoft SQL Server transaction log file |
MDF | Master Data File | Microsoft SQL Server database |
System | System Desigo CC | Program and project data files of Desigo CC |
OS | Operating System |
|
NOTE:
The saved *.BAK files have the same data content for simple and full notification backup.
