Maintenance

Backup / Restore

Data Backup for Helios 3D

To minimize potential damage in case of data loss, we recommend regularly backing up your data. Additionally, all data should be backed up as a precaution before performing updates. Although we thoroughly test our updates before release, we cannot foresee all possible scenarios in unfamiliar environments.

A complete data backup for Helios 3D involves backing up both the database and parts of the program installation. This is necessary because the planning data is partially stored in the drawings and partially in the database.

We recommend the following procedure:

• Create at least one copy of your project and library folders, whose paths you have configured in the Helios 3D system settings.

• Back up the database. For this, you will need SQL Server Management Studio. A detailed guide can be found on the Microsoft website. Ideally, this should be done by your IT specialist.

Starting with HELIOS 3D 2017, any user with full access to the SQL Server can also back up the database directly from the application.

As part of an update, you can create a complete copy of the Helios 3D environment, ensuring that you have a functional version of the old environment in case issues arise after the update.

Follow these steps:

• Copy the entire Helios 3D installation, including the installation folder, project folder, and library folder, if applicable.

• Copy the database by creating a backup and restoring it under a new name. To do this, you will need SQL Management Studio, which can be downloaded from Microsoft.

• Launch the copied Helios 3D version and connect to the copied database during login.

• Update the paths in the Helios 3D system settings (base program path, project base path, library base path) to point to the copied directories.

For future updates, you only need to specify the correct database. The program files will automatically be accessed using the paths defined in teh last step.

Restoring HELIOS 3D Backups

Every update from STÖHR+SAUER GmbH is thoroughly tested before release. However, issues may still arise on user systems that were not detected in our test environments. In such cases, our support team is available via email at helios3D@stoehr-sauer.de or by phone at +49 (0)2405 4137 0.

You can find the current version numbers of your installation in the readme.txt file in your installation directory (e.g., „C:\Helios3D“). At the top of the document, you will find the program and database version.

The following example from update 2020.0.1.5 shows that there have been no changes to the database since version 2020.0.1.0.

======================================================================
New Version: 2020.0.1.5
DB Version: 2020.0.1.0
Status: 07.02.2020
Operating System: Windows 8, 8.1, 10
AutoCAD: Autodesk AutoCAD Civil 3D 2020 (64 Bit)
======================================================================

Thus, the database only needs to be restored if you want to revert to a program version older than 2020.0.1.0. In this case, versions for earlier Autodesk Civil 3D releases would be affected (e.g., Helios 3D 2019.0.1.x).

Restoring the Program Files

In this step, only the “Bin” directory in the main installation folder is replaced. For local installations, the default directory is “C:\Helios3D”.

• Rename the current “Bin” directory so that it is not completely lost.

• Navigate to the “Backups” folder and locate the appropriate backup. Copy this backup into the main directory.

• Rename the folder “Bin_Date_Time” to “Bin”.

• Falls die Wiederherstellung der Datenbank nicht notwendig ist, können Sie Helios 3D wieder, wie gewohnt, starten und sehen die alte Programmversion.

If restoring the database is not necessary, you can start Helios 3D as usual and see the old program version.

Restoring the Database

To perform these steps, you need to log in to the SQL Server using SQL Management Studio. This program allows you to restore a backup, provided you have the appropriate permissions.

Each Helios 3D update generates a backup in the SQL Server’s backup directory. For local installations, the backup is also local, but for network SQL Servers, the displayed program path refers directly to the corresponding server!

„C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS\MSSQL\Backup“

Procedure:

• Ensure that the database catalog is not in use, meaning that Helios 3D should not be running anywhere!
• Start SQL Management Studio and log in to the SQL Server. You will need administrative rights, so we recommend using the ’sa‘ user account. You can find the server name and application database catalog in the login dialog of Helios 3D.
• Select the Helios3D database after logging in.
• Right-click on the database, then navigate to Tasks -> Restore -> Database.
• In the following dialog, select the “Device” option and open the selection dialog. Click <Add> and choose the backup. The path for the SQL Server’s backup directory is pre-selected here.
• Backup files generated by Helios 3D are named as follows:

“DatabaseName_#Version#Date#_Time.bak”

• The entry will then appear in the selection dialog, and you can confirm by clicking .
• The backup will now appear under “Backup sets to restore”, and you can proceed by clicking.

Updates

During the program startup, Helios 3D checks for available updates and displays them. You can then decide whether to install the update immediately or save it for later installation.

In Helios 3D, you can search for updates by clicking on the

symbol. This opens a menu that allows you to check for new software updates. Make sure you are connected to the internet to download and install the latest updates.

After installing the updates, you have the option to view the new features or changes introduced by the update.

Moving installations

Moving Helios 3D to a Local Station

This document describes how to move/copy a Helios 3D installation from a station or server to a local workstation. The result will be an exact copy of the same program version.

You will need Microsoft SQL Server Express on the target system, and we recommend using the ‘sa’ account for server login. Additionally, the server collation must be identical at both the source and target systems; otherwise, the database cannot be imported! As long as there are no different country and region settings in Windows, there should be no issues after Step 1.

To move the database, you will need SQL Server Management Studio on both the old station (for export) and the target system (for importing the database). It is available for free download from the Microsoft website.

We recommend the following procedure:

• Install Microsoft SQL Server (Express) on the new computer. The program version should be the same or newer than the old one. (Please note the above instructions regarding server collation and authentication.)

• Copy the database. You can create a backup of the current database and restore it on the new station. Both steps require SQL Management Studio on the stations.It is advisable to use the ‘sa’ account for Helios and ensure that ‘sa’ is also set up on the target SQL Server. Please test that the ‘sa’ account can log in and access the Helios 3D system settings. Otherwise, there may be issues with user permissions.Help for moving or copying databases, as well as for determining server collation, can be found on Microsoft’s website.

• Copy the entire Helios 3D installation directory, including the project and library folders (which may be located outside the installation directory).

You can find the current paths for the project directory and the library directory in the Helios 3D system settings.

• Copy the files to the new workstation, overwriting existing files and folders.

• To set up the Sentinel driver for license key detection and to create a desktop shortcut, run .\Client Setup\setup.exe from the program folder.

• Start the copied Helios 3D from the new workstation and connect to the new database. Go to the Helios 3D system settings and adjust the paths if necessary (program, project, and library base paths).

Moving Helios 3D to the Network

This document describes the process of moving/copying a Helios 3D installation from a workstation to a server. The result is an exact copy of the same program version as a network installation, allowing multiple clients to connect.

Please do not attempt to change the program version of Helios 3D during this process, such as upgrading to a newer version at the same time! You can either update the old installation first and then begin the move, or update the moved installation after it has been tested.

In any case, you will need a Microsoft SQL Server Express on the target system, with the recommended server login via the ’sa‘ account. Additionally, the server collation at both the source and target must always be identical; otherwise, the database cannot be imported! As long as there are no different country and region settings in Windows, there should be no issues here.

To move the database, you will need SQL Server Management Studio for exporting from the old workstation and importing it on the target system. If all servers have network access enabled, this can be done from a single workstation; otherwise, SQL Server Management Studio must be installed on both. It is available for free download from the Microsoft website.

In the following figure, you can see the basic structure of a network installation with all network communications. Please note:

• A single server can be used for everything.
• The license server is not required for single-user licenses.
• The Projects and Library directories can also be outsourced to another server.

We recommend the following approach:

• Install a Microsoft SQL Server (Express) on the new server. The program version should match the old one or be more recent (please follow the above notes regarding server collation and authentication).

• Copy the database. For this, you can, for example, create a backup of the current database and restore it on the prepared SQL server. Both steps require SQL Management Studio. It is recommended at this point to ensure that the „sa“ account can be used for Helios 3D and that „sa“ is also set up on the target SQL server! Please test that the „sa“ account can log in and access the Helios 3D system settings. Otherwise, there may be issues with user permissions. You can find assistance for moving or copying databases, as well as for determining the server collation, on the Microsoft website.

• Copy the entire Helios 3D installation directory, including the project and library folders (which may be outsourced from the installation directory). You can find the current paths for the project directory and library directory in the Helios 3D system settings.

• Insert the copy on a server drive. All users need write access to the Helios 3D directory.

• Run the setup.exe from the „Client Setup“ folder of the Helios 3D installation. This will register the workstation and, if necessary, install the Sentinel driver for license detection.

• Launch Helios 3D from the first workstation (the desktop link will have been updated by the Client Setup) and log in to the new database. Go to the Helios 3D system settings and adjust the paths accordingly (program, project, and library base paths). These specified paths will then be used by every workstation. For network installations, please ensure that each path is valid for every workstation (e.g., check drive letters).

• Client setup: You can now set up additional clients (workstations) by running the Client Setup. For existing clients, only the shortcut needs to be updated. To do this, run the setup.exe in the „Client Setup“ subdirectory of the program folder. By default, launching Autodesk Civil 3D from the network is disabled. Therefore, you need to edit the Acad.exe.Config file in a client’s installation directory using the Windows Editor. The original is usually located in: „C:\Program Files\Autodesk\AutoCAD Version#“.

You can safely copy the file and manually adjust it or replace it with the file of the same name from the Helios 3D installation directory.

To manually adjust the file, find the first <runtime> section and add the following line in red:

<runtime>
            <loadFromRemoteSources enabled=“true“/>
</runtime>

Adjusting old clients after a move:

Starting from HELIOS 3D version 2017, you also need to adjust or replace the Autodesk Civil 3D profile to ensure that the HELIOS 3D DLLs are not loaded from the old directory. The easiest way is to delete the profile (usually named „Helios3D“) in the Autodesk Civil 3D options. The profile should be automatically recreated by Helios upon the next start of AutodeskCivil 3D. Personal settings in the Autodesk Civil 3D profile will, of course, be lost.