Technical FAQs

Ask a Question

ClearSCADA Database Backup

Problem

How do I properly backup a ClearSCADA database including all history and events?

Solution

Follow the steps below to properly create a complete backup of your ClearSCADA database.

 

1)    Open a Windows Explorer dialog and locate the ClearSCADA Database folder.  On a Windows 7 PC the location should be

 

C:\ProgramData\Schneider Electric\ClearSCADA\Database


 

(The Database location may be found by right-clicking on the server icon, selecting ‘Configuration’ and then navigating to system configuration | Location.

All fields should be common to a folder named ‘Database’)





2) Bring the ClearSCADA server icon into view by selecting it from the system tray.





3) Right-click on the server icon and select ‘Shutdown Server’.  NOTE: Never copy a database while the ClearSCADA server is running.  The database could be corrupted if the server is not shut down first.





4) Wait for the server icon to first turn red (shutting down) and then grey.  When the icon turns grey the ClearSCADA server has been fully shut down.





5) Back in the Windows Explorer dialog right-click on the ‘Database’ folder and select ‘Properties’.





6) Note the size of the file in bytes.  You will need to ensure that you have this much space available on the drive/media that you will be storing the database.





 

7) Close the Properties dialog, right-click on the ‘Database’ folder and select ‘Copy’.

Paste the folder to another drive/media for safe keeping.





8) Alternatively you could rename the ‘Database’ folder and so that it remains saved in the save folder location.  Right-click on the ‘Database’ folder and select ‘Rename’.   The recommended format is ‘Database_MonthDay_Year’.





9) Once the ‘Database’ folder has been moved/renamed you’ll notice if you start the ClearSCADA server that the icon will turn pink.  The ClearSCADA server looks for a folder named ‘Database’ when it starts.  If it does not find this folder it goes into a safe mode indicated by a pink server icon.





10) A user may create a new, blank database by starting the database from this state.  Right-click on the pink server icon and select ‘Start Database’.





11) A dialog will appear asking a user whether they want to start the database or stay in safe mode.  Select ‘Start Database’.





12) Upon starting the database the server icon should turn navy blue and you will notice a new folder named ‘Database’ has been created in the Windows Explorer dialog.


 

Was this helpful?
What can we do to improve the information ?