Subscribing is a smart move!
You can subscribe to this forum after you log in or create your free account.
ClearSCADA Database Backup
Geo SCADA Knowledge Base
Access vast amounts of technical know-how and pro tips from our community of Geo SCADA experts.
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we?ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
📖 Home Back
.
How do I properly backup a ClearSCADA database including all history and events?
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
1.png
(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.png
2) Bring the ClearSCADA server icon into view by selecting it from the system tray.
3.png
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.png
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.png
5) Back in the Windows Explorer dialog right-click on the 'Database' folder and select 'Properties'.
6.png
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.png
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.png
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.png
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.png
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.png
11) A dialog will appear asking a user whether they want to start the database or stay in safe mode. Select 'Start Database'.
12.png
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.
13.png
Go: Home Back
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
1.png
(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.png
2) Bring the ClearSCADA server icon into view by selecting it from the system tray.
3.png
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.png
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.png
5) Back in the Windows Explorer dialog right-click on the 'Database' folder and select 'Properties'.
6.png
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.png
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.png
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.png9) 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.png
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.png
11) A dialog will appear asking a user whether they want to start the database or stay in safe mode. Select 'Start Database'.
12.png
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.
13.png
Go: Home Back
Author
Create your free account or log in to subscribe to the forum - and gain access to more than 10,000+ support articles along with insights from experts and peers.