Clean db for Enterprise Server

NOTICE

POTENTIAL FOR DATA LOSS.
The steps detailed in the resolution of this article may result in a loss of critical data if not performed properly. Before beginning these steps, make sure all important data is backed up in the event of data loss. If you are unsure, please contact Product Support Services prior to attempting the procedure below.

Issue

How does one get a clean database for the Enterprise Server?

Product Line

SmartStruxure Solution

Environment

StruxureWare Buildings Operation site with Enterprise Server ES.

Cause

Need for clean database either for testing or start from scratch. 

Resolution

1. Stop Enterprise Server using StruxureWare Software Administrator

2. Then go to the location of your database using Windows Explorer. For this example it isC:/ProgramData/Schneider Electric StruxureWare/Building Operation 1.9/Enterprise Server/db

3. Rename "configuration.db" in configuration folder to "configuration_2.db" or delete "configuration.db

4. Start Enterprise Server using StruxureWare Software Administrator, the system will create a new "configuration.db"

Note: Restoring a different database over the current database does not require the clean database state. Using the backup and restore procedure allows you to switch databases.