Add or manage a Nodinite Log Database
On this page, you will learn how to manage Nodinite Log Databases.
The administration pages in the Web Client are typically used when you move a database from one SQL Server Instance to another or when you remove (Delete) a database.
The configuration gives Nodinite knowledge on the whereabouts of the physical Log Databases.
Tip: Move old databases to your SQL Hotel where disk might be cheaper Tip: Move old databases to better utilize hardware resources Tip: Empty databases can safely be removed
A name for the Log Database is mandatory.
If you create the Log Databases manually, you must set the active intervals (Start Date and End Date).
The following fields exist for a Log Database:
- Database Name
- Server Name (might include the instance name)
- Start Date
- End Date
Enter the database name. This field is required to create the Log Database configuration.
The format is by default:
NodiniteLog_%ENVIRONMENT%_STARTDATE, for example NodiniteLog_Test_20120517
Add the name of the target SQL Server instance.
- If the Log Database is located on the same server as the Nodinite Configuration DatabaseIt should be:
- Otherwise, enter the name using a linked server. Remote Log Databases are accessed using the concept of linked servers.
Check this checkbox to make the Log Database read-only. Nodinite will use this database only to search for data (No operations like re-index, remove, or add will then be performed by internal maintenance)
Note: The Read-Only flag can only be checked for Log Databases if the 'End date' has passed the current date.
For a historical (archive) Log Database, this is the start date for Log Events. For future Log Databases, this value makes sure that future events enter the correct target Log Database when the time comes.
The optional field Description can be used to give this configuration a user-friendly meaning.
The Log Database without an end date cannot be deleted.
Note: The physical database will not be deleted in SQL Server. You must delete it manually from within the SQL MMC SSMS.
If the Log Database is hosted on a SQL Server Always-on availability group, then you must provide the following details:
- The name of the Always-on group (usually the listener name)
- Check the Remote server checkbox
Example settings for SQL Server Always-on Availability group
The following user guides are usually very helpful:
This is detailed in the 'Moving Nodinite Databases' user guide.