Default maintenance task settings

The default PME database maintenance tasks are defined as Windows PowerShell scripts, and scheduled and executed using Task Scheduler in Windows. The following table shows the different configuration settings for these tasks, their defaults, and where they are configured:

Setting Location Default Value Comments

Windows account used to run the task

Task Scheduler

User account that is creating the task.

Use IONMaintenance for Standalone systems.
Create a new, dedicated account for Distributed systems. See create a Windows user account to run the maintenance tasks for more details.

Task trigger times

Task Scheduler

See default task schedules.

The default schedules are configured automatically for Standalone systems.
The schedules for Distributed systems must be configured manually.

Task enabling or disabling

Task Scheduler

See default task schedules.

n/a

Backup folder location

PowerShell script : Configuration.ps1
Variable: $locationForBackupFiles

...\Power Monitoring Expert\Database\Backup*

Sets the folder to which the database backups are saved. The backup script will create the following subfolders in this location:

...\Data for ION_Data
...\Network for ION_Network
...\SystemLog for ION_SystemLog
...\Applications for ApplicationModules

Archive folder location

PowerShell script : Configuration.ps1
Variable: $locationForArchiveDBFiles

...\Power Monitoring Expert\Database\Archive*

Sets the folder to which the database archives are saved.

Data to keep when trimming

PowerShell script : Configuration.ps1
Variable: $diagnosticsDaysToKeep

30

Sets how many days' worth of data is left in the database after trimming.

Database size (max)**

PowerShell script : Configuration.ps1
Variable: $maximumDatabaseSizeIn Gigabytes

9

Sets the maximum database size. This value is used by the size notification task to assess what percentage of database space has been used.

The maximum size for a SQL Express database is 10GB. The maximum size in the script is set to 9GB to allow for a 1GB warning buffer before the database stops logging data.

Database size notification limit**

PowerShell script : Configuration.ps1
Variable: $databaseSizeNotification ThresholdPercentage

85

Sets the threshold for when a database size notification will be issued.

* Default setting for Standalone systems.
** The database size notification is only configured for systems with SQL Server Express databases.