LogDatabaseRecovery - System Parameter
Automate and control SQL Server recovery mode for Nodinite Log Databases with the LogDatabaseRecovery system parameter. This feature empowers you to:
✅ Ensure compliance with SQL Server best practices
✅ Optimize performance and reliability for your integration platform
✅ Automate database management for robust logging
✅ Apply changes instantly with no restart required
During installation with the Nodinite Install and Update Tool, the System Parameter LogDatabaseRecovery is automatically assigned. The value is set according to your target SQL environment:
| Type of SQL Environment | Value |
|---|---|
| Always on (AOAG) | FULL |
| Standalone, including fail-over cluster | SIMPLE |
- The Nodinite Logging Service uses this value to create new Log Databases with the appropriate recovery mode.
- Use the Nodinite Install and Update Tool to update existing Log Databases. The update script includes the correct .DACPAC file based on this value.
Important
Changing the value for the LogDatabaseRecovery System Parameter does not immediately affect existing Log Databases.
| System Parameter Name | Data Type | Values/Example | Comment |
|---|---|---|---|
| LogDatabaseRecovery | string | SIMPLE/FULL |
Default = SIMPLE |
- This feature is available from Nodinite Core Services version 4.
- This feature is available from Nodinite Install and Update Tool version 5.4.
Frequently asked questions
Find more solutions and answers in the Nodinite System Parameters FAQ and the Troubleshooting user guide.
How do I change the value?
Changing a value for the pre-defined System Parameters is described in the generic 'How do I change the System Parameters' article.
Do I need to restart anything?
The Nodinite Logging Service and the Nodinite Install and Update Tool both use this System Parameter. If you change this value, you do NOT need to restart anything—changes are effective immediately.