System variables for the Unified Journal Category
The following table lists system variables used to define various setting for the Unified Journal.
| System Variable Name | Description | Value Type | Default Value |
|---|---|---|---|
|
Automatic Cleanup: Daily journal log management time |
The time of day (hour/minute) when the automatic journal log volume management occurs. An empty field indicates automatic journal log volume management is disabled. You can activate this variable by entering a time in the field. Enabling or disabling automatic journal volume management from this system variable has no impact on volume management events. |
Numeric |
|
|
Automatic Cleanup: Number of days for entire Journal |
The number of days worth of data the whole set of Journal databases can contain. When you activate the Journal Log Management action, the system automatically backs up and deletes Journal volumes to keep the total journal size under the limit if this number is exceeded. |
Numeric |
365 |
|
Automatic Cleanup: Number of records for entire journal |
The maximum number of journal messages that are stored in the entire set of Journal databases. When you activate the Journal Log Management action, the system automatically backs up and deletes journal volumes to keep the total journal size under the limit if this number is exceeded. |
Numeric |
5000000 |
| Automatic Growth Size for Journal Datafile | The size in MB to grow the size of the Journal Datafile. The range is 512 to 204800. | Numeric | 512 |
| Automatic Growth Size for Journal Logfile | The size in MB to grow the size of the Journal Logfile. The range is 256 to 8096. | Numeric | 256 |
|
Days per Journal Volume |
The maximum number of days worth of data that a journal volume can contain. When this number is exceeded for the current journal volume, a volume switch happens and a new current journal volume is created. This is a read-only field. Note: If your system runs SQL Express, this variable is set to
90 days and the default value is 90. If your system runs a full
instance of SQL, it sets this variable to 30 days and the default
value is 30.
Maximum setting: 999 |
Numeric |
Dependent on SQL installation |
| Initial Size for Journal Datafile | The initial size for the Journal Datafile in MB. The range is 2048 to 204800. | Numeric | 2048 |
| Initial Size for Journal Logfile | The initial size for the Journal Logfile in MB. The range is 256 to 8096. | Numeric | 256 |
|
Journal Log Management New Backup Path |
The path on the SQL server machine for the storage of the Journal log volume management backup files. This is a read-only field. Note: Upgrading to v2.70 does not migrate the value of this
variable. It starts with a default value of blank.
Note: You can use limited UNC paths because SQL Server itself
performs the backup. If you want to use a UNC path, you must use a
path accessible to the Windows user who runs the SQL Server
Service.
|
Characters |
|
|
Journal SQL Data New File Path |
When a new journal volume is created, a new SQL Data .mdf file is created in this location. It must be a local directory on the SQL Server machine. This is a read-only field. |
Characters |
|
|
Journal SQL Log New File Path |
When a new journal volume is created, a new SQL Log .ldf file is created in this location. It must be a local directory on the SQL Server machine. This is a read-only field. |
Characters |
|
|
Journal Switch Time |
The time of day (hour/minute) when the journal switch occurs. |
Numeric |
00:30 |
|
Message Date/Time too old Threshold |
The specified number of days older than the server date and time that a Journal message is flagged as too old to have a reasonable value. The minimum for this field is 90 and the maximum is 1100. |
Numeric |
365 |