Page History

...

1. Run the idb.exe utility (see Running and shutting - down the utility section).

2. Select the Basic data MSSQL database in the Select data source: dropdown list.

   Info
   title Note.
   Select the vertical solution database to create a backup copy of the vertical solution database, for example, for ATM-IntellectAxxon PSIM/Monitoring the data source is MonitorSSTV.

   
   

3. If it is not required to include the Event protocol in the backup copy of the database, check the Clear protocols box. This checkbox is not available if the vertical solution database is selected.
4. Click the Create backup copy (MS SQL) button.

5. As a result the Save as box appears. Select the address and type-in the name of saving backup copy.
   

   Info
   title Note.
   While creating the MS SQL database backup copy, the created backup copy will be saved on the computer where the database server is installed, in case of Intellect Axxon PSIM software and database server are located on different computers connected through the networks. To save created backup copy on the computer where the Intellect Axxon PSIM software is installed, do the following: Create the folder available through the networks on the computer where the Intellect Axxon PSIM software is installed. Provide access to the created folder from the computer where the database server is installed. Specify the path to the created folder in the Save as window.

   
   

6. As a result the process of backup copy creation starts. Information on this process is given in the Protocol information table.
   

7. The backup copy is created when the Creation of a backup copy is completed! message appears in the Protocol table.

   Info
   title Note.
   The backup copy (MS SQL) can be created using the macro.

   
   

8. Click the OK button. The box closes automatically.

...

By default the database backup copy is created at: C:\Documents and Settings\<user name>\My documents\ITVAxxonSoft\IntellectAxxon PSIM\Data\intellectAxxon PSIM.sql.bak. If one cannot change the folder for storing the database backup copy while the backup copy creation, do the following:

1. Call the Run function (Start - > Run). Type-in the regedit in the opened box.
2. Click the OK button. As a result the Registry editor box opens.
3. Create the string parameter with the BackupFolder name in the «HKLM\SOFTWARE\ITVAxxonSoft\INTELLECT» Axxon PSIM» registry thread (see Adding string parameters to the registry section).
4. Set the value of the BackupFolder parameter – type-in the address of the folder for storing the database backup copy(e.g.  C:\ Documents and Settings\AVP\Desctop\Backup). 

   If the database copy is to be stored on the network disk, then the UNC path to the network folder (with the recording access) is to be specified on the disk in the \\ServerName\ShareName format. Take into account the fact that all network resources that require additional authentication are to be enabled using the same username as for running the SQL Server service. To find out and/or change the user that runs the SQL Server service, do one of the following:

   1. Using the SQL Server Configuration Manager utility.
   2. Run Start – Control panel – Administrative tools – Services, right-click the SQL Server service and select the Properties item in the feature menu. Go to the Log On tab.
5. As a result the string parameter of the key with the specified value is created.
   
6. Call the Run function (Start - > Run). Type-in the «C:\Program Files\IntellectAxxon PSIM\idb.exe /backup» key in the opened box.
7. Click the OK button.

As a result the intellectAxxon PSIM.sq.l.bak database backup copy is created in the folder specified as the value of the BackupFolder parameter («C:\ Documents and Settings\AVP\Desctop\Backup»).