Additional PowerQuality Database procedures

This section provides additional procedures related to the PowerQuality Database in Powermanager.

Restore a PowerQuality Database Backup

  1. SQL Server is available.
  2. A named instance is available on the SQL Server.
  1. In the SMC tree, select Database Infrastructure > [SQL Server Name].
    NOTE: Do not select an existing Powermanager Database.
  2. Click Restore and select Restore Powermanager PowerQuality Database.
  3. Navigate to Database Information expander and enter a DB Name (no special characters or spaces).
  4. Navigate to Files and Backup expander, and select below files:
    • Data file: C:\[MyProjectPQDB]\ [DBname].mdf
    • Log file: C:\[MyProjectPQDB]\ [DBname].ldf
    • Backup file: C:\[MyProjectPQDB]\Backups\[DBname].bak
    • Recovery log path: C:\[MyRevoveryPath]\RecoveryLog
    • Restore file: Select the PowerQuality Database backup (.bak) file, you want to restore.
  5. Navigate to Security expander, and select owner for PowerQuality Database.
  6. Click Save .
  7. Click Yes to restore a backup file.
  8. The PowerQuality Database is restored and displayed in the SMC tree.
  9. The PowerQuality Database is started automatically following successful restore.
  10. Once restore is complete, link the restored database to the project. For more information, refer Linking PQ Web Application and PowerQuality Database to the project.

Manual Backup of PowerQuality Database from SMC

You want to make a manual backup of the PowerQuality Database using SMC.

  1. Ensure that your target directory has enough space, as the PowerQuality Database requires large space. The maximum supported database size is 250 GB.
  2. It is recommended that you store a copy of the backup on a different storage medium if you back up your data on your local computer. This prevents overflow of your local hard disk. The backup can be incomplete or faulty if insufficient storage space is available during the backup. Therefore, it is recommended that you repeat the backup.
  3. Ensure that a PowerQuality Database is available.
  1. In the SMC tree, select Database Infrastructure > [SQL Server Name] > [PowerQuality Database name].
  2. Click Backup.
  3. Select the Files and Backup expander.
  4. Click Browse for Manual backup file and select the folder for backup.
  6. Click Save.
  7. Click Yes to create the backup file.
  8. The Task Info Expander shows the backup status.

 

Creating Inbound and Outbound Rule for Remote Database

For a complete list of TCP and UDP ports that you should add to the server firewall and any network firewalls between the server and clients, distribution participants and the server and field panels for a safe system operation, see Cybersecurity Guidelines document.

  1. Open system where you wish you create a remote database.
  2. Open Windows Defender Firewall with Advanced Security.
  3. Right-click on Inbound Rules and select New Rule.
  4. In the wizard, configure the following:
    a. For Rule Type, select Port, and click Next >.
    b. For Protocol and Ports, enter below port numbers one by one
    - select TCP and enter Specific local ports as 1433,
    - select UDP and enter Specific local ports as 1434
    c. Click Next >.
    d. For Action, select Allow the connection, and click Next >.
    e. For Profile, select Domain, Private and Public, and click Next >.
    f. For Name, enter the name for the rule, and click Next >.
    g. Click Finish.
  5. Right-click on Outbound Rules and select New Rule.
  6. In the wizard, configure the following:
    a. For Rule Type, select Port, and click Next >.
    b. For Protocol and Ports, enter below port number one by one
    - select TCP and enter Specific local ports as 1433,
    - select UDP and enter Specific local ports as 1434
    c. Click Next >.
    d. For Action, select Allow the connection, and click Next >.
    e. For Profile, select Domain, Private and Public, and click Next >.
    f. For Name, enter the name for the rule, and click Next >.
    g. Click Finish.
  1. Inbound and Outbound rules are created.

Upgrading PQDB

Perform below steps to upgrade the PQDB after upgrading Powermanager from earlier version to the latest version.

  1. Open Powermanager SMC application.
  2. Click on PowerQualityDB [Powermanager PQ Advisor].
  3. Click upgrade icon.
  5. A message displays.
  6. Click Yes.
  8. The PQDB is upgraded successfully.