Concerning the backup and comparing SQL to the proprietary database that StruxureWare creates begs the question, are these backup complete?
StruxureWare freezes the database while a backup is in progress in different ways. For configuration changes, StruxureWare Building Operation queues up the changes until the backup completes. For historical data, StruxureWare Building Operation buffers the data based on the limits of the buffer size.
A stop of the ES is not necessary, nor is a stop of an AS. Because of this freeze and buffering, the data is put into that backup folder referenced in the pdf you sent.
Three rules to remember:
- Restores of backups must be same software revision
- Do not rename the backup set
- A StruxureWare Building Operation backup should not be renamed after it has been created.
- When creating a backup, give the appropriate prefix to the standard name format.
- The backup file will be shown as below.
- Should the backup name need to changed, then either create a new backup, or, zip up the backup using the new name.
- Backups default to every Sunday morning 1:00am
Here is the procedure for backing up an AS or ES:
- In Workstation, in the System Tree pane, select an Automation Server (AS) or Enterprise Server (ES)
- On the Actions menu, click Backup. This opens the Backup Options window
- In the Include column, select the servers that you want to include in the backup
- In the Backup content column, select the type of data you want to backup for each server:
- Select All Data to back up both the historical and configuration databases. This combined option protects the configuration, historical data, and custom object type data for a specified date and time
- Select Configuration only to back up the configuration database and custom object type data. This data option protects the configuration data for a specified date and time
- In the Backup set description column, type a brief description up to 255 characters to help identify the content of the backup
- Click Backup
- Verify that each backup succeeded and click Close
Backup Files of ES: The backup data files are stored in the C:\Users\All Users\Application Data\Schneider Electric StruxureWare\Building Operation 1.x\Enterprise Server\db_backup directory
Backup Files of AS: From WorkStation Locate System > Backup and Restore > Backup sets> Local and Right-click on the backup file and Save To...
Note: Let this not be confused with the 'Starting a Project Tutorial [101248].pdf' in section 5.1 page 44, where it describes the user simply doing a raw copy of the database folder from within Windows Explorer. This can be mistaken with the orderly backup that uses the inbuilt StruxureWare backup facility. This copy procedure described has no chance to freeze the database. The user can just do it at any random time and StruxureWare has no idea that the copy has been made.
A sample database should be created using the Backup/Restore functions of the system, not by just doing a raw folder copy as the server may be in the middle of transactions to various files in that folder.
A copy of this folder could be used, but only while the SE.EnterpriseServer.exe process has been stopped. However, it is recommend using the system’s backup facility to accomplish this (Not all items are backed up such as Alarm data. The Backup/Restore help section of StruxureWare Building Operation Guide discusses what is and isn’t backed up).