Restore HyWorks Controller

Entire HyWorks deployment can be restored from the database backup.

Placing The BackUp File On HyWorks Controller

Once backup is taken successfully, it is very important for administrator to place the backup file in

1. Appropriate format (.bak format)

2. Appropriate location on controller for restore

BackUp File Format

HyWorks Controller stores the backup file in zip format in the following default location:

C:\Windows\TEMP\DB\BACKUP\

To restore backup, the file must be extracted first. On extraction, following type of file will be available for restore:

• For SQL Server Database: file should use .bak extension

Appropriate Directory For Restore

The location from where backup files can be restored, depends on the HyWorks controller database configurations:

• For HyWorks Controller with SQL Server Database: While restoring HyWorks Controller with SQL Server configuration, SQL Server should have write access on the directory in which Backup file is available. This can be done using following two methods:

  • Copy Backup File in SQL Server Backup Directory: The default location where the backup is placed does not have the required permission set and thus either the permission should be appropriately configured for SQL Server or the file can be moved to SQL Server Install location -> Backup folder. Backup folder works correctly while restoring HyWorks controller with SQL server and should be preferred for restore over any other location.

  • Configure Permissions on Backup File Directory

Please refer Troubleshooting section for permission configuration guidelines.

Restore HyWorks Controller

Pre-requisite

1. Appropriate backup file in specified file format available for restore. Refer section BackUp File Format

2. Backup file is available in appropriate directory. Refer section Appropriate Directory For Restore for details.

Restore Process

Install New Controller With Backup Database

Follow the below listed steps to configure a new controller by restoring backup database

1. Access the Windows server to be configured as HyWorks Controller; which satisfies the following prerequisites

   1. All required prerequisites for HyWorks Controller i.e. DotNet4.5, ASP.Net4.5, SSCE runtime, SQL server and Web Server (IIS roles) are configured

   2. The server does not have any existing installed HyWorks Controller as the new HyWorks Controller has to be created using existing database backup

2. Invoke HyWorks Installer with administrative rights on the server (where the HyWorks Controller is not installed)

   

3. The Setup wizard will get launched in fresh installation mode displaying Welcome screen

4. Follow the onscreen instructions

5. In Database Selection

   Select Database type as Microsoft SQL Server; if the backup file is from SQL Server based Controller. Provide required information i.e. Database Address, Port Number, Database Name, Authentication details ii. Click Next to proceed

6. Configure Service Logon Credentials as needed and click Next to continue installation

7. On Restore Database

   1. Select checkbox Do you want to restore database?

   2. Click Browse

   3. Browse to location where the backup file (.bak for SQL Server database) is kept

   4. Select the backup file and click Next

8. Follow onscreen instructions; click Install to start the installation

9. Wait for installation to complete

10. After completion of installation, new HyWorks Controller will be up and running with configurations as per the backup

11. Verify the configurations from HyWorks Controller Management Console

Repair existing HyWorks Controller by restoring the backup

1. Access the Windows server to be configured as HyWorks Controller; which satisfies the following prerequisites

   1. All required prerequisites for HyWorks Controller i.e. DotNet4.5, ASP.Net4.5, SSCE runtime, SQL server and Web Server (IIS roles) are configured

   2. The server is already having an existing installed HyWorks Controller; which should be repaired to restore configurations

2. Invoke HyWorks Installer with administrative rights on the server (where the HyWorks Controller is not installed)

   

3. The Setup wizard will get launched in Maintenance Mode displaying options to Repair and Uninstall; select option Repair, and Click Next

4. Maintenance mode with Repair option provides different configuration screens as most of the configurations as already done during installation. After selecting the Repair option, Administrator will be presented with following screens:

   1. Components Selection Screen to select

   2. Service Logon Credentials

5. On Restore database page

   1. Select checkbox Do you want to restore database?

   2. Click Browse

   3. Browse to location where the backup file (.bak for SQL Server database) is kept

   4. Select the backup file and click Next

6. Proceed till Confirm screen in Setup wizard by providing appropriate details in different screens; Click Repair to start the repair operation as per configured option and provided database backup file

7. After completion of repair operations, existing HyWorks Controller will be repaired with database restored from backup file.

8. Verify the configurations from HyWorks Controller Management Console

Configurations not supported for restore

Following types of HyWorks Controller configurations cannot be restored using backup file and thus the restore should not be attempted on such production configurations.

• HyWorks Controller configured to use SQL Server database on Remote machine

  The backup itself will get failed with appropriate error and even when some backup file is available, the restore should not be attempted.

• HyWorks Controllers in Cluster Configuration

  It is not recommended to attempt restoring primary or secondary HyWorks Controller in cluster configuration though backup can be taken successfully.

  Basically Controllers in cluster do not require restoration as the configurations and data is automatically getting synced. Both of the restore purposes can be easily achieved in HyWorks Controller cluster. Look for restore process in HyWorks Controller Cluster environment for details. Refer section Restore HyWorks Controller for details.

Troubleshooting

Duplicate Controller Entry after restore

Secondary controller entry will be automatically added when HyWorks Controller is installed using backup database using SQL Server as database.

Procedure to remove secondary controller entry:

1. Login into HyWorks management console

2. Go to Server -> HyWorks Controller section

3. Verify the duplicate entries being present of same server

4. Click Delete displayed against one of the entry to remove the secondary controller entry

Manually configure permission for SQL Server on default Backup Directory

This one-time configuration can help in achieving convenient way of backup restore from the default directory and avoiding any possible permission issue on server.

The intention is providing full control to MSSQLSERVER account on the default backup directory; which is

C:\Windows\TEMP\DB\BACKUP\

Follow the below steps to configure permissions on this backup folder:

1. Log into the server. (The change must be made on the actual server, not through a network share.)

2. Select the backup folder highlighted below and Right-click -> Select option Properties

   

3. In Properties -> Security -> Click Edit

   

4. In Security dialog, Click Add

   

5. In Add User dialog

   1. Change the Locations to the local server name.

   2. Type in NT SERVICE\MSSQLSERVER in the name box. (Do not click Check Names)

   3. Click OK. You will then see a list of the matching service accounts. Select MSSQLSERVER, and click OK to accept the selection.

      

      

You should see the service account listed in the security settings, and can adjust the permissions accordingly.