Technical FAQs

Ask a Question

How to create a new ION_Data Database in PME 7.2 and PME 8

User wants to detach the existing ION_Data database and create a new fresh database

StruxureWare Power Monitoring Expert (PME) 7.2, 8.0

Database manager

*Warning: Take backups of any files prior to modifying them. Ensure the backups are in a location that will not be overwritten (i.e. the Desktop).*
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*

1) Backup the ION_Data database
2) Stop the ION/Application/Schneider services
3) Open the Database Manager in Management Console, Tools -> Database Manager
4) If the number of connections is not 0, Click the clear button
5) Detach the ION_Data database.
6) If possible, backup/move the .mdf and .ldf files
7) In Database Manager, rick click "Databases" and select New ION Database..."
8) Use the name ION_Data if possible and select the location for the new .ldf and .mdf files
9) Click the OK button.
10) Use the Database Manager to attach the old ION_Data database as ION_Data_Archive
11) Start services stopped in Step 2.

Instructions on how to have the old ION_Data database behave as an archive can be found in following Knowledge Base article:
FA214016How to convert a live database to an archive database?
Was this helpful?
What can we do to improve the information ?