Basic administration tasks
Install Windows updates
Apply critical and routine Windows and SQL Server updates to the PME servers and clients; no prior approval by Schneider Electric is required.
Check the scheduled database maintenance tasks
notice
LOSS of data
| ● | Back up the database at regular intervals. |
| ● | Back up the database before upgrading or migrating the system. |
| ● | Back up the database before trimming it. |
| ● | Back up the database before making manual database edits. |
| ● | Verify correct database behavior after making database or system changes. |
Failure to follow these instructions can result in permanent loss of data.
In Standalone PME systems, the database maintenance tasks for backup, archive, maintenance, and trim are pre-configured and scheduled to run automatically by default. For Distributed Database PME systems, we recommend that these scheduled tasks are set up manually.
Check the task outputs regularly and confirm that backups are created as expected. Review and adjust the schedules to meet your application needs, if required.
NOTE: You can perform additional, manual backups using standard SQL Server backup procedures.
Monitor the database size for systems with SQL Server Express databases
notice
LOSS OF dATA
| ● | Back up or archive the database before trimming it. |
| ● | Trim the SQL Server Express database before it reaches the size limit. |
Failure to follow these instructions can result in permanent loss of data.
SQL Server Express has a maximum database size limit of 10 GB. The database stops logging data when this size limit is reached. The scheduled default database maintenance tasks include a database size notification task. When the size threshold is reached, the task logs a system log event message and triggers a Critical alarm in PME every time the task runs.
Check the PME system log and Alarms on a regular basis for database size notification messages. Check the database size on a regular basis and take action before reaching the database size limit.