LogDatabaseRecovery - System Parameter
During the installation of Nodinite using the Nodinite Install and Update Tool, the System Parameter LogDatabaseRecovery
is automatically assigned by the system. Depending on your target SQL environment, the value is set according to the following table:
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.