Page History

To create the The MS SQL database backup copy , use is created using the idb.exe utility. To create the backup copy, do the following:

Run
1. Open the idb.exe
utility
2. utility (see Starting and shutting down the idb.exe utility).

3. From the Select the Basic data MS SQL database from the Select data source dropdown listdata source: drop-down list, select the MS SQL database—Basic data.

   Info
   title Note
   Select the vertical solution database to create a To create the backup copy of the vertical solution database. For example, for Face PSIM the data source is Face., you must select the vertical solution database, for example, the Monitorsstv data source for Monitoring PSIM.

4. In case you don't want to include the event viewer in the database backup copyIf it is not required to include the Event protocol in the backup copy of the database, set the Clear protocols checkbox. This checkbox is not available unavailable if you select the vertical solution database is selectedsolution database.
5. Click the Create backup copy (MS SQL)button.

6. As a result, the Save as dialog box appears window opens. Select the address and type in enter the name of saving the saved backup copy.
   

   Info
   title Note
   While creating If Axxon PSIM and the database server are on different computers connected via the network, then when you create the backup copy of the MS SQL database backup copy, the created backup copy will be is saved by default on the computer where the database server is installed, in case of Axxon PSIM software and database server are located on different computers connected through the network. To save the created backup copy on the computer where Axxon PSIM is installed, do the following: Create the folder available through the network on the computer where Axxon PSIM 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.

   
   

7. As a result, the process of creating the backup copy

creation

8. starts. Information on this process is

given

9. displayed in the Protocol information table.

   Image Modified

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

    Info
    title Note
    The Also, you can create the backup copy (MS SQL) can be created using the using a macro.

11. Click the OK button to shut down the operation. The dialog box window closes automatically.

The Creating the MS SQL database backup copy is createdcomplete.

By default the database backup copy is created at: C:\Documents and Settings\<user name>\My documents\AxxonSoft\Axxon PSIM\Data\psim.sql.bak.

In case you cannot change the folder for storing the database backup copy while during the backup copy creation, do the following:

1. Call the Run function (Start → Run). Type in regedit in the opened dialog boxIn the window that opens, enter regedit.
2. Click the OK button. As a result, the Registry editor dialog box Editor window opens.
3. Create the string parameter with the BackupFolder name in the HKLM\SOFTWARE\AxxonSoft\PSIM registry thread branch (see Adding string parameters to the registry).
4. Set the value of the BackupFolder parameter: type in enter the folder address of the folder for storing the database backup copy (e.g. for example, C:\Documents and Settings\AVP\Desctop\Backup). 

   If it is necessary you want to store the database copy on the network disk, then you must specify the UNC path to the network folder (with to which the recording access) should be specified on the disk access for storing in the \\ServerName\ShareName format is opened. Take into account that all network resources that require the additional authentication should must be connected 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, then right-click the the SQL Server service and select the Properties item in the feature functional menu. In the opened SQL Server service dialog boxproperties window, go to the the Log On tab.
5. As a result, the string parameter of the key with the specified value is created.
   Image Modified
6. Call the Run function (Start → Run). Type in Enter the «C"C:\Program Files\Axxon PSIM\idb.exe" /backup» key  key in the opened dialog boxwindow.
7. Click the OK button.

As a result, the 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).