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 [,][InstallUpdate], 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 failover cluster | SIMPLE |
- The Nodinite Logging Service uses this value to create new Log Databases with the appropriate recovery mode.
- Use the Nodinite [,][InstallUpdate] 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 [,][InstallUpdate] 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 [,][InstallUpdate] both use this System Parameter. If you change this value, you do NOT need to restart anything—changes are effective immediately.